Solved

SQL Datasource Select Command

Posted on 2009-06-29
2
845 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
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

IntroductionWhile developing web applications, a single page might contain many regions and each region might contain many number of controls with the capability to perform  postback. Many times you might need to perform some action on an ASP.NET po…
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 …
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

920 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now