C#使用存储过程实现增删查改的功能实例

---建立数据库study create database student on ( name=study_mdf, filename='D:\sqlshujuku\student.mdf' ) log on ( name=study_ldf, filename='D:\sqlshujuku\student.ldf' ) drop database student --建表 use student go create table xinxibiao ( sname varchar(50) not null primary key, pwd char(10) ) ---建立数据库study create database student on ( name=study_mdf, filename='D:\sqlshujuku\student.mdf' ) log on ( name=study_ldf, filename='D:\sqlshujuku\student.ldf' ) --建表 use student go create table xinxibiao ( sname varchar(50) not null primary key, pwd char(10) not null ) drop table xinxibiao --创建存储过程 --添加 create proc addxinxi @sname varchar(50),@pwd char(10) as insert into xinxibiao(sname,pwd) values (@sname,@pwd) drop proc indexxinxi --删除 create proc deletexinxi @sname varchar(50) as delete xinxibiao where sname=@sname --修改 create proc updatexinxi @sname varchar(50),@pwd char(10) as update xinxibiao set pwd=@pwd where sname=@sname --查询 create proc indexxinxi @sname varchar(50) as select * from xinxibiao where sname=@sname --执行存储过程 exec addxinxi '黎明','001' exec deletexinxi '黎明' exec updatexinxi '002','黎明' exec indexxinxi '黎明'