Datagridview update database

Use the datagridview to update a database I am used to the convenient operation of DBGrid in BCB and want to do the same in vs C #, but it is really not easy. I have spent a lot of effort and I am better at it. But it is quite troublesome. This dview is not easy. You can click the button to submit the data... Public Partial Class Form1: Form { Form1 data member # RegionForm1 data member PrivateDatatable dt= NewDatatable (); PrivateSqldataadapter SDA= NewSqldataadapter (); # Endregion form1 constructor # RegionForm1 Constructor PublicForm1 () { Initializecomponent (); } # Endregion Connect to the database and display data # Region Connect to the database and display data Private   Void Form1_load ( Object Sender, eventargs E) { Sqlconnection Conn =   New Sqlconnection ( " Server = 127.0.0.1; database = pubs; uid = sa " ); Sqlcommand SCD =   New Sqlcommand ( " Select * from tables " , Conn ); SDA. selectcommand = SCD; SDA. Fill (DT ); Datagridview1.datasource = DT; } # Endregion Update Database # Region Update Database Private   Void Toolstripbutton#click ( Object Sender, eventargs E) { Try { Sqlcommandbuilder SCB= NewSqlcommandbuilder (SDA ); SDA. Update (DT ); } Catch (System. Exception ex) { MessageBox. Show (ex. tostring ()); Return; } MessageBox. Show ( " Update successful! " ); } # Endregion