＋设为首页 ＋添加到收藏夹
rt
看看c#的书，上面都有
//加载记录从数据库
OleDbConnection myConn=new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\CSharp3\QXKMeTone\bin\Debug\First.mdb;");
myConn.Open();
OleDbDataAdapter thisAdapter= new OleDbDataAdapter("SELECT * FROM Student",myConn);
OleDbCommandBuilder thisBuilder=new OleDbCommandBuilder(thisAdapter);
DataSet thisDataSet=new DataSet();
thisAdapter.Fill(thisDataSet,tablename);
int nTotals=thisDataSet.Tables[tablename].Rows.Count;
Student student=new Student();
for(int i=0;i<nTotals;i++)
{
student.Name=(string)thisDataSet.Tables[tablename].Rows[i]["name"];
student.Sex=(bool)thisDataSet.Tables[tablename].Rows[i]["sex"];
student.Folk=(string)thisDataSet.Tables[tablename].Rows[i]["folk"];
student.Address=(string)thisDataSet.Tables[tablename].Rows[i]["address"];
student.Telephone=(string)thisDataSet.Tables[tablename].Rows[i]["telephone"];
}
myConn.Close();
