I am not getting any value returned from the call to the stored procedure.
Code:
mySqlCommand.Parameters.Add(New Data.SqlClient.SqlParameter("@Member", Data.SqlDbType.Char, 10)).Value = ViewState("FileMember")
mySqlCommand.Parameters("@Member").Direction = Data.ParameterDirection.Input
mySqlCommand.Parameters.Add(New Data.SqlClient.SqlParameter("@RetValue", Data.SqlDbType.Char, 200)).Direction = Data.ParameterDirection.Output
mySqlCommand.Parameters.Add(New Data.SqlClient.SqlParameter("@RowCount", Data.SqlDbType.Char, 2)).Direction = Data.ParameterDirection.Output
mySqlCommand.CommandType = Data.CommandType.StoredProcedure
mySqlCommand.CommandText = ("sp_ZyTax_Summary")
mySqlCommand.Connection = mySqlConnection
mySqlDataAdapter.SelectCommand = mySqlCommand
Dim myReturnValue As String = mySqlCommand.Parameters("@RetValue").Value.ToString
Dim myRowCount As String = mySqlCommand.Parameters("@RowCount").Value.ToString
Code:
ALTER PROCEDURE [dbo].[sp_ZyTax_Summary]
@Member varchar(10),
@RetValue char(200) output,
@RowCount char(2) output
as..........
Not getting the return values
