<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<script Language="c#" runat="server">
void Page_Load()
{
string strConnection = "Provider=Microsoft.Jet.OleDb.4.0;";
// strConnection += @"Data Source=C:\Northwind.mdb";
strConnection += @"Data Source="+MapPath("EmployeeDatabase.mdb"); data_src.Text = strConnection;
string strSQL = "SELECT FirstName, LastName FROM Employee;";
DataSet objDataSet = new DataSet();
OleDbConnection objConnection = new OleDbConnection(strConnection);
OleDbDataAdapter objAdapter = new OleDbDataAdapter(strSQL, objConnection);
try
{
objAdapter.Fill(objDataSet, "Employees");
DataView objDataView = new DataView(objDataSet.Tables["Employees"]);
dgNameList.DataSource = objDataView;
dgNameList.DataBind();
}
catch (OleDbException objError)
{
if (objError.Message.Substring(0,21) == "Login failed for user")
{
divErrorReport.InnerHtml = "Problem with Log-in";
}
else if (objError.Message.Substring(0,19) == "Could not find file")
{
divErrorReport.InnerHtml =
"We could not find the MDB file that you asked for";
}
else
{
divErrorReport.InnerHtml = "<br />message - " + objError.Message;
divErrorReport.InnerHtml += "<br />source - " + objError.Source;
}
}
}
</script>
<html>
<body>
<h4>Writing data from the connection
<asp:label id="data_src" runat="server"/>
to the DataGrid control with error checking.</h4>
<div id="divErrorReport" runat="server"> </div>
<asp:datagrid id="dgNameList" runat="server" /><br />
</body>
</html>
