Still not working. I took the case statement out if that's what you were referring to as the if statement.
Protected Sub PopulateGrid(ByVal sender As Object, ByVal e As EventArgs)
'Select Case Pending.SelectedItem.Value ' Case "300"
Dim conn As New Data.SqlClient.SqlConnection(ConfigurationManager.ConnectionStrings("PendingClaimsConnectionString").ConnectionString)
Dim cmd As New Data.SqlClient.SqlCommand
Dim cmdPending As New Data.SqlClient.SqlCommand With cmdPending
.CommandType = Data.CommandType.StoredProcedure
.CommandText = "GetDDS250" .Connection = conn
'.Parameters.AddWithValue("@doc", Request.QueryString("doc"))
.Parameters.AddWithValue("@doc", Pending.SelectedValue)
End With
Dim adapter As New Data.SqlClient.SqlDataAdapter(cmdPending) Try
conn.Open() Dim ds As New Data.DataSet
adapter.Fill(ds) GridView1.DataSource = ds
GridView1.DataBind() Finally conn.Dispose()
End Try
