I have a select command which has 2 parameters
select * from Products where id like @Customer and inStock = @inStock
So what I am doing is putting parameters using the Selecting Event. The problem I am having is that the parameters don't seem to be taking effect.
Any ideas as to what might be wrong? This works fine when doing an insert, and was hoping to use this for the a select so I could automatically filter the Gridview, without ruiing my Update, Insert, Cancel that I have going on with the gridview.
Private selectParameters As New List(Of SqlParameter)()
Protected Sub SqlDataSource1_Selecting(ByVal sender As Object, ByVal e As SqlDataSourceSelectingEventArgs)
Dim spCustomer As New SqlParameter("@Customer", SqlDbType.VarChar, 255)
spCustomer.Direction = ParameterDirection.Input
If Not ddlCustomers.SelectedValue.Equals("-1") Then
'gridviewSelect = gridviewSelect + " and ProductWholesaler ='" + ddlCustomers.SelectedValue + "'"
spCustomer.Value = ddlCustomers.SelectedValue
spCustomer.Value = "%"
Dim spStock As New SqlParameter("@Stock", SqlDbType.VarChar, 255)
spStock.Direction = ParameterDirection.Input
If Not ddlStock.SelectedValue.Equals("-1") Then
'gridviewSelect = gridviewSelect + " and ProductStock ='" + ddlStock.SelectedValue + "'"
spStock.Value = ddlStock.SelectedValue
spStock.Value = "%"
For Each p As SqlParameter In selectParameters
Protected Sub SqlDataSource1_Selected(ByVal sender As Object, ByVal e As SqlDataSourceStatusEventArgs)