创建存储过程
问题描述：
我想在asp.net中创建存储过程，但是我不能这样做.请帮助我，我想为更新命令创建过程.
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
答
由于您在ASP.NET中说过存储过程，因此您需要阅读并了解ADO.NET. br/> 在此处阅读有关ADO.NET的信息，它将对您有所帮助.
看看这些:
MSDN:ADO.NET [ MSDN:使用ADO.NET访问数据 [ ^ ]
SP特定:
MSDN:HOW TO:使用Visual C#.NET在ASP.NET中调用SQL Server存储过程 [ MSDN:HOW TO:使用ADO.NET和Visual C#.NET调用参数化存储过程 [ ADO.NET:使用存储过程 [创建过程(Transact-SQL) [
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)[^]
您无法在以下位置创建存储过程ASP.NET本身.为此，您需要数据库即SQL.
当然，有一种方法可以通过Visual Studio添加存储过程而无需打开SQL界面.
在SQL中，您可以创建一个存储过程(SP)并从ASP.NET调用该SP.
示例1 [示例2 [
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.