Monday, 11 July 2016

ADO Access Database Connction

protected void Page_Load(object sender, EventArgs e)
    {
        
        OleDbCommand oleDbCmd = new OleDbCommand();

        OleDbConnection connParam = new        OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=E:\\ADO\\Database2.accdb;Persist Security Info=False");
        OleDbCommand cmd = new OleDbCommand("select * from Demo", connParam);
        connParam.Open();
        OleDbDataReader rdr = cmd.ExecuteReader();
        GridView1.DataSource = rdr;
        GridView1.DataBind();
        connParam.Close();

     

    }