Q: datset fill

[Guest]

If my dataset contains more than one table, and my sqlSelectCommand is only
selecting from one table, does sqlDataAdapter1.Fill(dataSet11) know which
table it should update?

 

[TDAVISJR]

Its a good idea to pass it the table that you want to fill. I think you can
do something like this:

sqlDataAdapter1.Fill(dataSet11, "YourTableName")

 

[Guest]

Ok. aberrantly no help on this site.
it seems this works. sqlDataAdapter1.Fill(dataSet11.Tables[currentTableName]);

 

[Guest]

Thanks TDAVISJR. I did not see you reply. Thanks, works fine.