Hi, I'm new with .Net and have a question about updating DataSets back to the database. I have a basic sample as follows:
SqlDataAdapter myDA = new SqlDataAdapter("Select * from Table_Test", myConn);
SqlCommandBuilder objCommandBuilder = new SqlCommandBuilder(myDA);
The above works, but I was wondering what happens if I have multiple DataSets created at different times in an application, how would I know the the Select statement or command used to assign to the Data Adapter each time i want to update a DataSet back to the database? Would I have to track the command used to build each DataSet or is there a way to build/parse that command from the individual DataSets through it's properties.