To insert update and delete records

Question

0.00/5 (No votes)

See more:

Hello

I have a question, i want to design a page in which all the data has to be inserted updated and deleted. The data has to be stored in sql server. i have created a table for that, can anyone help me for how to create a stored procedure for this and c# code to inset update and delete data.

Posted 11-Jun-12 18:12pm

Nikil0012

Add a Solution

Comments

virang_21 12-Jun-12 0:14am

There is a Google for that ... Try before you ask for help otherwise you never learn..

4 solutions

Solution 2

The answer by Mr. Prasad Kulkarni is perfect. you can refer that to see how to create stored procedures. If you want to understand how to use C#/ADO.NET to use these stored procedures then perhaps this could be useful.

A Beginner's Tutorial for Understanding ADO.NET[^]

Note: It is always a good idea to learn ADO.NET even if you are using auto generated code and/or ORMs.

Posted 11-Jun-12 18:32pm

Rahul Rajat Singh

Comments

Prasad_Kulkarni 12-Jun-12 0:34am

Good suggestion +5!

AshishChaudha 12-Jun-12 0:50am

my 5

Solution 3

Hello
For that you have write only one store procedure
here find this articels..

http://www.c-sharpcorner.com/UploadFile/rohatash/select-insert-update-delete-using-stored-procedure-in-sql/[^]

If any query fill free to contact
Thank You

Posted 11-Jun-12 20:14pm

Yatin chauhan

Solution 4

Hi,

See the following videos:

http://www.youtube.com/watch?v=xtlR_W37YA0[^]

http://www.youtube.com/watch?v=VSU51pv-IWI[^]

http://www.youtube.com/watch?v=WIS46cqMoKc[^]

You can also take the reference of following links:

Calling Stored procedures in ADO.NET[^]

http://www.csharp-station.com/Tutorial/AdoDotNet/lesson07[^]

Posted 11-Jun-12 20:18pm

Vipin_Arora

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Prasad_Kulkarni · Accepted Answer · 2012-06-11T18:24:00

Solution 1

Stored procedures (sprocs) are generally an ordered series of Transact-SQL statements bundled into a single logical unit.

They allow for variables and parameters, as well as selection and looping constructs.

A key point is that sprocs are stored in the database rather than in a separate file.

To call stored procedures in C#, please refer:
Update/Insert/Delete with stored procedures and SqlDataSource control[^]
Insert Single Value With Stored Procedure ASP.NET C#[^]
Stored Procedures with ASP.NET[^]
Insert,Update and Delete Using Grid View and ObjectDataSource[^]

And the best one:
Google[^]

Posted 11-Jun-12 18:24pm

Prasad_Kulkarni

Comments

Rahul Rajat Singh 12-Jun-12 0:31am

good answer. +5.

Prasad_Kulkarni 12-Jun-12 0:34am

Thank you Rahul!

Manas Bhardwaj 12-Jun-12 2:07am

correct +5!

Prasad_Kulkarni 12-Jun-12 3:48am

Thank you Manas!

Sk. Tajbir 12-Jun-12 2:17am

Nice,5+

Prasad_Kulkarni 12-Jun-12 3:48am

Thank you Tajbir!