asp.net里是怎么调用存储过程的？

[jackrong427]

asp里面可以这样写：
set rs2=server.createobject("adodb.recordset")
set comm1=server.createobject("adodb.command")
set comm1.activeconnection=conn
comm1.commandtype=4
comm1.commandtext="选修课录入"
comm1.parameters(1)=trim(request.form("xxfw"))
comm1.parameters(2)=trim(request.form("nrjj"))
comm1.parameters(3)=trim(request.form("xxkc"))
comm1.parameters(4)=trim(request.form("kcmb"))
comm1.parameters(5)=trim(request.form("kcmc"))
comm1.parameters(6)=trim(request.form("xs"))
comm1.parameters(7)=trim(request.form("xf"))
comm1.parameters(8)=trim(request.form("ksxs"))
comm1.parameters(9)=session("trust3")
comm1.parameters(10)=trim(request.form("D3"))
comm1.parameters(11)=trim(request.form("D1"))
comm1.parameters(12)=trim(request.form("D2"))

set rs2=server.createobject("adodb.recordset")
set rs2=comm1.execute()


那.net里呢？

[chenhenet]

CREATE PROCEDURE p_out
@a as int,
@b as int,
@c as int output
AS
set @c=@a+@b
－－－－－－－－－－－－－－－－－－－－－
.........
SqlCommand cmd2=new SqlCommand("p_out",conn);
cmd2.CommandType=CommandType.StoredProcedure;
cmd2.Parameters.Add("@a",SqlDbType.Int);
cmd2.Parameters.Add("@b",SqlDbType.Int);
SqlParameter para_c=cmd2.Parameters.Add("@c",SqlDbType.Int);
cmd2.Parameters[0].Value=2;
cmd2.Parameters[1].Value=3;
para_c.Direction=ParameterDirection.Output;
conn.open();
cmd2.ExecuteNonQuery();
conn.close();
this.Response.Write(para_c.value.ToString());

[chenhenet]

不仅是调用存储过程，还返回output值

[vzxq]

MSDN 里边搜索一下，有例子

[zl_xue]

eg.
com = New Oracle.DataAccess.Client.OracleCommand("PACK_" & PRO_ID.Text & ".getcursor", con)
com.CommandType = CommandType.StoredProcedure
com.Parameters.Add("CUR_SEL", OracleDbType.RefCursor, DBNull.Value, ParameterDirection.Output)

[xueqs]

SqlConnection myCn = new SqlConnection(strConn);
SqlCommand myCmd = new SqlCommand(‘存储过程名称’,myCn);

myCmd.CommandText = ‘存储过程名称’;
myCommand.CommandTimeout = 15;
myCmd.CommandType = CommandType.StoredProcedure;

try
{
myCn.Open();
myCmd.ExecuteNonQuery();
}
catch(Exception e)
{
throw new Exception(e.Message);
}
finally
{
myCmd.Dispose();
myCn.Close();
}

[dotnet90]

Imports System
Imports System.Data
Imports System.Data.SqlClient

Public Class Admin_login
Inherits System.Web.UI.Page

#Region " Web 窗体设计器生成的代码 "

'该调用是 Web 窗体设计器所必需的。
<System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()

End Sub
Protected WithEvents Label1 As System.Web.UI.WebControls.Label
Protected WithEvents Label2 As System.Web.UI.WebControls.Label
Protected WithEvents TextBox1 As System.Web.UI.WebControls.TextBox
Protected WithEvents Button1 As System.Web.UI.WebControls.Button
Protected WithEvents Button2 As System.Web.UI.WebControls.Button
Protected WithEvents Label3 As System.Web.UI.WebControls.Label

'注意: 以下占位符声明是 Web 窗体设计器所必需的。
'不要删除或移动它。
Private designerPlaceholderDeclaration As System.Object

Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init
'CODEGEN: 此方法调用是 Web 窗体设计器所必需的
'不要使用代码编辑器修改它。
InitializeComponent()
End Sub

#End Region

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'在此处放置初始化页的用户代码

End Sub

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click



Select Case cmdReturn(TextBox1.Text)
Case -1
Label3.Text = "sorry,你所添加的专题已经存在!"
Case 0
Label3.Text = "恭喜你，添加成功!"

End Select

End Sub
Function cmdReturn(ByVal strZhuanti) As Integer

Dim con As String = ConfigurationSettings.AppSettings("dsn")
Dim conn As SqlConnection = New SqlConnection(con) '//连接字符串
conn.Open()

Dim cmd As SqlCommand = New SqlCommand("add_zhuanti", conn)
cmd.CommandType = CommandType.StoredProcedure
Dim parmReturn As SqlParameter
parmReturn = cmd.Parameters.Add("@return", SqlDbType.Int)
parmReturn.Direction = ParameterDirection.ReturnValue
cmd.Parameters.Add("@zhuanti", strZhuanti)
cmd.ExecuteNonQuery()
conn.Close()
Return cmd.Parameters("@return").Value

End Function
End Class