A
Agnes
I try to set an output parameter to get the result from store procedure,
However,Do I still need to loop the reader to get result ?? Thanks a lot
cmdKey.Parameters("@result").Direction = ParameterDirection.Output
Dim drCntrId As SqlDataReader =
cmdKey.ExecuteReader(CommandBehavior.SingleRow)
While drCntrId.Read
strKey = drCntrId.Item("result")
End While
However,Do I still need to loop the reader to get result ?? Thanks a lot
cmdKey.Parameters("@result").Direction = ParameterDirection.Output
Dim drCntrId As SqlDataReader =
cmdKey.ExecuteReader(CommandBehavior.SingleRow)
While drCntrId.Read
strKey = drCntrId.Item("result")
End While