i need code for insert,delete,update adn display records
using stored procedure in C#
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 ? | 5 Yes | 0 No |
I am using ASP.Net 2.0. I added the following code in button_Click page. but 'PreviousPage' is not taking as a keyword. It throughs an error. Page Poster = this.PreviousPage; TextBox txtNewTest = (TextBox)Poster.FindControl("txtTest"); sDisplay = txtNewTest.Text; Response.Write(sDisplay); The following is the Error Message: 'controls_LoginMain' does not contain a definition for 'PreviousPage'
Explain About WebService
What is aspect-oriented programming?
What is Web Gardening? How would using it affect a design ?
What are the different types of validation controls provided in ASP.NET?
0 Answers Sans Pareil IT Services,
what is diffrence between debug class and trace class in asp.net ?
Explain about ASP.NET?
What is csrf attack in asp.net?
Write a code for "RequiredFieldValidator" in java script
What is fulltrust?
Does C# support static class?Is Static class be inherited by any class?
what is mean by framework?
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)