string conStr = "user id=system;password=manager;data source=oradb"; //oradb改成自己的
OledbConnection con = new OledbConnection(conStr); //最好自己输入以免出现输入错误
con.Open();
DataSet myset1 = new DataSet();
DataTable mytable1 =myset1.Table[0];
string conselect = "select ... from xx";
OleDbDataAdapter myadapter1 = new OleDbDataAdapter(conselect, con);
myadapter1.Fill(myset1, "database");//到这就填充完了
仅供参考