DataSet ds = new DataSet();
string str = "select * from UserInfo";
SqlDataAdapter da = new SqlDataAdapter(str,conn);
da.Fill(ds,"userinfo");
dataGridView1.DataSource = ds.Tables["userinfo"]; //dataGridView1显示UserInfo数据要怎么实现下面的功能:
用户直接在dataGridView1显示的的数据上面修改,然后要点击保存按钮,把修改后dataGridView1上的数据更新到数据库里,应该怎么做呢?
string str = "select * from UserInfo";
SqlDataAdapter da = new SqlDataAdapter(str,conn);
da.Fill(ds,"userinfo");
dataGridView1.DataSource = ds.Tables["userinfo"]; //dataGridView1显示UserInfo数据要怎么实现下面的功能:
用户直接在dataGridView1显示的的数据上面修改,然后要点击保存按钮,把修改后dataGridView1上的数据更新到数据库里,应该怎么做呢?
//自动生成更新数据的命令
sqlCommandBuilder cb=new sqlCommandBuilder(da);
//修改的数据保存到数据库
da.Update(ds,"表名");
private SqlDataAdapter SDA = new SqlDataAdapter();
try
{
SqlCommandBuilder SCB = new SqlCommandBuilder(SDA);
SDA.Update(DT);
}
catch (System.Exception ex)
{
MessageBox.Show(ex.ToString());
return;
}
MessageBox.Show("更新成功!");
{
public Form1()
{
InitializeComponent();
}
OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=db1.mdb");
DataSet ds = new DataSet();
string str = "select * from biao"; private void Form1_Load(object sender, EventArgs e)
{
OleDbDataAdapter da = new OleDbDataAdapter(str, conn);
da.Fill(ds,"b");
dataGridView1.DataSource = ds.Tables["b"]; } private void button1_Click(object sender, EventArgs e)
{
//这里应该怎么写呢?
}
}不好意思,我实在太菜了,照上面那么写后,调试不出来~麻烦帮我看下button1里面该怎么写好吗?
是要实现Button1的什么功能噢
一二三楼是正解,谢谢个位.
顺便把代码发上来,好给和我一样菜的新手参考,呵呵
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=db1.mdb");
string str = "select * from biao";
DataSet ds = new DataSet();
OleDbDataAdapter da; private void Form1_Load(object sender, EventArgs e)
{
da = new OleDbDataAdapter(str, conn);
da.Fill(ds,"b");
dataGridView1.DataSource = ds.Tables["b"]; } private void button1_Click(object sender, EventArgs e)
{
//自动生成更新数据的命令
OleDbCommandBuilder cb = new OleDbCommandBuilder(da);
//修改的数据保存到数据库
da.Update(ds.Tables["b"]);
MessageBox.Show("成功");
}
}