Hi All - I am an experienced ASP developer but am new to ASP.NET and the .NET
framework and am trying to learn how to access datasets.
When I try to build the following page, I get the errow below. I've
reviewed my code over and over and looked for similar errors/information on
the web but I can't seem to find what the problem is, and therefore I can't
come up with a solution. Can anyone help me? Thanks in advance...
Page (am hitting a local Access db/table, which does have records):
<%@ Page Language="VB" Debug="True"%>
<%@ Import Namespace="Syst em.Data" %>
<%@ Import Namespace="Syst em.Data.OleDb" %>
<script runat="server">
sub Page_Load(Sende r as Object, e as EventArgs)
'set up connection
dim ObjConn as new OleDbConnection ("Provider=Micr osoft.Jet.OLEDB .4.0;" & _
"DataSource=c:\ Inetpub\wwwroot \aspbook\data\b anking.mdb")
'open connection
dim ObjCmd as new OleDbDataAdapte r("select * from tblUsers", objConn)
'fill dataset
dim ds as DataSet = new DataSet()
ObjCmd.Fill(ds, "tblUsers")
'select data view and bind to server control
MyDataList.Data Source = ds.Tables("tblU sers").DefaultV iew
MyDataList.Data Bind()
end sub
</script>
<html><body>
<ASP:DataList id="MyDataList " RepeatColumns=" 2" RepeatDirection ="Vertical"
runat="server">
<ItemTemplate >
<div style="padding: 15,15,15,15; font-size:10pt; font-family:Verdana" >
<div style="font:12 pt verdana; color:darkred">
<i><b>
<%# DataBinder.Eval (Container.Data Item, "FirstName" )%>
<%# DataBinder.Eval (Container.Data Item, "LastName") %>
</i></b>
</div>
<br>
<b>Address: </b><%# DataBinder.Eval (Container.Data Item, "Address")%><br >
<b>City: </b><%# DataBinder.Eval (Container.Data Item, "City")%><b r>
<b>State: </b><%# DataBinder.Eval (Container.Data Item, "State")%>< br>
<b>ZIP: </b><%# DataBinder.Eval (Container.Data Item, "ZipCode")%><br >
<b>Phone: </b><%# DataBinder.Eval (Container.Data Item, "Phone")%>< br>
</div>
</ItemTemplate>
</ASP:DataList>
</body></html>
Error:
Could not find installable ISAM.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.
Exception Details: System.Data.Ole Db.OleDbExcepti on: Could not find
installable ISAM.
Source Error:
Line 14: 'fill dataset
Line 15: dim ds as DataSet = new DataSet()
Line 16: ObjCmd.Fill(ds, "tblUsers")
Line 17:
Line 18: 'select data view and bind to server control
