OleDbDataReader

[Nexus]

I'm currently using .NET version 2003. I want to be able to retrieve records.
How do I do so using the OleDbDataReader ? Can I have some codes as an example?

[Partha Protim Roy]

Hello Nexus,

Dim Com As New OleDbCommand(SQ L ,Con)

Rdr = Com.ExecuteRead er()

Where Con is Connection Object & Rdr is Reader Object

Loop through the Rdr to retrive records.

Partha

"Nexus" <Ne***@discussi ons.microsoft.c om> wrote in message news:B2******** *************** ***********@mic rosoft.com...

I'm currently using .NET version 2003. I want to be able to retrieve records.
How do I do so using the OleDbDataReader ? Can I have some codes as an example?

[Cor Ligthert]

Nexus,

You can use the OleDbDataReader , that is for reading unsorted or sorted
rows, row by row from a database.

Beter is normally to take the approach from the dataset/datatables, which
gives you in one set all the information you need to do an action.

Maybe it is better you give us an idea what you want to do, because what you
ask now can you better read in books. In this dotNet newsgroup the books
from David Sceppa and William (Bill) Vaughn are always promoted. They both
are active in the newsgroup "Microsoft.publ ic.dotnet.frame work.adonet" when
you want to meet them.

Bill the last times more than David, however David is as well still active
in that.

I hope this helps so far?

Cor

"Nexus"

I'm currently using .NET version 2003. I want to be able to retrieve
records.
How do I do so using the OleDbDataReader ? Can I have some codes as an
example?

[Ken Tucker [MVP]]

Hi,
Dim conn As SqlConnection

Dim strConn As String

Dim drCustomer As SqlDataReader

Dim cmd As SqlCommand

Dim cmdOrders As SqlCommand

Dim ds As New DataSet

strConn = "Server = " + Environment.Mac hineName + ";"

strConn += "Database = NorthWind;"

strConn += "Integrated Security = SSPI;"

conn = New SqlConnection(s trConn)

cmd = New SqlCommand("Sel ect * from Customers", conn)

conn.Open()

drCustomer = cmd.ExecuteRead er

Do While drCustomer.Read

Trace.WriteLine (drCustomer.Ite m("CustomerID") .ToString)

Loop

conn.Close()

Ken

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

"Nexus" <Ne***@discussi ons.microsoft.c om> wrote in message
news:B2******** *************** ***********@mic rosoft.com...
I'm currently using .NET version 2003. I want to be able to retrieve
records.
How do I do so using the OleDbDataReader ? Can I have some codes as an
example?