datareader columns

[brian shannon]

Can you define a value from a datareader through column
idexes. For example:

dim myreader as sqldatareader
SQL = select fname, lname, address from personal.

//Datareader is initialized with the above SQL code

Instead of using the following to assign values from the
reader:

while myreader.read
txtTest1.text = myreader("fname")
txtTest2.text = myreader("lname")
txtTest3.text = myreader("address")
end while
txtTest1.text = myreader.index[0]
txtTest2.text = myreaderindex[1]
txtTest3.text = myreaderindex[2]

I am looking to programatically go through the reader and
programatically assign to text boxes.

Thanks

[Teemu Keiski]

Hi,

yes you can. You can also get column index with column name if you use
GetOrdinal method (e.g idea is to get once the indexes with column names &
GetOrdinal and then later just use indexes).

--
Teemu Keiski
MCP, Microsoft MVP (ASP.NET), AspInsiders member
ASP.NET Forum Moderator, AspAlliance Columnist
"brian shannon" <bs******@lbrspec.com> wrote in message
news:21****************************@phx.gbl...

Can you define a value from a datareader through column
idexes. For example:

dim myreader as sqldatareader
SQL = select fname, lname, address from personal.

//Datareader is initialized with the above SQL code

Instead of using the following to assign values from the
reader:

while myreader.read
txtTest1.text = myreader("fname")
txtTest2.text = myreader("lname")
txtTest3.text = myreader("address")
end while
txtTest1.text = myreader.index[0]
txtTest2.text = myreaderindex[1]
txtTest3.text = myreaderindex[2]

I am looking to programatically go through the reader and
programatically assign to text boxes.

Thanks

[brian shannon]

Thanks for the reply- if you have time could you show me an example of
the get ordinal method.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Teemu Keiski]

Public Sub ReadMyData(myConnString As String)
Dim mySelectQuery As String = "SELECT OrderID, CustomerID FROM Orders"
Dim myConnection As New SqlConnection(myConnString)
Dim myCommand As New SqlCommand(mySelectQuery, myConnection)
myConnection.Open()
Dim myReader As SqlDataReader = myCommand.ExecuteReader()
Dim custIdCol As Integer = myReader.GetOrdinal("CustomerID")
Do While myReader.Read()
Console.WriteLine("CustomerID = {0}", myReader.GetString(custIdCol))
Loop
myReader.Close()
myConnection.Close()
End Sub
--
Teemu Keiski
MCP, Microsoft MVP (ASP.NET), AspInsiders member
ASP.NET Forum Moderator, AspAlliance Columnist

"brian shannon" <bs******@lbrspec.com> wrote in message
news:u$**************@TK2MSFTNGP10.phx.gbl...

Thanks for the reply- if you have time could you show me an example of
the get ordinal method.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!