最近在做一个项目,要求把DataSet里的数据导出到Excel文件当中,使用OleDb的链接方法。然后,当中数据的列数比较多,直接使用列举参数的方法,显得不安全和代码冗余。于是提高了要求,全部用Parameters来写。下面把整理的代码放在这:
OleDbConnection conn = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + FilePath + ";Extended Properties='Excel 12.0 Xml;HDR=YES';");
using (conn)
{
conn.Open();
OleDbCommand DBCmd = new OleDbCommand();
DBCmd.Connection = conn;
DataSet ds = Load_DataSet();
DataTable result = ds.Tables["Search Report"];
OleDbParameter[] Params = new OleDbParameter[result.Column
using (conn)
{
conn.Open();
OleDbCommand DBCmd = new OleDbCommand();
DBCmd.Connection = conn;
DataSet ds = Load_DataSet();
DataTable result = ds.Tables["Search Report"];
OleDbParameter[] Params = new OleDbParameter[result.Column