winform 操作Access

数据库保存为access 2003版本，后缀为mdb的文件

string path = Directory.GetCurrentDirectory() + @"\App_Data\Database211.mdb";
OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+ path); //Jet OLEDB:Database Password=
OleDbCommand cmd = conn.CreateCommand();

cmd.CommandText = "select * from news";
conn.Open();
OleDbDataReader dr = cmd.ExecuteReader();
DataTable dt = new DataTable();
if (dr.HasRows)
{
for (int i = 0; i < dr.FieldCount; i++)
{
dt.Columns.Add(dr.GetName(i));
}
dt.Rows.Clear();
}
while (dr.Read())
{
DataRow row = dt.NewRow();
for (int i = 0; i < dr.FieldCount; i++)
{
row[i] = dr[i];
}
dt.Rows.Add(row);
}
cmd.Dispose();
conn.Close();
dataGridView1.DataSource = dt;