using System; using System.Data; using System.Data.SqlClient; using System.Windows.Forms; private SqlConnection conn; private SqlDataAdapter da; private DataSet ds; private SqlCommandBuilder cb; conn = new SqlConnection(@"server=.;database=test;uid=sa;pwd=123"); da = new SqlDataAdapter("select * from student", conn); ds = new DataSet(); cb = new SqlCommandBuilder(da); da.Fill(ds, "student"); dataGridView1.DataSource = ds.Tables["student"]; private void btnSave_Click(object sender, EventArgs e) { da.Update(ds, "student"); MessageBox.Show("保存成功"); } private void btnDel_Click(object sender, EventArgs e) { if (dataGridView1.SelectedRows.Count > 0) { dataGridView1.Rows.Remove(dataGridView1.SelectedRows[0]); } }

网友分享一

首先，连接数据库：SqlConnection con = new SqlConnection(connectionString); 然后创建DataGridView绑定数据：SqlDataAdapter adapter = new SqlDataAdapter("SELECT * FROM Users", con); DataTable dt = new DataTable(); adapter.Fill(dt); dataGridView1.DataSource = dt; 新增：直接在DataGridView中输入数据，点击保存按钮调用Update命令。删除：选中行，dataGridView1.Rows.RemoveAt(rowIndex); 修改：编辑单元格后保存。超级简单，新手直接抄代码。

网友分享二

DataGridView增删改查完整代码： private void LoadData() { string sql = "SELECT Id, Name, Age FROM Students"; SqlDataAdapter sda = new SqlDataAdapter(sql, connection); DataTable dt = new DataTable(); sda.Fill(dt); dataGridView1.DataSource = dt; } private void btnAdd_Click(object sender, EventArgs e) { DataRow dr = ((DataTable)dataGridView1.DataSource).NewRow(); dr["Name"] = txtName.Text; dr["Age"] = txtAge.Text; ((DataTable)dataGridView1.DataSource).Rows.Add(dr); } private void btnDelete_Click(object sender, EventArgs e) { if (dataGridView1.CurrentRow != null) { int index = dataGridView1.CurrentRow.Index; ((DataTable)dataGridView1.DataSource).Rows[index].Delete(); } } private void btnUpdate_Click(object sender, EventArgs e) { SqlCommandBuilder builder = new SqlCommandBuilder(sda); sda.Update((DataTable)dataGridView1.DataSource); }

网友分享三

新手必备！DataGridView操作SQL数据库：1.添加命名空间：using System.Data.SqlClient; 2.连接字符串：string connStr = "Data Source=localhost;Initial Catalog=mydb;Integrated Security=True"; 3.加载数据：DataSet ds = new DataSet(); new SqlDataAdapter("select * from table1", conn).Fill(ds); dgv.DataSource = ds.Tables[0]; 4.增：dgv.Rows.Add(new object[] {txt1.Text, txt2.Text}); 改：在格子编辑。删：dgv.Rows.Remove(dgv.CurrentRow); 查：直接SQL。5.保存：SqlCommandBuilder scb = new SqlCommandBuilder(adapter); adapter.Update(ds, "table1"); 一步到位。

网友分享四

实战代码分享： public Form1() { InitializeComponent(); string connstring = "server=.;database=Northwind;uid=sa;pwd=;"; SqlConnection conn = new SqlConnection(connstring); string sql = "select * from Categories"; SqlDataAdapter da = new SqlDataAdapter(sql, conn); DataSet myds = new DataSet(); da.Fill(myds); dataGridView1.DataSource = myds.Tables[0]; SqlCommandBuilder cb = new SqlCommandBuilder(da); da.UpdateCommand = cb.GetUpdateCommand(); da.InsertCommand = cb.GetInsertCommand(); da.DeleteCommand = cb.GetDeleteCommand(); } 按钮事件：da.Update(myds, "Categories"); 完美支持增删改查。

网友分享五

简单教程：DataGridView1.ReadOnly = false; AllowUserToAddRows = true; 绑定后，用户可以直接输入删除。保存时： private void Save() { try { SqlCommandBuilder builder = new SqlCommandBuilder(adapter); adapter.Update(dataSet, "Table"); MessageBox.Show("更新成功!"); } catch (Exception ex) { MessageBox.Show(ex.Message); } } 新手复制粘贴就能用。

网友分享六

完整示例：加载： private void button1_Click(object sender, EventArgs e) { SqlConnection sqlcon = new SqlConnection(strConn); SqlDataAdapter sqldaper = new SqlDataAdapter("select * from tb_user", sqlcon); DataSet dataset = new DataSet(); sqldaper.Fill(dataset); dataGridView1.DataSource = dataset.Tables[0]; } 保存更改：SqlCommandBuilder sqlcb = new SqlCommandBuilder(sqldaper); sqldaper.Update(dataset); 增删改查全搞定。

FAQ
Q: 如何连接SQL Server数据库？
A: 用SqlConnection conn = new SqlConnection("server=.;database=你的库;uid=sa;pwd=密码");
Q: DataGridView怎么刷新数据？
A: 调用da.Fill(ds, "表名"); dataGridView1.DataSource = ds.Tables[0];
Q: 保存修改为什么报错？
A: 记得创建SqlCommandBuilder cb = new SqlCommandBuilder(da); 然后da.Update(ds, "表名");
Q: 新增行怎么加？
A: 设置AllowUserToAddRows = true; 或者手动dataGridView1.Rows.Add(值数组);
Q: 删除行后怎么保存到数据库？
A: 先Rows.Remove，然后da.Update(ds);