Hi
i am just converting to asp.net from classic and am having trouble with connecting and displaying data from a MSACCESS datasource. i have written a very basic script and after numerous tries i think i managed to open the database but i now get a "No data exists for row/column". There is data there but i have obviously missed something. Below is my code, please can anybody help!!

<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<%@Page Language="VB" Explicit="True"%>
<script language="vb" runat="server">
sub page_load()
dim strsource as string ="Provider=microsoft.jet.oledb.4.0;Data Source=e:\web databases\stationary.mdb"
dim sqltext as string="select * from stationary"

dim StrResult as string

dim objconn as new oledbconnection(strsource)
dim objcom as new oledbcommand(sqltext, objconn)

dim objdatareader as oledbdatareader
objconn.open()

objdatareader=objcom.executereader()

StrResult +=objdatareader("item")
end sub
</script>

hi,
you are using your mdb name in select query,
in query there should be a table name. Is that so?
just check it.

Indian Ocean
"Rago Me Daudate Firne Ke Hum Nahi Kayal;
Jo Aankh Hi Se Na Tapka To Fir Lahoo Kya!"

Try Opening your connection before sending it to your command.