c# 数据库 sqlcommandbuilder

[s15981924260]

private void button1_Click(object sender, EventArgs e)
{
this.sqlConnection1.Open();
string st="Select * from users";
SqlCommand cmd = new SqlCommand(st, sqlConnection1);
SqlDataAdapter sd = new SqlDataAdapter(cmd);
SqlCommandBuilder cb = new SqlCommandBuilder(sd);
sd.SelectCommand = cmd;
sd.UpdateCommand = cb.GetUpdateCommand();
sd.InsertCommand = cb.GetInsertCommand();
sd.DeleteCommand = cb.GetDeleteCommand();
ds.Clear();
sd.Fill(ds, "users");
this.dataGridView1.DataSource = ds.Tables["users"];
DataTable dt = ds.Tables["users"];
DataRow dr = ds.Tables["users"].Rows[this.dataGridView1.CurrentRow.Index];
dr.BeginEdit();
for (int i = 0; i < ds.Tables["users"].Columns.Count; i++)
{
dr[i] = this.dataGridView1.CurrentCell.Value;
}
dr.EndEdit();
DataRow dr1 = dt.NewRow();
for (int i = 0; i < ds.Tables["users"].Columns.Count; i++)
{
dr[i] = this.dataGridView1.CurrentCell.Value;
}
dt.Rows.Add(dr1);
DataRow dr2 = dt.Rows[this.dataGridView1.CurrentRow.Index];
dr2.Delete();
dr2.AcceptChanges();

sd.Update(ds.Tables["users"]);
sqlConnection1.Close();}
能不能 一个button 控件 实现 添加 删除 修改操作 如果能怎麽做 另外 sd.UpdateCommand = cb.GetUpdateCommand();
sd.InsertCommand = cb.GetInsertCommand();
sd.DeleteCommand = cb.GetDeleteCommand();
这三个怎麽用 要在datagriew里进行 上述三个操作 怎麽做

[s15981924260]

我的意思是 在datagriew里 进行添加 删除 修改 然后点击 button 控件 更新数据库 由程序本身判断是那种操作

[Hauk]

        private void Form1_Load(object sender, EventArgs e)
        {
            string connString = "server=.;database=TestDB;uid=sa;pwd=1qaz@wsx#EDC";
            string sql = "select * from U_Info";

            this.dataGridView1.DataSource = GetData(connString, sql);
        }

        private SqlDataAdapter sda;
        private DataTable GetData(string connString, string selectTxt)
        {
            SqlConnection conn = new SqlConnection(connString);
            SqlCommand cmd = conn.CreateCommand();
            cmd.CommandText = selectTxt;
            sda = new SqlDataAdapter(cmd);
            SqlCommandBuilder scb = new SqlCommandBuilder(sda);
            DataTable dt = new DataTable();
            sda.Fill(dt);
            return dt;
        }

        private void dataGridView1_CellEndEdit(object sender, DataGridViewCellEventArgs e)
        {
            sda.Update((DataTable)this.dataGridView1.DataSource);
        }

给你一个简单demo，可以增、删、改、查

[蝶恋花雨]

http://blog.csdn.net/21aspnet/article/details/1540301 C#精髓 第四讲 GridView 72般绝技 里面有 看完你就会了/ http://www.cnblogs.com/huangjianhuakarl/archive/2009/02/03/1381710.html

[Forrest23]

参考 datatable 使用SqlDataAdapter.Update批量插入更新数据--代码三人帮

[Change_L]

引用 5 楼 haukwong 的回复:

this.sqlConnection1.Open(); string st="Select * from users"; SqlCommand cmd = new SqlCommand(st, sqlConnection1); SqlDataAdapt……

没有红色的代码可以吗？

[Hauk]

this.sqlConnection1.Open(); string st="Select * from users"; SqlCommand cmd = new SqlCommand(st, sqlConnection1); SqlDataAdapter sd = new SqlDataAdapter(cmd); SqlCommandBuilder cb = new SqlCommandBuilder(sd); sd.SelectCommand = cmd; sd.UpdateCommand = cb.GetUpdateCommand(); sd.InsertCommand = cb.GetInsertCommand(); sd.DeleteCommand = cb.GetDeleteCommand(); LS给的例子，和LZ的代码都有红色的代码，其实这些代码完全是多余的。