In C # about updating the database through the DataGrid

datagrid| Data | Database Hey, prawns! I just contacted C #. NET study soon, the original has been in the development of Delphi, a sudden transformation feeling is very uncomfortable, this two days to study how to update the database records through the DataGrid problem, a little harvest, here I put my method posted out for you prawns treatise! Thank you!
Traversing the DataGrid row to update data ******************************************
private void Updatefromdatagrid ()
{
String Update_sql= "";

Start update
System.Data.SqlClient.SqlConnection conn_update=new SqlConnection ();
Conn_update. Close ();
Conn_update. Connectionstring=conntsql;
Conn_update. Open ();

System.Data.SqlClient.SqlCommand comm_update=new SqlCommand ();
Comm_update. Connection=conn_update;

System.Data.SqlClient.SqlDataAdapter Da_update=new SqlDataAdapter ();
Da_update. Updatecommand=comm_update;

Traverses all data in the DataGrid and modifies
for (int i=0;i<=datagrid1.visiblerowcount-2;i++)
{
update_sql= "Update client_manage set Client_name= '" +datagrid1[i,1]. ToString () + "', client_phone= '" +datagrid1[i,2]. ToString () + "', client_address= '" +datagrid1[i,3]. ToString () + "' Where client_id=" +datagrid1[i,0]. ToString ();
Comm_update.commandtext=update_sql;
Comm_update. ExecuteNonQuery ();
}

Close Connection Save network resources
Conn_update. Close ();
}