datagridview 通过dataset绑定了A表,字段为 select userid ,usernam,'' as chanliang from sys_groupdetail;
在datagridview 修改了chanliang(产量)之后,希望增加几个字段保存到另外一个表 sys_completework 中去
另外一个表为:select docno,docdate,userid,chanliang from sys_completework;
一下是网上拷贝来的代码,说Datagridview的Update方法只能修改单表。
我这种情况要这么实现。
using System.Data;
using System.Data.SqlClient;
public partial class Form1 : Form
{ DataSet ds =new DataSet();
SqlDataAdapter da=new SqlDataAdapter();
SqlCommandBuilder cb=new SqlCommandBuilder();
SqlCommand cmd=new SqlCommand();
private string sql = "select * from TEST_Table";
private string connString = "Data Source=.;User ID=sa;Password=123;Initial Catalog=Test;";
private void Form1_Load(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection(connString);
SqlDataAdapter da = new SqlDataAdapter(sql, conn);
// cmd = conn.CreateCommand();
// cmd.CommandText = "select * from TEST_Table";
// SqlDataAdapter da = new SqlDataAdapter(cmd);
// private string tableName = "test";
//da.Fill(ds, "test");
//dataGridView1.DataSource = ds.Tables[tableName];
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
} private void button1_Click(object sender, EventArgs e) //保存修改
{
SqlConnection conn = new SqlConnection(connString);
cmd = conn.CreateCommand();
cmd.CommandText = "select * from Test_Table";
SqlDataAdapter da = new SqlDataAdapter(cmd);
SqlCommandBuilder cb = new SqlCommandBuilder(da);
da.Update(ds);
dataGridView1.Update();
}
}
在datagridview 修改了chanliang(产量)之后,希望增加几个字段保存到另外一个表 sys_completework 中去
另外一个表为:select docno,docdate,userid,chanliang from sys_completework;
一下是网上拷贝来的代码,说Datagridview的Update方法只能修改单表。
我这种情况要这么实现。
using System.Data;
using System.Data.SqlClient;
public partial class Form1 : Form
{ DataSet ds =new DataSet();
SqlDataAdapter da=new SqlDataAdapter();
SqlCommandBuilder cb=new SqlCommandBuilder();
SqlCommand cmd=new SqlCommand();
private string sql = "select * from TEST_Table";
private string connString = "Data Source=.;User ID=sa;Password=123;Initial Catalog=Test;";
private void Form1_Load(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection(connString);
SqlDataAdapter da = new SqlDataAdapter(sql, conn);
// cmd = conn.CreateCommand();
// cmd.CommandText = "select * from TEST_Table";
// SqlDataAdapter da = new SqlDataAdapter(cmd);
// private string tableName = "test";
//da.Fill(ds, "test");
//dataGridView1.DataSource = ds.Tables[tableName];
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
} private void button1_Click(object sender, EventArgs e) //保存修改
{
SqlConnection conn = new SqlConnection(connString);
cmd = conn.CreateCommand();
cmd.CommandText = "select * from Test_Table";
SqlDataAdapter da = new SqlDataAdapter(cmd);
SqlCommandBuilder cb = new SqlCommandBuilder(da);
da.Update(ds);
dataGridView1.Update();
}
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货