如何用OLEDB来访问Access数据库？

Question

string strconn="Provider=msdaora;Data Source=MyOracleDB;User Id=UserName;Password=asdasd;" or"Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User Id=Username;Password=asdasd;" or
"Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;OSAuthent=1;" 然后OleDbConnection oledbcon=new OleDbConnection(strconn);

Answer 1

..................
using System.Data;
using System.Data.OleDb; private void button9_Click(object sender, System.EventArgs e)
{ string source=@"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=e:\North.mdb";
string strsql="select * from supply"; OleDbDataAdapter da=new OleDbDataAdapter(strsql,source); 
DataSet ds=new DataSet();
da.Fill(ds,"tab");
dataGrid1.SetDataBinding(ds,"tab");
dataGrid1.CaptionText ="開天劈地﹗";
}