<%@ 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");
string strSQL = "Select LastName, FirstName, ID from Employee;";
OleDbConnection objConnection = new OleDbConnection(strConnection);
OleDbCommand objCommand = new OleDbCommand(strSQL,objConnection);
objConnection.Open();
dgEmps.DataSource = objCommand.ExecuteReader(CommandBehavior.CloseConnection);
dgEmps.DataBind();
}
</script>
<html>
<body>
<asp:datagrid id="dgEmps"
runat="server"
CellPadding="3"
Font-Name="arial"
Font-Size="8pt"
HeaderStyle-BackColor="#dcdcdc"
HeaderStyle-ForeColor="blue"
/>
</body>
</html>
