Can Anyone Give c# code for following stored procedure....
create procedure proc1 @pro_id varchar(50),@pro_name varchar(50),@description varchar(50),@priority int,@pro_img varchar(50),@search_img1 varchar(50),@search_img2 varchar(50),@search_img3 varchar(50),@search_img4 varchar(50),@search_img5 varchar(50),@keyword1 varchar(50),@keyword2 varchar(50),@keyword3 varchar(50),@keyword4 varchar(50),@keyword5 varchar(50),@y_url varchar(50),@type varchar(50),@price float,@nType int
AS
BEGIN
if @nType='Submit'
begin
insert into product(pro_id,pro_name,description,priority,pro_img,search_img1,search_img2,search_img3,search_img4,search_img5,keyword1,keyword2,keyword3,keyword4,keyword5,y_url,type,price) values(@pro_id,@pro_name,@description,@priority,@pro_img,@search_img1,@search_img2,@search_img3,@search_img4,@search_img5,@keyword1,@keyword2,@keyword3,@keyword4,@keyword5,@y_url,@type,@price)
end
else if @nType='Update'
begin
update product set pro_id=@pro_id,pro_name=@pro_name,description=@description,priority=@priority,pro_img=@pro_img,search_img1=@search_img1,search_img2=@search_img2,search_img3=@search_img3,search_img4=@search_img4,search_img5=@search_img5,keyword1=@keyword1,keyword2=@keyword2,keyword3=@keyword3,keyword4=@keyword4,keyword5=@keyword5,y_url=@y_url,type=@type,price=@price where pro_id=@pro_id
end
END