1、数据来源
从sql server中导出,在导出选择目标服务器时,要选择microsoft jet database engine,否则数据会无法读出
2、数据库连接
OleDbConnection,OleDbCommand,OleDbDataAdapter,
如果是在控制台中,可以利用OleDbDataReader。
3、典型代码
string apppath = System.Windows.Forms.Application.StartupPath //获取整个文件路径名
apppath += @"\student1.mdb";
string strCon = "Provider = Microsoft.Jet.OLEDB.4.0;Data Source = " +apppath;
OleDbConnection oleConn = new OleDbConnection(strCon);
try
{
oleConn.Open();
string strQuery = "select * from student_scyx ";
OleDbDataAdapter oleda = new OleDbDataAdapter(strQuery, oleConn);
oleda.Fill(ds, "DataStudent");
return ds;
}
catch (Exception ee)
{
Console.WriteLine(ee.Message.ToString());
throw (ee);
}
finally
{
oleConn.Close();
}
4、界面中方法调用。