Solved

SQL Datasource Select Command

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

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

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

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…
A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

810 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