i need code for insert,delete,update adn display records
using stored procedure in C#
Answer Posted / poornima
create proc produrename
@id int,
@name varchar(50),
@Add varchar(50),
@choice Varchar(30)
as
begin
if(@choice='insert')
begin
insert into tablename values(@id,@name,@Add)
end
if(@choice='update')
begin
update tablename set name=@name,Add=@Add where id=@id
end
if(@choice='delete')
begin
delete from tablename where id=@id
end
if(@choice='display')
begin
select * from tablename where id=@id
end
end
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
I have an excel file with data, i am importing this excel file data into Sqlserver 2005 database. while importing i am getting wrong data(ie, special characters) in one column(description column), upto some limit the data in that column is coming fine,after that data is coming like below. The "Walter" leather storage bench is one of our most popular styles. The top with the tufting and double stitching finish a very impressive piece. The size is perfect in front of beds and the storage adds another functional bonus. Open it up and sneak al���Ƴ�Â��ƴ�Ã��ƶ�Å�� al���Ƴ�Â��ƴ�Ã��ƶ�Å�� Is there anywhy to resolve this? (I am using recordset in coding for developing import process.) please help me soon.
What is the difference between an htmlinputcheckbox control and an htmlinputradiobutton control?
Can a master page have more than one contentplaceholder?
Explain serialization and deserialization?
How we implement web farm and web garden concept in asp.net?
Why asp.net is used?
Explain significance of routing? : asp.net mvc
What is difference between viewstate and session in asp net?
Differentiate globalization and localization.
Explain about the Class view window?
How long the items in ViewState exists?
How to implement Authentication and Authorization?
Explain how caching in asp.net 2.0 is different from caching in asp.net 1.1?
Write a code for passing ArrayList in Web API?
How to make paging concepts in datagrid in ASP.NET?