SqlDataSource control ... binding to a datareader 2

[VBRookie]

Hi ...

I'm using the sqldatasource control to retrieve data. I'd like to bind or dump that data into a datareader so that I can iterate through it and populate some labels on my form. I don't see anyway to do this programmatically ... is this possible?

I have the datasourcemode set to datareader but how do I access the datareader?

Here is my code:

SqlDataSource1.SelectCommand = "usp_ccTransLog"
   SqlDataSource1.SelectCommandType = SqlDataSourceCommandType.StoredProcedure
   SqlDataSource1.SelectParameters.Add("ActionCode", "SEL")
   SqlDataSource1.SelectParameters.Add("SelectCode", "5")
   SqlDataSource1.SelectParameters.Add("TransactionID", Request.QueryString.Item("TransID"))
   SqlDataSource1.DataSourceMode = SqlDataSourceMode.DataReader
   SqlDataSource1.ConnectionString = DB.GetConn("TestConnect")

Many Thanks,
- VB Rookie

 

[jbenson001]

All examples I have found use a dataadapter or command object. I see no way of doing it with a sqldatasource.

Jim

 

[VBRookie]

Thanks again Jim! ... thats what I needed to know. I will have to go another route with this in light of that fact.

Many Thanks,
- VB Rookie

 

[jbenson001]

Ok.. glad to help

 

[ca8msm]

Erm...that's not really true. You can use the following method which will return a IDataReader object (if the DataSourceMode property is set to a "DataReader" value)

SqlDataSource1.Select()

____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[jbenson001]

ca8msm... thanks for pointing that out. I didn't realize that is the way to do it. In looking for examples in VSHelp, I didn't come acrros that property or any examples... Good to learn something new every day...

 

[ca8msm]

No probs Jim. Here's the online version of the help page that I found it from:

http://msdn2.microsoft.com/en-us/library/system.web.ui.webcontrols.sqldatasource.select.aspx

____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[jbenson001]

ca8msm.. great article thanks... I bookmarked it...

 

[VBRookie]

So what would be the syntax for that? I've tried to do it but select requires some sort of arguments parameter. I thought that I could just do this:

dim dtRdr = new sqldatareader
dtRdr = sqlDdatasource.select ()

This is the code that I have according to the documentation in the link you posted:

Dim arguments As DataSourceSelectArguments
  Dim dtRdr As SqlDataReader

SqlDataSource2.SelectParameters.Clear()
  SqlDataSource2.SelectCommand = "usp_ccPriorAuth"
  SqlDataSource2.SelectCommandType = SqlDataSourceCommandType.StoredProcedure
  SqlDataSource2.SelectParameters.Add("ActionCode", "SEL")
  SqlDataSource2.SelectParameters.Add("SelectCode", "1")
  SqlDataSource2.SelectParameters.Add("BatchNbr", drpBatch.SelectedItem.Value)
  SqlDataSource2.ConnectionString = DB.GetConn("MPXExt")
dtRdr = SqlDataSource2.Select(arguments)

  If dtRdr.HasRows Then
   dtRdr.Read()
  End If

It's presently not working ... the .select() method returns an ienumerable object. How do I utilize this as a datareader? Please advise.

Many Thanks,
- VB Rookie