Domantina stupida x datalist

[pizzom]

Scusate l'ignoranza, la domanda è nel codice.... Grazie

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

Dim sql As String
sql = "select * from password"
Dim comm As New OleDb.OleDbCommand(sql, OleDbConnection1)
OleDbConnection1.Open()
Dim objReader As OleDb.OleDbDataReader = comm.ExecuteReader()
Response.Write(objReader.FieldCount())
Do While objReader.Read()
'****** cosa devo scrivere per visualizzare una o più colonne???? ******
Loop
DataList1.DataSource = objReader
DataList1.DataBind()
objReader.Close()
OleDbConnection1.Close()

End Sub

[zampa28]

MyString = objReader.GetString(X)
MyString = objReader.GetInt16(X)
MyString = objReader.GetInt32(X)
MyString = objReader.GetInt64(X)
...........

X corrisponde all'indice della colonna

[pizzom]

Non riesco :-(

ho inserito...
MyString = objReader.GetString(0)

...ma non mi scrive niente.... puoi essere più chiaro.. grazie :master:

[zampa28]

Originariamente inviato da pizzom
Scusate l'ignoranza, la domanda è nel codice.... Grazie

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

Dim sql As String
sql = "select * from password"
Dim comm As New OleDb.OleDbCommand(sql, OleDbConnection1)
OleDbConnection1.Open()
Dim objReader As OleDb.OleDbDataReader = comm.ExecuteReader()
Response.Write(objReader.FieldCount())

Dim MyString as String
While objReader.Read()
MyString = objReader.GetString(0)
End While
DataList1.DataSource = objReader
DataList1.DataBind()
objReader.Close()
OleDbConnection1.Close()

End Sub