C# .NET - Extract the Data from MS Access to Datagridview

Asked By sachin on 05-Sep-11 02:23 AM

hi

my requirement is that to Export the data from MS Access and show on Datagridview

plz give me a sample code

dipa ahuja replied to sachin on 05-Sep-11 02:28 AM

try this code:

void bind()
{
  string cs = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=hotel.mdb";
  OleDbDataAdapter da = new OleDbDataAdapter("Select * from table1", cs);
  DataTable dt = new DataTable();
  da.Fill(dt);
  dataGridView1.DataSource = dt;
}

Reena Jain replied to sachin on 05-Sep-11 02:31 AM

hi,

bind the data on formload event

OledbDataAdapter da = new OledbDataAdapter("SELECT * From table1", con);

dataset ds=new dataset();

da.Fill(ds);

if (ds.Tables[0].Rows.Count > 0)

{

dataGridView1.DataSource = ds.Tables[0];

}

you need use oledb for ado.net to link C#.net to ms access database

Anoop S replied to sachin on 05-Sep-11 03:13 AM

Try this
string sFilePath = Server.MapPath("MSACCESS.mdb");
DataTable dt;
OleDbConnection Conn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + sFilePath + ";");

using (Conn)
{
Conn.Open();
OleDbCommand cmd = new OleDbCommand("SELECT * FROM ARTICLE", Conn);
OleDbDataAdapter oDA = new OleDbDataAdapter(cmd);
dt = new DataTable();
oDA.Fill(dt);
}

gvArticle.DataSource = dt;
gvArticle.DataBind();

}
}