求datagridview和数据库的数据同步更新方法
我要使用datagridview和一个sqlserver数据表进行数据同步更新,即我在datagridview里进行更改,增减,数据库里的表也同步进行修改。我查询了MSDN上的方法~它使用了commandBuild 对象和adapter进行绑定。但是还是不能同步~我用datagridview使用数据绑定进行绑定后也不能同步~跪求帮助
private void Form1_Load(object sender, EventArgs e)
{
DataTable table = new DataTable();
string connStr = "Server=(local);Integrated Security=SSPI;Initial Catalog=test";
table = SelectSqlRows(connStr, "select * from orderinfo");
dataGridView1.DataSource = table;
}
public static DataTable SelectSqlRows(string connectionString,string queryString)
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = new SqlCommand(queryString, connection);
SqlCommandBuilder builder = new SqlCommandBuilder(adapter);
connection.Open();
DataTable dataSet = new DataTable();
adapter.Fill(dataSet);
//code to modify data in DataSet here
builder.GetUpdateCommand();
//Without the SqlCommandBuilder this line would fail
adapter.Update(dataSet);
return dataSet;
}
}
--------------------编程问答--------------------
跪求大家帮助啊~!在线等
补充:.NET技术 , C#