actually this is what i got that gives the same effect using an OLEDBConnection, OLEDBCommand, OLEDBDataReader:I thought I would post my answer in case anyone else wondered about it. I actually found it in another recent post. I couldn't find it until after I post my question. It gives the exact same efffect as the .BOF and .EOF.VB Code:
dim objconn, sql, objcomm, objreader objconn = New OLEDBConnection("Provider=Microsoft.Jet.OLEDB.4.0; data source=" & server.MapPath("users.mdb")) objconn.open() sql = "SELECT * FROM Employeelist" objcomm = new OLEDBCommand(sql, objconn) objreader = objcomm.ExecuteReader() try if objreader.read = false label1.text = "Nothing Found" objreader.close() objconn.close() else carcat.datasource = objreader carcat.databind() objreader.close() objconn.close() label1.text = "Data Found" end if catch ex as exception msgbox(ex.message) end try
This is for an ASP.NET page.






Reply With Quote