data connection

dbcon.aspx.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.OleDb;

 

public partial class dbcon : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        string conn = @"provider=microsoft.jet.oledb.4.0;data source=F:\\DataBase\\books.mdb";

        OleDbConnection con = new OleDbConnection(conn);
        con.Open();

        string sql = "select * from book";
        OleDbCommand cmd = new OleDbCommand(sql, con);

        OleDbDataReader reader = cmd.ExecuteReader();

        while (reader.Read())
        {

            Response.Write(reader[0] + " / ");
            Response.Write(reader[1] + " / ");
            Response.Write(reader[2] + "<br>");

        }
        reader.Close();
        con.Close();

 

    }
}