我在asp.net 中调用存储过程，是带输入和输出参数的，但是没有返回输出参数好像。
个位给看看有什么错误
存储过程如下：
CREATE PROCEDURE proc_user_leave @cdno varchar(20),@sd datetime,@ed datetime,@rnumvarchar(1)output
AS
if exists(select top 1 *from vacation where cardno=@cdno and sdate=@sd and status in (0,1,3,-1,6,-6))
set @rnum='N'
else
set @rnum='Y'
asp.net调用如下：
Dim ds As DataSet
Dim myconnection As SqlConnection
Dim mydataadapter As SqlDataAdapter
Dim flg As String
myconnection = New SqlConnection("user id=;pwd=;server=;persist security info=False;database=DB")
mydataadapter = New SqlDataAdapter("proc_user_leave", myconnection)
mydataadapter.SelectCommand.CommandType = CommandType.StoredProcedure
mydataadapter.SelectCommand.Parameters.Add("@cdno", SqlDbType.VarChar).Value = Trim(TextBox5.Text)
mydataadapter.SelectCommand.Parameters("cdno").Direction = ParameterDirection.Input
mydataadapter.SelectCommand.Parameters.Add("@dates", SqlDbType.DateTime).Value = FormatDateTime(Trim(Textbox8.Text), 0)
mydataadapter.SelectCommand.Parameters("dates").Direction = ParameterDirection.Input
mydataadapter.SelectCommand.Parameters.Add("@datee", SqlDbType.DateTime).Value = FormatDateTime(Trim(Textbox9.Text), 0)
mydataadapter.SelectCommand.Parameters("datee").Direction = ParameterDirection.Input
flg = mydataadapter.SelectCommand.Parameters.Add("@ret", SqlDbType.VarChar).Value
mydataadapter.SelectCommand.Parameters("@ret").Direction = ParameterDirection.Output
If flg = "N" Then
Label_dupl_record.Text = "You can not submit duplicate application"
send notice don't submit data
ElseIf flg = "Y" Then
submit data
End If
要依据存储过程返回值来判断是否允许提交数据。即存储过程返回Y，允许提交数据，返回N则不允许提交数据
[ 本帖最后由 zxlshashala 于 2008-10-28 14:19 编辑 ] |
