Displaying Info. from MS Access
After connecting asp.net with ms access..
dim dbconn, sql , dbcomm, dbread
dbconn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; data source =" & server.mappath("PULSystem.mdb"))
dbconn.Open()
sql="SELECT * FROM Book WHERE BookID='" & id_txt.Text & "'"
dbcomm = New OleDbCommand(sql,dbconn)
dbread = dbcomm.ExecuteReader()
i would like to display a data from a field from a table into a textbox. How do i do that?
<%#Container.DataItem("BookID")%>
i did this for a table & it works fine but i can't put it into a textbox of label.
Please help me out here.. thanks!
(^.^) v
|