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 asp.net but i can't do that. Please help me i want to create procedure for update command
Posted
Comments
Ashishmau 16-May-11 7:23am    
GOOGLE IT

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: ADO.NET[^]
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:
CREATE PROCEDURE (Transact-SQL)[^]
 
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