Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SqlDataSource and DataReaders
Message
From
23/05/2008 21:40:31
 
 
To
23/05/2008 17:54:29
General information
Forum:
ASP.NET
Category:
Coding, syntax and commands
Miscellaneous
Thread ID:
01319299
Message ID:
01319315
Views:
11
Here's an incomplete code section, but should be enough for what you're looking for:
Dim sql As String = "select contactname from customers

' Create connection
Dim conn As SqlConnection = New SqlConnection(connString)

Try
  ' Open connection
  conn.Open()

  ' Create command
  Dim cmd As SqlCommand = New SqlCommand(sql, conn)

  ' Create data reader
  Dim rdr As SqlDataReader = cmd.ExecuteReader()

  ' Loop through result set
  While rdr.Read
    Console.WriteLine("" & rdr(0))
  End While
  ' Close data reader
  rdr.Close()
>I am trying to figure out how to review the records retrieved with a SqlDataSource in code without using a display control. My research thus far suggests this can be done via a DataReader but I am unable to figure it out. If the datasource is SqlDataSource1 and it is configured to return a DataReader, can someone show me how to get at the records with VB? Something like:
>
><<pseudo code>>
>dim oReader as Data.SQLClient.SQLDataReader = SqlDataSource1.DataReader
>
> While oReader.Read()
>    Console.WriteLine(String.Format("{0}, {1}", oReader(0), oReader(1)))
> End While
>
>
>Thanks

(On an infant's shirt): Already smarter than Bush
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform