最近用到了C#得数据库,虽然一开始学的是linq但是现在决定还是掌握更为基础的ADO.NET 数据库连接方法
1) OleDbDataAdapter
OleDbConnection Connector = new OleDbConnection(StrConnect);//建立连接
Connector.Open();
string SELECT_DATA = "SELECT * FROM [" + Tb_Data + "]";
OleDbDataAdapter Da = new OleDbDataAdapter(SELECT_DATA, Connector);
DataTable TableTemp = new DataTable();//
Da.Fill(TableTemp);//将OleDbDataAdapter 填充到DataTable数据表中,然后对DataTable进行操作
_nFeatureNumber = TableTemp.Rows.Count;
Features = new Feature[_nFeatureNumber];
int ifeature = 0;
foreach (DataRow row in TableTemp.Rows)
{
Features[ifeature] = new Feature();
Features[ifeature].IsDigit = (bool)row["IsDigit"];
Features[ifeature].Name = (string)row["FeatureName"];
Features[ifeature].FeatureLevel = (int)row["FeatureLevel"];
if (!Features[ifeature].IsDigit && row["Choises"] != null)
Features[ifeature].SetNominalValues((string)row["Choises"]);
++ifeature;
}
Da.Dispose();