private DataTable GetDepartment()
{
DataTable dt = new DataTable();
using (System.Data.OleDb.OleDbConnection connection = new System.Data.OleDb.OleDbConnection(@"rovider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\Test.mdbersist Security Info=True"))
{
System.Data.OleDb.OleDbDataAdapter adapter = new System.Data.OleDb.OleDbDataAdapter("SELECT * FROM Department", connection);
adapter.Fill(dt);
}
return dt;
}
关于sqlserver数据库获取数据集 的调用的方式是怎么写的呢? |