ASP.NET SQL Select paramaters

[etjohnson81]

Hello all,

I am new to ASP.NET and I am finding out that the .execute isn't the same as asp.

How do I go about setting up a select query to run here?

        'Setup query
        Dim searchData As New SqlDataSource
        searchData.ConnectionString = ConfigurationManager.ConnectionStrings("ConnectionString").ToString()

        searchData.SelectCommandType = SqlDataSourceCommandType.Text
        'searchData.SelectCommand = "SELECT tblSystems.txtSerial, tblCustomers.txtUsername, tblCustomers.txtFirstName, tblCustomers.txtLastName FROM tblCustomers INNER JOIN tblSystems ON tblCustomers.CustomerID = tblSystems.numCustomerID WHERE (tblSystems.txtSerial LIKE '%test%') OR (tblCustomers.txtFirstName LIKE '%test%') OR (tblCustomers.txtLastName LIKE '%test%') OR (tblCustomers.txtUsername LIKE '%test%')"
        Dim sqlStr As String
        sqlStr = searchData.SelectCommand = "SELECT tblSystems.txtSerial, tblCustomers.txtUsername, tblCustomers.txtFirstName, tblCustomers.txtLastName FROM tblCustomers INNER JOIN tblSystems ON tblCustomers.CustomerID = tblSystems.numCustomerID "

        'Check for unique row.
        Dim rowsAffected As Integer

        searchData.Select()

and i get that i am missing arguments in the select statement.

Any help is appreciated, or a good place for this.

My inserts are working fine, so I guess thats a step in the right direction, i can put it in, just cant get it out.

 

[ca8msm]

Have a look at these two examples which show you how to loop through data using a DataTable or DataReader.


------------------------------------------------------------

Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]
[URL unfurl="true"]http://mdssolutions.co.uk[/url] - Delivering professional ASP.NET solutions

 

[ca8msm]

Sorry, submitted my reply to early...

You should also look at this MSDN article which will show you how to adapt the query and add parameters to it.


------------------------------------------------------------

Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]
[URL unfurl="true"]http://mdssolutions.co.uk[/url] - Delivering professional ASP.NET solutions

 

[etjohnson81]

Thanks, I will take a look into that.