最近用到了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();
发布者:全栈程序员-站长,转载请注明出处:https://javaforall.net/217498.html原文链接:https://javaforall.net
