System.Data.SqlClient.SqlException: Procedure or function testprocedure expects parameter @location, which was not supplied in ASP.Net

Hi manoj07,

The code you are provided is working. I have modified your code for passing null value. Please check with the modified code.

Private Sub BindGrid()
    Dim location As String = "SIPAT"
    Dim strConnString As String = ConfigurationManager.ConnectionStrings("cmdpns").ConnectionString
    'Using con As New SqlConnection(strConnString)
    'Using cmd As New SqlCommand("SELECT * FROM Customers")
    Dim con As New SqlConnection(strConnString)
    Dim cmd As New SqlCommand()
    cmd.CommandType = CommandType.StoredProcedure
    cmd.CommandText = "testprocedure"
    If Not IsNothing(location) Then
        cmd.Parameters.AddWithValue("@location", location)
    Else
        cmd.Parameters.AddWithValue("@location", DBNull.Value)
    End If
    cmd.Connection = con
    Using sda As New SqlDataAdapter()
        cmd.Connection = con
        sda.SelectCommand = cmd
        Using dt As New DataTable()
            sda.Fill(dt)
            GridView1.DataSource = dt
            GridView1.DataBind()
        End Using
    End Using
    ' End Using
    'End Using
End Sub

Dear @manoj07,

Please refer the below references, it might be help you

https://www.codeproject.com/Questions/295011/Procedure-or-Function-InsertInfo-expects-parameter

https://stackoverflow.com/questions/19703653/stored-procedure-or-function-expects-parameter-which-is-not-supplied

https://stackoverflow.com/questions/26674149/c-sharp-stored-procedure-or-function-expects-parameter-which-is-not-supplied

still getting same message.

Hi @manoj07,

in your stored procedure  are you passing location parameter or not ??

share your stored procedure..

Share your stored procedure.