In my application, i'm trying to create an SqlDataAdapter that i can reuse later. All what i would have to do is change a parameter like this (mAdapZones.SelectCommand.
"].Value = SomeValue) and call the Fill method to get an update, but i have a strange behavior. As soon as the program hit the line where i assign the datasource of the gridZones, when i run the program step by step, i see that all the commands (SelectCommand, InsertCommand and DeleteCommands) get nullified.
mAdapZones.SelectCommand.Parameters["@CustPartCustID"].Value = wCustID.ToString();
mDSZones = new System.Data.DataSet();
gridZones.DataSource = mDSZones.Tables;
Is this a normal behavior? Is there any way i can keep the SqlDataAdapter for later use?