求ExcelHelper 类

[prettyfriend]

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

[porschev]

//<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;
}
}

[garfieldzf]

参考

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

[zailushang_]

/// <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");
        }