how can how can dealer stored procedure and syntax with example in Asp.net programming

Question

1.00/5 (4 votes)

See more:

Dear Sir/Mam

I am shailendra singh .I am new in IT development so Please help me.I Want know about Stored procedure .what is syntax of stored Procedure and how can dealer stored procedure with example How can access parameter in Asp.net program.Please any one help me.whole procedure describe by asp.net application.

Thank's in Advance

Posted 15-Mar-12 9:08am

shailendra from MP

Add a Solution

Comments

Herman<T>.Instance 15-Mar-12 15:14pm

what have you tried?

Sergey Alexandrovich Kryukov 15-Mar-12 19:37pm

Not a question. You need to learn some basic and ask about some particular problem. Don't you need an answer explaining how to RTFM? :-)
And how is this related to ASP.NET?
--SA

1 solution

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)

Dave Kreskowiak · Answer 1 · 2012-03-15T09:28:00

Uhhh...First, this has nothing to do with ASP.NET.

This haas EVERYTHING to do with undering how SQL Servers work and the basics of SQL query language.

Nobody is going to be able to "tell you the procedure" in a couple of forum posts.

If you want to learn how stored procedures work, you'll first have to understand the basics of SQL Servers and the query language. I highly recommend picking up a book on SQL Server, or whatever flavor of database engine you prefer (NOT MS ACCESS!!), and read through it. Stored Procedures will be covered quite extensively.

Once you understand that, you can then move onto your next book on ADO.NET, in which you'll call stored procedures, supplying parameters and getting datasets and scalar values returned to you, as well as properly setting up these calls and which objects to use in which data requirement cases.

Again, this is not something you're going to get in a couple of forum posts.