Tuesday, March 03, 2009

BIND Using DataReader.

Good for single values.

cn As New pg.PgSqlConnection(String)
cmd As New pg.PgSqlCommand
dr As pg.PgSqlDataReader

cn.Open()
cmd.commandText = "Select * from "
dr = cmd.ExecuteReader

While dr.Read
textBox.Text=dr.Item("email")
End While

dr.Close()
cmd.Dispose()
cn.Close()

No comments: