/=1、简单读取数据表并显示到dataGridView控件=====
//连接数据库
OleDbConnection conn = null;
string str = "Provider=Microsoft.Jet.Oledb.4.0;";
str += @"Data Source=D:\CHManager\SUNFULCESS.mdb"; //连接字符串
try
{
conn = new OleDbConnection(str);
}
catch (Exception ex)
{
throw ex;
}
//将数据库中的内容在datagridview中显示
string sql = "select * from Partner ";
OleDbDataAdapter da = new OleDbDataAdapter(sql, conn); //实例化DataAdapter
DataSet ds = new DataSet();
da.Fill(ds,"Partner"); //用da去填充空白的ds表格
DataTable dt=ds.Tables["Partner"];
dataGridView1.DataSource = dt;
效果如下图