using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Data.SqlClient;using System.Drawing;using System.Text;using System.Windows.Forms;
namespace DataSource { public partial class Form1 : Form { public Form1() { InitializeComponent(); }
private DataSet ds = new DataSet(); private SqlConnection conn = null; private SqlDataAdapter da = null; private const string DRIVER =
"server=.;database=northwind;uid=sa;pwd=sa"; private const string sql_select = "select * from
region";
private void Form1_Load(object sender, EventArgs e) { conn = new SqlConnection(DRIVER); da = new SqlDataAdapter(sql_select,conn); da.Fill(ds,"table"); this.dataGridView1.DataSource = ds.Tables
["table"].DefaultView; }
private bool BtnInsert() //此方法作用于添加 { da.InsertCommand = conn.CreateCommand(); da.InsertCommand.CommandText = "insert into region
values(@id,@ption)"; da.InsertCommand.Parameters.Add("@id", SqlDbType.Int, 4,
"regionid"); da.InsertCommand.Parameters.Add("@ption",
SqlDbType.VarChar, 10, "regiondescription"); int count = da.Update(ds); bool result = count > 0 ? true : false; return result; } private void button1_Click(object sender, EventArgs e) { if (this.BtnInsert())//调用此方法 { MessageBox.Show("添加成功!"); } else { MessageBox.Show("添加失败!"); } }
private bool BtnDelect() //此方法作用于删除 { SqlParameter sp = new SqlParameter(); da.DeleteCommand = conn.CreateCommand(); da.DeleteCommand.CommandText = "delete region where
来源：(http://blog.sina.com.cn/s/blog_665a1a1d0100hxap.html) - 在C#中使用控件DataGridView实现数据库增删改查_libraliu_新浪博客
regionid=@id"; sp = da.DeleteCommand.Parameters.Add("@id",
SqlDbType.Int, 4, "regionid"); sp.SourceVersion = DataRowVersion.Original; ds.Tables["table"].Rows
[this.dataGridView1.CurrentRow.Index].Delete(); int count = da.Update(ds); bool result = count > 0 ? true : false; return result; } private void button2_Click(object sender, EventArgs e) { if (this.BtnDelect())//调用删除方法 { MessageBox.Show("删除成功!"); } else { MessageBox.Show("删除失败!"); } }
private bool BtnUpdate() //此方法作用于修改 { SqlParameter sp = new SqlParameter(); da.UpdateCommand = conn.CreateCommand(); da.UpdateCommand.CommandText = "update region set
regionid=@id,regiondescription=@ption where
regionid=@oldid";
da.UpdateCommand.Parameters.Add("@id", SqlDbType.Int, 4,
"regionid"); da.UpdateCommand.Parameters.Add("@ption",
SqlDbType.VarChar, 10, "regiondescription");
sp = da.UpdateCommand.Parameters.Add("@oldid",
SqlDbType.Int, 4, "regionid"); sp.SourceVersion = DataRowVersion.Original; int count = da.Update(ds); bool result = count > 0 ? true : false; return result; } private void button3_Click(object sender, EventArgs e) { if (this.BtnUpdate())//调用修改方法 { MessageBox.Show("修改成功!"); } else { MessageBox.Show("修改失败!"); } }
}}
