i want to pass the value from the front end asp.net using

Question

create database g

use g

create table student(stid int primary key,stname varchar(50),staddress varchar(50))

alter procedure h

(@sid int)

as

begin

if @sid=null

begin

select * from student

end

else

begin

select * from student where stid=@sid

end

end

create procedure oi

(@mode int, @sid int,@sname varchar(80),@sad varchar(30) out)

as

begin transaction

if @mode=1

begin

insert into student values(@sid,@sname,@sad)

end

else

begin

if @mode=2

begin

update student set stname=@sname where stid=@sid

end

end