setdatabinding to a schema, not a relation

[codefragment]

Hi
I want to bind a datagrid to a dataset for the table
"ProductProductPhoto" in the AdventureWorks database in
SQL Server 2005, however I can't because the binding fails on
Production.ProductProductPhoto, presumably because it thinks theres
some kind of relation in effect here. So how do you do it?

I get the error message: Child list for field Production cannot be
created.

ta

 

[Nicholas Paldino [.NET/C# MVP]]

When is this occuring? When you are creating the data set, or when you
are binding the data set to the table? How are you populating the data set?

 

[codefragment]

When is this occuring? When you are creating the data set, or when you
are binding the data set to the table? How are you populating the data set?

recordsDataGrid.SetDataBinding(recordsDataSet, "ProductProductPhoto");

I populate the dataset using:

SqlDataAdapter adapter = new SqlDataAdapter(queryString,
dataConnection);
adapter.Fill(dataSet, selectedTable);

 

[codefragment]

recordsDataGrid.SetDataBinding(recordsDataSet, "ProductProductPhoto");

I populate the dataset using:

SqlDataAdapter adapter = new SqlDataAdapter(queryString,
dataConnection);
adapter.Fill(dataSet, selectedTable);

ok, using the below is a workaround for now, I'll have to check if
the newer controls have the same problem

recordsDataGrid.DataSource = recordsDataSet.Tables[0];