求ExcelHelper 类

Question

要求:将EXCEL中的数据导入DataSet中，在上的找的ExcelHelper 类没有对DataSet的操作，哪位兄弟有发我一份呗

Answer 1

//<summary>
///从Excel提取数据--》Dataset
///</summary>
///<paramname="filename">Excel文件路径名</param>
privatevoidImportXlsToData(stringfileName)
{
try
{
if(fileName==string.Empty)
{
thrownewArgumentNullException("上传文件失败！");
}
//
stringoleDBConnString=String.Empty;
oleDBConnString="Provider=Microsoft.Jet.OLEDB.4.0;";
oleDBConnString+="DataSource=";
oleDBConnString+=fileName;
oleDBConnString+=";ExtendedProperties=Excel8.0;";
//
OleDbConnectionoleDBConn=null;
OleDbDataAdapteroleAdMaster=null;
DataTablem_tableName=newDataTable();
DataSetds=newDataSet();oleDBConn=newOleDbConnection(oleDBConnString);
oleDBConn.Open();
m_tableName=oleDBConn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables,null);if(m_tableName!=null&&m_tableName.Rows.Count>0)
{m_tableName.TableName=m_tableName.Rows[0]["TABLE_NAME"].ToString();}
stringsqlMaster;
sqlMaster="SELECT*FROM["+m_tableName.TableName+"]";
oleAdMaster=newOleDbDataAdapter(sqlMaster,oleDBConn);
oleAdMaster.Fill(ds,"m_tableName");
oleAdMaster.Dispose();
oleDBConn.Close();
oleDBConn.Dispose();//测试是否提取数据
//this.Datagrid1.DataSource=ds.Tables["m_tableName"];
//this.Datagrid1.DataBind();
//将Dataset中数据导入SQL
AddDatasetToSQL(ds);}
catch(Exceptionex)
{
throwex;
}
}

Answer 2

参考示例中把Excel数据导入指定datatable中
导入dataset 你懂的。

Answer 3

/// <summary>
        /// Execute T-SQL, return with a DataSet
        /// </summary>
        public DataSet GetList(string strSQL, string strTableName)
        {
            using (OleDbConnection connection = new OleDbConnection(strConn))
            {
                DataSet ds = new DataSet();
                try
                {
                    connection.Open();
                    OleDbDataAdapter adapter = new OleDbDataAdapter(strSQL, connection);
                    adapter.Fill(ds, strTableName);
                }
                catch (OleDbException E)
                {
                    throw new Exception(E.Message);
                }
                return ds;
            }
        }
        public DataSet GetList(string strSQL)
        {
            return GetList(strSQL, "myTable");
        }