Simple Question

[pcabrol]

I need a sample code for displaying data(using ADO) through a data list control?

[jestes]

use the ADO control and set a connection string and a record source. then set your datalist properties (Record source, record field, data source, data field) to display the database info.

[pcabrol]

I dont want it to be bound ...I wnat it to be unbound data..straight code.

[Babbalouie]

If youi dont want it to be bound, why use the DataList? Use a regular List Box....


Dim gConn As ADODB.Connection
Dim gRs As ADODB.Recordset

Set gConn = New ADODB.Connection
gConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;Data Source=c:\books.mdb;"
gConn.Open

Set gRs = New ADODB.Recordset
gRs.ActiveConnection = gConn
gRs.CursorType = adOpenDynamic
gRs.Source = "Select title from booksavailable order by title"
gRs.Open

Do While Not gRs.EOF
List1.AddItem gRs!Title
gRs.MoveNext
Loop