Tech
Forums
Jobs
Books
Events
Videos
Live
More
Interviews
Certification
Training
Career
Members
News
Blogs
Contribute
An Article
A Blog
A Video
An Ebook
An Interview Question
Register
Login
3
Answers
Insert ,delerte,update data using stored procedure
Kavita B
13y
2.7k
1
Reply
Hi,
I have read this article from this site:
Using Stored Procedure in ASP.NET
but it gives errors and its not correct...What is the correct way to use stored procedure in asp.net? To insert/update/delete using stored procedure do we need to write 3 different procedures? I have a bit of confusion.. Like i have written procedure to insert data into a table using stored procedure like this
CREATE PROCEDURE INSERTRECORD
(@ID bigint,Name Varchar(25))AS
INSERT INTO TEST(ID,Name)VALUES(@ID,@Name)
Same way to update and delete also do i need to write procedures?
I have checked forum but nowhere found right way to use in in asp.net?
Post
Reset
Cancel
Answers (
3
)
Next Recommended Forum
Create Dynamic Report by using Crystal report app
Custom URL for My Website