如题,下面是调用代码:
Dim myStr As String = ("server=" & ServerIp & ";database=" & Dbname & ";uid=" & Username & ";pwd=" & Password & "")
Dim myConn As New SqlConnection(myStr)
myConn.Open()
Dim cmd As New SqlCommand("sp_UPxx", myConn)
cmd.CommandType = CommandType.StoredProcedure
cmd.CommandTimeout = 0
Dim returnvalue As SqlParameter = cmd.Parameters.Add("@returnvalue", SqlDbType.Int)
returnvalue.Direction = ParameterDirection.ReturnValue
cmd.ExecuteNonQuery()
Dim myStr As String = ("server=" & ServerIp & ";database=" & Dbname & ";uid=" & Username & ";pwd=" & Password & "")
Dim myConn As New SqlConnection(myStr)
myConn.Open()
Dim cmd As New SqlCommand("sp_UPxx", myConn)
cmd.CommandType = CommandType.StoredProcedure
cmd.CommandTimeout = 0
Dim returnvalue As SqlParameter = cmd.Parameters.Add("@returnvalue", SqlDbType.Int)
returnvalue.Direction = ParameterDirection.ReturnValue
cmd.ExecuteNonQuery()
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货