//first dataGrid bind to dataview or datatabledataview=dataset1.tables["table"].defaultview; dataGrid1.datasource=dataview dataview.allowedit=true//then modify the data in dataGrid1 ............. //save button click: this.BindingContext[dataview].EndCurrentEdit();dataview.table.acceptchanges();next: use sqlcommandBulider update to sqlserver
http://www.21disk.com/21disk/upload/tjq_tang/00%5BShareFile%5D/2994ReleaseNETCode.exe 是<<ADO与ADO.net编程指南>>的代码(VB.net写的.不过vb.net和C#差别不大的)hope it helps
用SqlCommandBuilder最简单public static DataSet SelectSqlSrvRows(string myConnection, string mySelectQuery, string myTableName) { SqlConnection myConn = new SqlConnection(myConnection); SqlDataAdapter myDataAdapter = new SqlDataAdapter(); myDataAdapter.SelectCommand = new SqlCommand(mySelectQuery, myConn); SqlCommandBuilder cb = new SqlCommandBuilder(myDataAdapter); myConn.Open(); DataSet ds = new DataSet(); myDataAdapter.Fill(ds, myTableName); //code to modify data in DataSet here //Without the SqlCommandBuilder this line would fail myDataAdapter.Update(ds, myTableName); myConn.Close(); return ds; }
dataGrid1.datasource=dataview
dataview.allowedit=true//then modify the data in dataGrid1
.............
//save button click:
this.BindingContext[dataview].EndCurrentEdit();dataview.table.acceptchanges();next:
use sqlcommandBulider update to sqlserver
是<<ADO与ADO.net编程指南>>的代码(VB.net写的.不过vb.net和C#差别不大的)hope it helps
{
SqlConnection myConn = new SqlConnection(myConnection);
SqlDataAdapter myDataAdapter = new SqlDataAdapter();
myDataAdapter.SelectCommand = new SqlCommand(mySelectQuery, myConn);
SqlCommandBuilder cb = new SqlCommandBuilder(myDataAdapter); myConn.Open(); DataSet ds = new DataSet();
myDataAdapter.Fill(ds, myTableName); //code to modify data in DataSet here //Without the SqlCommandBuilder this line would fail
myDataAdapter.Update(ds, myTableName); myConn.Close(); return ds;
}