我要使用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;
}
}
{
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;
}
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货