随机文章

• HTML编辑器不大全
• 小巧独立的Javascript库(6):jsTree.js
• Log Explorer for SQL Server
• JavaScript游戏库及25个网页游戏
• JavaScript图形库Raphaël
• Notepad++
• 阿拉伯数字转换成中文大写金额（包括小数）(C#)[1]
• 小巧独立的Javascript库(1):Events.js
• Lucene.Net简单应用
• SyntaxEditor

站点统计

• 分类总数: 13 个
• 文章总数: 145 篇
• 评论总数: 47 条
• 附件总数: 59 个
• 建站日期: 2008-08-18
• 访问总数: 472873 人次
• RSS订阅: 文章|评论

最新评论

• 不是我想要看的: 不是我想要看的
• 飞利浦照明代理: 很不错的啊！
• egmkang: 这个是DOM模型的 还有一个SAX模型的irrXML,也可以用
• research paper: written original work discussing a topic in detail, usually several typed pages in length and is often due at the end of a semeste
• writer jobs: thanks
• 11: 哪里抄的啊
• sgfds: gsdg dsfg fdg f fffffffffffffffffffffffff f f f f f f f f f f f fffffffffffffffffffffff ...
• sgfds: df
• Jim Guthrie: We have the ability to quickly promote your site to the top of the search engines. Please let me know if I can send you a proposal to show you how we can achieve these results for you?
• Jim Guthrie: We have the ability to quickly promote your site to the top of the search engines. Please let me know if I can send you a proposal to show you how we can achieve these results for you?

通过OleDbConnection加载Excel文档到DataSet

Admin 于 2008-08-31 05:29:24 发表.Net

订阅: http://www.kaiyuan8.org/Feed/Article_17.aspx
引用: 点这里获取地址 (UTF-8)
开源项目Koogra——纯.net实现的Excel文档读取器 < 通过OleDbConnection加载Excel文档到DataSet > Lua 5.1.4 Binary 发布了

private DataSet LoadFile(string fileName) 
{ 
    DataSet ret = new DataSet(); 
 
    System.Data.OleDb.OleDbConnection myConnection = new System.Data.OleDb.OleDbConnection(); 
 
    //You should consider using "HDR=NO", to get numbered ColumnNames in your DataSet. 
    myConnection.ConnectionString = 
          string.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Persist Security Info=False;Extended Properties=\"Excel 8.0;HDR=YES;IMEX=1;\"", fileName); 
 
    //Try-Catch-Finally?  
    myConnection.Open(); 
 
    //Get all Table-Names from the workbook 
    DataTable tbl = myConnection.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" }); 
 
    foreach (DataRow row in tbl.Rows) 
    { 
        string tableName = row[2].ToString(); 
 
        System.Data.OleDb.OleDbCommand selectCommand = new System.Data.OleDb.OleDbCommand(string.Format("SELECT * FROM [{0}]", tableName), myConnection); 
        System.Data.OleDb.OleDbDataAdapter myAdapter = new System.Data.OleDb.OleDbDataAdapter(selectCommand); 
 
        myAdapter.Fill(ret, tableName); 
    } 
 
    myConnection.Close(); 
    return ret; 
}