创建存储过程 [英] create stored procedure

问题描述

我想在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.

这篇关于创建存储过程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！