using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

using System.Data.OleDb;

public partial class _Default : System.Web.UI.Page 
{
    protected void Page_Load(object sender, EventArgs e)
    {
        OleDbConnection conn;
        OleDbCommand command;
        OleDbDataReader rdrResults;
        string strConn;
        string strSQL;

        strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +
                    "Data Source=" +
                    Server.MapPath("books.mdb") + ";";

        conn = new OleDbConnection(strConn);

        conn.Open();

        strSQL = "Select * from Titles";

        command = new OleDbCommand(strSQL, conn);

        rdrResults = command.ExecuteReader();

        grdCategories.DataSource = rdrResults;
        grdCategories.DataBind();

        rdrResults.Close();

        conn.Close();
    }
}