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" %>
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