Using the GetChildRows method C#

  • Thread starter Thread starter Karl
  • Start date Start date
K

Karl

I am new to .net.

I am populating a dataset with a few tables using stored
procedures successfully and then setting primary keys and
relations between table columns.

BUT when I go to use the GetChildRows method my relations
arent returning any child rows.

Is there a better way of assigning the source table's
primary/foreign key relationships to the dataset?

Help is much appreciated.
 
Hi Karl,

You might want to consider using strong typed datasets - created at design
time.
 
Karl,

If you could demonstrate the behavior you're seeing with a
small snippet of sample code, there's a better chance that
someone will be able to help you to get the code to work properly.

I hope this information proves helpful.

David Sceppa
Microsoft
This posting is provided "AS IS" with no warranties,
and confers no rights. You assume all risk for your use.
© 2003 Microsoft Corporation. All rights reserved.
 
I am using the
"dataSet.MissingSchemaAction = MissingSchemaAction.AddWithKey;"
method to copy the source schema info into my dataset.

It works fine when I give my command object normal sql, ie, "SELECT *
FROM table2 WHERE table2ID = 'table1'

BUT when I give my command object the name of a stored procedure it says
there is a syntax error which I know to be incorrect.
 
Back
Top