Hi,
Here is my new code. Am I on the right track?
Also, I am now getting an error message: "Unable to cast object of type 'System.Data.DataTable' to type ..." Do you know what this means?
int TestID = 999999;
BindingSource bindingSource1 = new BindingSource();
SqlConnection myConnection = new SqlConnection(Assignment_Utility.Properties.Settings.Default.ConnectionString);
SqlDataAdapter mySqlDataAdapter = new SqlDataAdapter("Select * from Assignment where TestID = " + TestID.ToString(), myConnection);
SqlCommandBuilder cb = new SqlCommandBuilder(mySqlDataAdapter);
DataTable ds_Assignment = new DataTable();
mySqlDataAdapter.Fill(ds_Assignment);
bindingSource1.DataSource = ds_Assignment;
mySqlDataAdapter.Update((ds_Assignment)bindingSource1.DataSource);