Solved

SQL Datasource Select Command

Posted on 2009-06-29
2
849 Views
Last Modified: 2013-12-17
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
            selectParameters.Add(spCustomer)
        Else
            spCustomer.Value = "%"
            selectParameters.Add(spCustomer)
        End If
 
        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
            selectParameters.Add(spStock)
        Else
            spStock.Value = "%"
            selectParameters.Add(spStock)
        End If
 
     
        For Each p As SqlParameter In selectParameters
            e.Command.Parameters.Add(p)
        Next
 
    End Sub
    Protected Sub SqlDataSource1_Selected(ByVal sender As Object, ByVal e As SqlDataSourceStatusEventArgs)
        selectParameters.Clear()
    End Sub

Open in new window

0
Comment
Question by:directxBOB
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 22

Expert Comment

by:prairiedog
ID: 24737373
>>>The problem I am having is that the parameters don't seem to be taking effect.
No data returned?

0
 
LVL 27

Accepted Solution

by:
VBRocks earned 500 total points
ID: 24737669
Is there an "AddWithValue" method?

    selectParameters.AddWithValue("@Customer", ddlStock.SelectedValue)
0

Featured Post

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Today I had a very interesting conundrum that had to get solved quickly. Needless to say, it wasn't resolved quickly because when we needed it we were very rushed, but as soon as the conference call was over and I took a step back I saw the correct …
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question