Click here to Skip to main content
15,917,177 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
i want to create stored procedure in but i can't do that. Please help me i want to create procedure for update command
Ashishmau 16-May-11 7:23am    

Since you said Stored Procedure in ASP.NET, you need to read and know about ADO.NET.
Read about ADO.NET here and it will help you.

Look at these:
MSDN: Accessing Data with ADO.NET[^]

SP specific:
MSDN: HOW TO: Call SQL Server Stored Procedures in ASP.NET by Using Visual C# .NET[^]
MSDN: HOW TO: Call a Parameterized Stored Procedure by Using ADO.NET and Visual C# .NET[^]
ADO.NET : Using Stored Procedures[^]

Writing Stored Procedures:
Share this answer
You can not create a store procedure in ASP.NET itself. For that you need database i.e. SQL.
Of course there is a way to add store procedure via visual studio without opening a SQL interface.

In SQL you can create a store procedure(SP) and call that SP from the ASP.NET.

Example 1 [^]

Example 2 [^]

Hope it helps.
Share this answer

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

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900