Please help. I go through creating the DataSet Object in Step 3. I test the Select and it returns data:

**********************************************
0 3 5 What Instance of SSE do we normally use? SSE, by default, installs with its own instance. R
1 4 1 Why do we sometimes use drivers and sometimes to p OLEDB uses providers; ODBC used drivers. Although
2 5 2 What is the default value for AutoGenerateColumns The defaults for AutoGenerateColumns are a little
3 6 4 What is the write functionality difference between Like GridView, DetailsView supports editing and de
4 7 5 What does the EmptyDataRow property describe? The terminology here is confusing. EmptyDataRow im
*******************************************

HOWEVER, when I try to proceed with step 4, I drop the Gridview on and point it's datasource to the GridView2 and I get only 3 columns--ScoreID, FAQID, & Score (Yes, I'm pointing to the new method in ObjectDataView).

Then..when I try to run the page, I get:

Server Error in '/FAQ' Application.
--------------------------------------------------------------------------------

Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.ConstraintException: Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.

Source Error:


Line 699: this.Adapter.SelectCommand = this.CommandCollection[1];
Line 700: Scores.ScoresDataTable dataTable = new Scores.ScoresDataTable();
Line 701: this.Adapter.Fill(dataTable);
Line 702: return dataTable;
Line 703: }



WHAT am I doing wrong???

Regards,
Rob

I'm still not sure why the drag and drop of the Gridview doesn't work, but I avoided creating the DataSet manually and created my own object that fills a dataset and returns it (see below) and it works. I use the same "Select" statement in the book in my own class. Not sure why the manual dataset gets the errors below. Like I said, when I test the Dataset alone in the .xsd file, it returns (as seen below)...I drag the objectdataset and then drag a gridview and point it to it and I get errors.

Go Figure.

Public Class MyDataObject
    Public Function GetAverageScores() As DataSet
        Dim connStr As String = ConfigurationManager.ConnectionStrings("FaqDatabas eConnectionString1").ConnectionString
        Dim conn As SqlConnection = New SqlConnection(connStr)
        Dim query As String = "SELECT Scores.FAQID, AVG(Scores.Score) AS ScoreAvg, LEFT(FAQs.FaqQuestion, 50) AS FaqQuestionShort, LEFT(FAQs.FaqAnswer, 50) AS FaqAnswerShort FROM Scores INNER JOIN FAQs ON Scores.FAQID = FAQs.FaqID GROUP BY Scores.FAQID, FAQs.FaqQuestion, FAQs.FaqAnswer ORDER BY Scores.FAQID"
        Dim adapter As SqlDataAdapter = New SqlDataAdapter(query, conn)
        Dim ds As DataSet = New DataSet
        adapter.Fill(ds)
        Return ds
    End Function
End Class

Regards,
Rob