?
Solved

ASP .NET 2.0 SQL Select Command Problem

Posted on 2006-06-28
2
Medium Priority
?
692 Views
Last Modified: 2012-06-21
I have the following code:

Protected Sub btnSubmit_Click(ByVal sender As Object, ByVal e As System.EventArgs)
        Dim DSflgasgiveaway As SqlDataSource
        Dim SelectArgs As SqlDataSourceCommandEventArgs
        DSflgasgiveaway.ConnectionString = ConfigurationManager.ConnectionStrings("flgasgiveawayConnectionString1").ToString
        DSflgasgiveaway.SelectCommandType = SqlDataSourceCommandType.Text
        DSflgasgiveaway.SelectCommand = "Select * from flgasgiveaway WHERE ItemCode = @itemcode"
        DSflgasgiveaway.SelectParameters.Add("itemcode", txtCode.Text)
       
        Dim rowsaffected As Integer = 0
       
        Try
            rowsaffected = DSflgasgiveaway.Select()
           
        Catch ex As Exception

        End Try
    End Sub

I have the following errro message when i hover my mouse over the select statement:

'Argument not specified for parameter 'arguments' of Public Function Select(arguments As System.Web.UI.DataSourceSelectArguments) As System.Collections.IEnumberable'

What am I missing?????  

Thanks in advance!
0
Comment
Question by:spmcmorrow
[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 9

Accepted Solution

by:
bele04 earned 2000 total points
ID: 17006353
the Select method of the SqlDataSource requires that a DataSourceSelectArguments need to be passed to it as a parameter.

you need to create an instance of an object of type DataSouceSelectArguments and pass it to the Select Method like this:

Dim ds As New DataSourceSelectArguments

DSflgasgiveaway.Select(ds)

note that the Select method returns a DataView if the DataSourceMode property of your SqlDatasource is set to Dataset, if it is set to DataReader then it returns a IDataReader.  The Select Method of your SqlDataSource doesn't return an Integer so this line of your code:

rowsaffected = DSflgasgiveaway.Select()

is wrong.

hope that clears somethings out.
-bele04-
0
 

Author Comment

by:spmcmorrow
ID: 17006539
Thanks a bunch!
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Sometimes in DotNetNuke module development you want to swap controls within the same module definition.  In doing this DNN (somewhat annoyingly) swaps the Skin and Container definitions to the default admin selections.  To get around this you need t…
Problem Hi all,    While many today have fast Internet connection, there are many still who do not, or are connecting through devices with a slower connect, so light web pages and fast load times are still popular.    If your ASP.NET page …
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses
Course of the Month10 days, 19 hours left to enroll

770 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