C#连接sql数据库执行简单的增删改查操作.doc

以users表为例，有三个字段，自增长的编号id，int类型；名称name，nvarchar类型，密码pwd，nvarchar类型 首先在vs2005中引入using System.Data.SqlClient;命名空间 /// summary /// 增加 /// /summary /// param name=name姓名/param /// param name=pwd密码/param /// returns/returns public int Insert(string name,string pwd) { SqlConnection conn = new SqlConnection(@Data Source=.\SQLEXPRESS;Initial Catalog=Test;Integrated Security=True);//Initial Catalog后面跟你数据库的名字,如果你的SqlServer服务器名称后面不带SQLEXPRESS，那么Data Source=. conn.Open(); string sql = insert into users(name,pwd) values(@name,@pwd); SqlCommand cmd = new SqlCommand(sql,conn); SqlParameter parn = new SqlParameter(@name,name); cmd.Parameters.Add(parn); SqlParameter parp = new SqlParameter(@pwd, pwd); cmd.Parameters.Add(parn); int result = cmd.ExecuteNonQuery();//result接收受影响行数，也就是说result大于0的话表示添加成功 conn.Close(); cmd.Dispose(); return result; } /// summary /// 删除 /// /summary /// param name=name姓名/param /// param name=pwd密码/param /// returns/returns public int Update(int id) { SqlConnection conn = new SqlConnection(@Data Source=.\SQLEXPRESS;Initial Catalog=Test;Integrated Security=True);//Initial Catalog后面跟你数据库的名字,如果你的SqlServer服务器名称后面不带SQLEXPRESS，那么Data Source=. conn.Open(); string sql = delete from users where id=@id; SqlCommand cmd = new SqlCommand(sql, conn); SqlParameter parn = new SqlParameter(@id, id); cmd.Parameters.Add(parn); int result = cmd.ExecuteNonQuery();//result接收受影响行数，也就是说result大于0的话表示删除成功 conn.Close(); cmd.Dispose(); return result; } /// summary /// 修改 /// /summary /// param name=name姓名/param /// param name=p