Prerequisites: Database AAA, with table BBB, field is b varchar (10) code as follows: private void button1_click (object sender, system.eventargs e) {dataable dt = (data) this.DataGrid1.datasource;
System.Data.SqlClient.SqlConnection sqlConn = new SqlConnection ( "user id = sa; pwd = 123; data source = (local); persist security info = False; initial catalog = aaa"); System.Data.SqlClient.SqlCommand sqlCmd = New SQLCOMMAND ("Select * from bbb", sqlconn; system.data.sqlclient.sqldataadapter sqladap = new sqldataadapter (SQLCMD);
System.data.sqlclient.sqlcommandbuilder sqlbuild = new sqlcommandbuilder (sqlconn.open (); sqladap.Update (DT); sqlconn.close ();}
Private Void Form2_Load (Object Sender, System.Eventargs E) {
DataTable DT = New DataTable ();
System.Data.SqlClient.SqlConnection sqlConn = new SqlConnection ( "user id = sa; pwd = 123; data source = (local); persist security info = False; initial catalog = aaa"); System.Data.SqlClient.SqlDataAdapter sqlAdap = New SqldataAdapter ("SELECT * FROM BBB", SQLCONN);
Sqlconn.open (); SQLADAP.FILL (DT); sqlconn.close ();
THIS.DATAGRID1.DATASOURCE = DT;
}
