C# DataGridView ´æÈë AccessÊý¾Ý¿âÎÊÌâ

ÇëÎÊÈçºÎ½«DataGridviewÀïµÄÊý¾Ý´æÈëÒ»¸öеÄAccessÎļþ£¿
ÎÒµÄ×ö·¨ÊÇ£ºÏÈÓÃADOX´´½¨ÁËÒ»¸öеÄÊý¾Ý¿âÎļþ£¬È»ºó½«DataGridviewµÄÊý¾Ý·ÅÈëDataTable£¬ÔÙinsertµ½¸Õ½¨µÄmdbÎļþ£¬µ«ÊÇÔÚÍùÀïÃæ´´½¨±íÊÇÀϳö´í£¬ÎªÊ²Ã´£¿ÎҵĴúÂëÈçÏ£º

DataTable dt = new DataTable();
for (int i = 0; i < displayDataGridView.Columns.Count; i++)               
{
    DataColumn dc = new DataColumn();
    dc.ColumnName = displayDataGridView.Columns[i].HeaderText;
    dt.Columns.Add(dc);
}
for (int i = 0; i < displayDataGridView.Rows.Count - 1; i++)
{
    DataRow dr = dt.NewRow();
    for (int j = 0; j < displayDataGridView.Columns.Count; j++)
    {
        dr[j] = displayDataGridView.Rows[i].Cells[j].Value;
    }
    dt.Rows.Add(dr);
}
string tablename="Êý¾Ý";
ADOX.CatalogClass cat = new CatalogClass();
cat.Create("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + fileName + ";");               
OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+fileName);
con.Open();

OleDbCommand cmd = new OleDbCommand();
cmd.Connection = con;
cmd.CommandText = "CREATE&nbs