Server Error in '/begASPNET' Application.
--------------------------------------------------------------------------------
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.OleDb.OleDbException: Could not find installable ISAM.
Source Error:
Line 19: objConnection = New OleDbConnection(strConnect)
Line 20: objCommand = New OleDbDataAdapter(strCommand, objConnection)
Line 21: objCommand.Fill(DataSet1, "Products")
Line 22: DataGrid1.DataSource=DataSet1.Tables("Products") .DefaultView
Line 23: DataGrid1.DataBind()
Source File: C:\begASPNET\ch02\datacontrol1.aspx Line: 21
Stack Trace:
[OleDbException (0x80004005): Could not find installable ISAM.]
System.Data.OleDb.OleDbConnection.ProcessRes ults(Int32 hr) +20
System.Data.OleDb.OleDbConnection.Initialize Provider() +57
System.Data.OleDb.OleDbConnection.Open() +203
System.Data.Common.DbDataAdapter.QuietOpen(I DbConnection connection, ConnectionState& originalState) +44
System.Data.Common.DbDataAdapter.FillFromCom mand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +304
System.Data.Common.DbDataAdapter.Fill(DataSe t dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +77
System.Data.Common.DbDataAdapter.Fill(DataSe t dataSet, String srcTable) +36
ASP.datacontrol1_aspx.Page_Load(Object Sender, EventArgs E) in C:\begASPNET\ch02\datacontrol1.aspx:21
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731
--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573
HERE IS MY CODE:
<%@ Import Namespace="system.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<%@ Page Language="
vb" Debug="true" %>
<script language="
vb" runat="server">
Sub Page_Load(Sender As Object, E as EventArgs)
Dim objConnection As OleDbConnection
Dim objCommand As OleDbDataAdapter
Dim strConnect As String
Dim strCommand As String
Dim DataSet1 As New DataSet
StrConnect = "Provider=Microsoft.Jet.OLEDB.4.0;"
StrConnect += "Data Scorce=C:\begASPNET\sourceCode\Ch02\"
'StrConnect += "Samples\quickstart\aspplus\samples\grocertogo\dat a"
StrConnect += "\grocertogo.mdb;"
StrConnect += "Persist Security Info=False"
StrCommand = "SELECT ProductName, UnitPrice FROM products"
objConnection = New OleDbConnection(strConnect)
objCommand = New OleDbDataAdapter(strCommand, objConnection)
objCommand.Fill(DataSet1, "Products")
DataGrid1.DataSource=DataSet1.Tables("Products").D efaultView
DataGrid1.DataBind()
End Sub
</script>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Data Grid Control example</title>
</head>
<body>
<asp:DataGrid id="DataGrid1" runat="server" />
</body>
</html>
What can I do to get up and running with this ASP.NET example.
Please help cannot find solution to this problem
