我想从数据源取东西放在datagridview上,通过datagridview的增删改再改变数据源。代码写出来,实现不了,请大家帮忙看下。最好是通过两个按钮来实现,一个查询,一个确定修改.
代码如下:
string rateSql = string.Format(@"select r_time_int,r_time_unit,r_rate from rate where r_p_id = {0}", productId);
OleDbCommand rateSqlCmd = new OleDbCommand(rateSql, DBHelper.conn);
OleDbDataAdapter rateSqlAdp = new OleDbDataAdapter(rateSqlCmd);
ds = new DataSet();
rateSqlAdp.Fill(ds);
DataTable dt = ds.Tables[0];
OleDbCommandBuilder cmdb = new OleDbCommandBuilder(rateSqlAdp);
rateSqlAdp.Update(ds);
dataGridView1.DataSource = dt;