Trying To Update My Database...............

hello,

i use the following code to retrieve the contents of the table present in the sql server to be displayed on a datagridview.

SqlConnection sqlCN = new SqlConnection(connectionString);

sqlCN.Open();

string selectCommandText = "SELECT * from test2";

SqlCommand sqlCmd = new SqlCommand(selectCommandText, sqlCN);

sqlCmd.ExecuteNonQuery();

SqlDataAdapter sqlDA = new SqlDataAdapter(selectCommandText, sqlCN);

DataSet DS = new DataSet();

sqlDA.Fill(DS);

DataGridView1.DataSource = DS.Tables[0].DefaultView;



I use the cellContentClick event to modify the contents of dataGridView.

Is it possible for me to update the table directly ie., updating the adapter or table with the corresponding row index and column index so that it will be reflected in the database( if so pls give me a sample code ) or Do i need to retrieve all the values from the datagridview and need to use the sql update command.........

pls reply asap....



-Sweety