C#操作Access之按列读取mdb浅析

<ol><li><span><span>using</span><span> System.Data.OleDb;  </span></span></li><li><span> </span></li><li><span>using</span><span> System.Data; </span></li></ol>

<ol><li><span>String connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;  </span></li><li><span> </span></li><li><span>Data Source=product.mdb"; </span></li></ol>

<ol><li><span><span>OleDbConnection connection = </span><span>new</span><span> OleDbConnection(connectionString); </span></span></li></ol>

<ol><li><span><span>OleDbCommand cmd = </span><span>new</span><span> OleDbCommand(sql, connection);  </span></span></li><li><span> </span></li><li><span>connection.Open();  </span></li><li><span> </span></li><li><span>cmd.ExecuteNonQuery(); </span></li></ol>

<ol><li><span><span>// 读取mdb数据  </span><span> </span></span></li><li><span>public</span><span> </span><span>static</span><span> DataTable ReadDataByColumns(</span><span>string</span><span> mdbPaht,</span></li><li><span>string</span><span> tableName, </span><span>string</span><span>[] columns, </span><span>ref</span><span> </span><span>bool</span><span> success)   </span></li><li><span>{   </span></li><li><span>    DataTable dt = </span><span>new</span><span> DataTable();   </span></li><li><span>    </span><span>try</span><span>   </span></li><li><span>    {   </span></li><li><span>DataRow dr;   </span></li><li><span>//1、建立连接 C#操作Access之按列读取mdb </span><span> </span></li><li><span>string</span><span> strConn = @</span><span>"Provider=Microsoft.</span></li><li><span>Jet.OLEDB.4.0;Data Source="</span><span> </span></li><li><span>&#43; mdbPath &#43; </span><span>";Jet OLEDB:Database Password=haoren"</span><span>;   </span></li><li><span>OleDbConnection odcConnection = </span></li><li><span>new</span><span> OleDbConnection(strConn);   </span></li><li><span>//2、打开连接 C#操作Access之按列读取mdb </span><span> </span></li><li><span>odcConnection.Open();   </span></li><li><span>//建立SQL查询  </span><span> </span></li><li><span>OleDbCommand odCommand = odcConnection.CreateCommand();   </span></li><li><span>//3、输入查询语句  </span><span> </span></li><li><span>string</span><span> strColumn = </span><span>""</span><span>;   </span></li><li><span>for</span><span> (</span><span>int</span><span> i = 0; i < columns.Length; i&#43;&#43;)   </span></li><li><span>{   </span></li><li><span>    strColumn &#43;= columns[i].ToString() &#43; </span><span>","</span><span>;   </span></li><li><span>}   </span></li><li><span>strColumn = strColumn.TrimEnd(</span><span>','</span><span>);   </span></li><li><span>odCommand.CommandText = </span><span>"select "</span><span>&#43;strColumn&#43;</span></li><li><span>" from "</span><span> &#43; tableName;   </span></li><li><span>//建立读取 C#操作Access之按列读取mdb </span><span> </span></li><li><span>OleDbDataReader odrReader = </span></li><li><span>odCommand.ExecuteReader();   </span></li><li><span>//查询并显示数据 C#操作Access之按列读取mdb </span><span> </span></li><li><span>int</span><span> size = odrReader.FieldCount;   </span></li><li><span>for</span><span> (</span><span>int</span><span> i = 0; i < size; i&#43;&#43;)   </span></li><li><span>{   </span></li><li><span>    DataColumn dc;   </span></li><li><span>    dc = </span><span>new</span><span> DataColumn(odrReader.GetName(i));   </span></li><li><span>    dt.Columns.Add(dc);   </span></li><li><span>}   </span></li><li><span> </span></li><li><span>while</span><span> (odrReader.Read())   </span></li><li><span>{   </span></li><li><span>    dr = dt.NewRow();   </span></li><li><span>    </span><span>for</span><span> (</span><span>int</span><span> i = 0; i < size; i&#43;&#43;)   </span></li><li><span>    {   </span></li><li><span>dr[odrReader.GetName(i)] = odrReader[</span></li><li><span>odrReader.GetName(i)].ToString();   </span></li><li><span>    }   </span></li><li><span>    dt.Rows.Add(dr);   </span></li><li><span>}   </span></li><li><span>//关闭连接 C#操作Access之按列读取mdb </span><span> </span></li><li><span>odrReader.Close();   </span></li><li><span>odcConnection.Close();   </span></li><li><span>success = </span><span>true</span><span>;   </span></li><li><span>return</span><span> dt;   </span></li><li><span>    }   </span></li><li><span>    </span><span>catch</span><span>   </span></li><li><span>    {   </span></li><li><span>success = </span><span>false</span><span>;   </span></li><li><span>return</span><span> dt;   </span></li><li><span>    }   </span></li><li><span>}  </span></li></ol>