How Do I pass Parameters to a SQLDataSource

Question

4.00/5 (3 votes)

See more:

Okay, I've been working on this issue for half a day and can't seem to figure it out.

I have a sqldatasource set up in my form with 2 parameters to filter the records.
I need to pass the parameters to the sqldatasource to see if the data already exist.

I don't know if something isn't clicking or if I'm just not understanding how this works.
I would whether use a data tier, but have been told this is a prototype and I just need to complete it.

Any help would be appreciated.

sqldatasource

XML

<asp:SqlDataSource ID="dsAddPermission" runat="server"
                    ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
                    InsertCommand="proc_AddPermission"                      InsertCommandType="StoredProcedure"
                    ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>"
                    SelectCommand="SELECT [ID], [AccountID] FROM [Permission] WHERE (([ID] = ?) AND ([AccountID] = ?))">
  <InsertParameters>
    <asp:Parameter Name="AccountID" Type="Int32" />
    <asp:Parameter Name="EmployeeID" Type="Int32" />
  </InsertParameters>
  <SelectParameters>
    <asp:Parameter Name="MyRadID" Type="Int32" />
    <asp:Parameter Name="AccountID" Type="Int32" />
  </SelectParameters>
</asp:SqlDataSource>

code to retrieve data

VB

Private Function CheckPermissions(ByVal aID As Integer, ByVal eID As Integer) As Boolean
  Dim bCheck As Boolean
  Dim ds = New DataSet()

  ds = dsAddPermission.Select(DataSourceSelectArguments.Empty)

  If IsDBNull(ds.Tables) Then
    bCheck = False
  ElseIf ds.Tables.Count > 0 Then
    bCheck = True
  Else
    bCheck = False
  End If

  Return bCheck
End Function

[Modified: formatted tabs in code]

Posted 10-Mar-11 12:02pm

CARisk3

Updated 11-Mar-11 10:34am

William Winner

v3

Add a Solution

Comments

Dalek Dave 10-Mar-11 18:27pm

Edited for Readability. Otherwise, a good question.

milenalukic 10-Mar-11 20:02pm

Just had a look at your profile after your comment to my question. If you're quite new to programming I would suggest you look into LINQ as it makes life much easier. I suspect any applications you build will be heavy on data so it would help to work on the database side. (Just my personal opinion here.)Sorry can't help you in web dev - I stick to windows myself.

Dalek Dave 11-Mar-11 4:08am

Oh dear me no, that needs updating, it is nearly four years old!

Simon_Whale 11-Mar-11 11:14am

As far as I am aware. LinQ to SQL is dependant on SQL Server. From the advise in another forum here on CP. It would be best to learn in the following order

1. SQL
2. ADO.NET
3. LINQ

As LinQ uses the underlying mechanics of ADO.NET and SQL can be used on any Database server.

William Winner 11-Mar-11 16:36pm

How is it that you've been around here for over a year and you're not familiar with good ole Dalek Dave?

CARisk3 11-Mar-11 16:48pm

I'm quite familiar with him. I've been on this board for about 2-3 years as what everyone would probably call a lurker. I take things in and only respond when I absolutely feel the need to. I get a lot of amusement and information from this board and enjoy the camaraderie between everyone.

When I'm really stuck and can't find an answer here or on google then I post a question.

William Winner 11-Mar-11 16:52pm

Um...ok. Thanks?

milenalukic 11-Mar-11 17:19pm

When I initially joined I was googling for info. After some time I noticed that codeproject comes up often and with good solutions so I began to frequent the site more. Only recently did I have the courage to post my first question and then while waiting for a reply I had a look at unanswered questions and found that I could help a few people out. Since then I enjoy posting questions and looking through the unanswered. Yesterday Dalek posted a comment to my question and I checked out his profile. I might become addicted to this!!

CARisk3 11-Mar-11 17:25pm

I'm already addicted. I'm on here almost every day Monday - Friday. And I usually spend about 1/2 an hour reading through the lounge post. I'm was thinking about writing up my solution for a very compact way to pass information between listboxes. I have 4 - 6 listboxes on one page and used two routines to handle on the moving of selected items back and forth. I thought it was very sleek and compact. But I'm coming from 2002/2003 into 2010 so maybe what I did was pretty standard for 2010.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CARisk3 · Accepted Answer · 2011-03-11T07:51:00

Okay. I sat do with my boss and we figured this out. I needed to add the parameters to the datasource and then bind the data. Once I did that I was able to put the information into a view and check if a value had been returned.

We didn't change anything on the sqldatasource end, just on the function.

The following is the solution we used.

VB

Private Function CheckPermissions(ByVal aID As Integer, ByVal eID As Integer) As Boolean

        Dim bCheck As Boolean
        Dim dv = New DataView()

        dsAddPermission.SelectParameters("AccountID").DefaultValue = aID.ToString
        dsAddPermission.SelectParameters("MyRadID").DefaultValue = eID.ToString
        dsAddPermission.DataBind()

        dv = dsAddPermission.Select(DataSourceSelectArguments.Empty)

        If IsDBNull(dv.Table) Then
            bCheck = False
        ElseIf dv.Table.Rows.Count > 0 Then
            bCheck = True
        Else
            bCheck = False
        End If

        Return bCheck

    End Function