CREATE PROCEDURE AllOrderComplete
@contractid varchar(10),@orderid varchar(10),@returnvalue int output
AS
if '已完成'=all(select currentstate from [Order] where contract_id=@contractid and order_id=@orderid)
begin
set @returnvalue=1
end
else
begin
set @returnvalue=0
end
GOvb.net中我这样做
Dim sqlcn As New SqlConnection(myclks.glbcnstring)
Dim sqlcmd As New SqlCommand
sqlcmd.CommandText = "exec AllOrderComplete"
sqlcmd.CommandType = CommandType.StoredProcedure
sqlcmd.Connection = sqlcn
Dim pa As New SqlParameter("@a", SqlDbType.Int, 10)
pa.Direction = ParameterDirection.Output
sqlcmd.Parameters.Add(pa)
sqlcn.Open()
sqlcmd.ExecuteNonQuery()
'MessageBox.Show(pa.Value)
结果没有通过,我也弄了一天了,就没想出哪出错了,在.net区问一下吧
@contractid varchar(10),@orderid varchar(10),@returnvalue int output
AS
if '已完成'=all(select currentstate from [Order] where contract_id=@contractid and order_id=@orderid)
begin
set @returnvalue=1
end
else
begin
set @returnvalue=0
end
GOvb.net中我这样做
Dim sqlcn As New SqlConnection(myclks.glbcnstring)
Dim sqlcmd As New SqlCommand
sqlcmd.CommandText = "exec AllOrderComplete"
sqlcmd.CommandType = CommandType.StoredProcedure
sqlcmd.Connection = sqlcn
Dim pa As New SqlParameter("@a", SqlDbType.Int, 10)
pa.Direction = ParameterDirection.Output
sqlcmd.Parameters.Add(pa)
sqlcn.Open()
sqlcmd.ExecuteNonQuery()
'MessageBox.Show(pa.Value)
结果没有通过,我也弄了一天了,就没想出哪出错了,在.net区问一下吧
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货