新建四个存储过程
create proc cp_insert (
@name varchar(50),
@remark varchar(200)
)
as
insert into Roles values(@name,@remark)
create proc cp_update (
@id int,
@name varchar(50),
@remark varchar(200)
)
as
update Roles set name=@name,remark=@remark where id=@id
create proc cp_delete (
@id int
)
as
delete Roles where id=@id
create proc cp_select (
@name varchar(50)
)
as
select * from roles where name like '%'+@name+'%'
4种新增方法
方式一
//方式一
Role rl = new Role()
{