How to get return value of sqlstored procedure in vb.net

[visweswaran2830]

Hi,

This is my code. Here I want to retrieve return value of stored procedure. when I am executing this, I am receiving exception as string[1] string invalid index[0].


coding..




cmd.CommandText = "sp_dat_enc"
Dim params() As OleDbParameter = {New OleDbParameter("@pVisitDates", r("visit_dates").ToString)}
Dim ret_val As New OleDbParameter("@DataOut", OleDbType.VarChar)
ret_val.Direction = ParameterDirection.ReturnValue
cmd.Parameters.Clear()
cmd.Parameters.AddRange(params)
cmd.Parameters.Add(ret_val)
Dim ddr As OleDbDataReader = cmd.ExecuteReader

[sanndeb]

Dim connectionString As String = "Server=L40\YUKON; Initial Catalog=AdventureWorks; Integrated Security=True;"
Using conn As New SqlConnection(connectionString)
    Using cmd As New SqlCommand("dbo.GetCountByLastName")
        cmd.CommandType = CommandType.StoredProcedure
        cmd.Parameters.Add(New SqlParameter("@LastName", "Alexander"))
 
        Dim countParameter As New SqlParameter("@LastNameCount", 0)
        countParameter.Direction = ParameterDirection.Output
        cmd.Parameters.Add(countParameter)
 
        conn.Open()
        cmd.Connection = conn
 
        cmd.ExecuteNonQuery()
        Dim count As Integer = Int32.Parse(cmd.Parameters("@LastNameCount").Value.ToString())
        Response.Write("<p>Count: " & count.ToString())
        conn.Close()
    End Using
End Using

Found On Net, May Be Helpful To You...