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);