`

Excel导入Dataset

阅读更多
//filepath是Excel的路径
 #region 上传时的数据DataSet绑定:
    protected DataSet DSBind(string filePath)
    {
        String ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + filePath + ";" + "Extended Properties=Excel 8.0;";
        //Create connection object by using the preceding connection string. 
        OleDbConnection objConn = new OleDbConnection(ConnectionString);
        objConn.Open();
        OleDbCommand objCmdSelect = new OleDbCommand("SELECT * FROM [Sheet1$]", objConn);
        OleDbDataAdapter objAdapter1 = new OleDbDataAdapter();

        objAdapter1.SelectCommand = objCmdSelect;
        DataSet objds = new DataSet();
        objAdapter1.Fill(objds, "feeBudget");
        return objds;
        objConn.Close();
    }
    #endregion
分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics