C# 鎿嶄綔excel鍜寈ml-嫻庡崡杞歡寮€鍙憒灞變笢杞歡寮€鍙?嫻庡崡璧㈠痙縐戞妧杞歡寮€鍙戝叕鍙?/title> <meta name="keywords" content="C# 鎿嶄綔excel鍜寈ml"/> <meta name="description" content="闇€瑕佹坊鍔燙OM緇勪歡 Interop.Excel.dll,Interop.Microsoft.Office.Core.dllusingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Data.OleDb;usingSystem.Text;using"/> <link href="/css/style.css" rel="stylesheet" type="text/css" /> <meta http-equiv="Cache-Control" content="no-transform" /> <meta http-equiv="Cache-Control" content="no-siteapp" /> </head> <body> <div style="position:fixed;left:-9000px;top:-9000px;"><dfn id="orz4q"><noscript id="orz4q"><xmp id="orz4q"><output id="orz4q"></output></xmp></noscript></dfn><strong id="orz4q"><dl id="orz4q"></dl></strong><ol id="orz4q"><p id="orz4q"><nav id="orz4q"><pre id="orz4q"></pre></nav></p></ol><dfn id="orz4q"></dfn><small id="orz4q"><optgroup id="orz4q"></optgroup></small><center id="orz4q"><small id="orz4q"><track id="orz4q"><rp id="orz4q"></rp></track></small></center><table id="orz4q"><ruby id="orz4q"><dl id="orz4q"><del id="orz4q"></del></dl></ruby></table><rt id="orz4q"></rt><output id="orz4q"></output><mark id="orz4q"></mark><dl id="orz4q"></dl><div id="orz4q"></div><optgroup id="orz4q"></optgroup><address id="orz4q"><progress id="orz4q"><noframes id="orz4q"><tr id="orz4q"></tr></noframes></progress></address><listing id="orz4q"><thead id="orz4q"><address id="orz4q"><wbr id="orz4q"></wbr></address></thead></listing><video id="orz4q"></video><object id="orz4q"><sup id="orz4q"></sup></object><em id="orz4q"></em><div id="orz4q"></div><progress id="orz4q"><listing id="orz4q"><th id="orz4q"><option id="orz4q"></option></th></listing></progress><meter id="orz4q"></meter><acronym id="orz4q"><rt id="orz4q"></rt></acronym><label id="orz4q"></label><track id="orz4q"></track><noscript id="orz4q"><div id="orz4q"><pre id="orz4q"><ol id="orz4q"></ol></pre></div></noscript><s id="orz4q"><kbd id="orz4q"></kbd></s><form id="orz4q"></form><var id="orz4q"></var><dl id="orz4q"><strike id="orz4q"></strike></dl><xmp id="orz4q"><strike id="orz4q"><small id="orz4q"><samp id="orz4q"></samp></small></strike></xmp><listing id="orz4q"><thead id="orz4q"><address id="orz4q"><progress id="orz4q"></progress></address></thead></listing><del id="orz4q"></del><object id="orz4q"><address id="orz4q"><samp id="orz4q"><rt id="orz4q"></rt></samp></address></object><ruby id="orz4q"></ruby><noframes id="orz4q"></noframes><code id="orz4q"></code><var id="orz4q"></var><nav id="orz4q"></nav><u id="orz4q"></u><span id="orz4q"></span><li id="orz4q"></li><tbody id="orz4q"><table id="orz4q"><span id="orz4q"><dl id="orz4q"></dl></span></table></tbody><optgroup id="orz4q"><xmp id="orz4q"><big id="orz4q"><em id="orz4q"></em></big></xmp></optgroup><var id="orz4q"></var><nav id="orz4q"></nav><rt id="orz4q"></rt><dfn id="orz4q"><font id="orz4q"><sub id="orz4q"><td id="orz4q"></td></sub></font></dfn><u id="orz4q"><s id="orz4q"></s></u><pre id="orz4q"><em id="orz4q"><p id="orz4q"><rp id="orz4q"></rp></p></em></pre><rt id="orz4q"><tr id="orz4q"></tr></rt> <pre id="orz4q"></pre><wbr id="orz4q"><rt id="orz4q"><tr id="orz4q"><output id="orz4q"></output></tr></rt></wbr><xmp id="orz4q"><pre id="orz4q"><em id="orz4q"><p id="orz4q"></p></em></pre></xmp><sub id="orz4q"></sub><p id="orz4q"></p><td id="orz4q"><tbody id="orz4q"></tbody></td><code id="orz4q"><video id="orz4q"><track id="orz4q"><tt id="orz4q"></tt></track></video></code><thead id="orz4q"></thead><source id="orz4q"><nobr id="orz4q"><cite id="orz4q"><td id="orz4q"></td></cite></nobr></source><del id="orz4q"></del><sub id="orz4q"></sub><code id="orz4q"></code><code id="orz4q"><menu id="orz4q"></menu></code><legend id="orz4q"><button id="orz4q"><source id="orz4q"><i id="orz4q"></i></source></button></legend><delect id="orz4q"></delect><ins id="orz4q"></ins><i id="orz4q"></i><pre id="orz4q"></pre><mark id="orz4q"></mark><b id="orz4q"><table id="orz4q"><strong id="orz4q"><noframes id="orz4q"></noframes></strong></table></b><source id="orz4q"></source><small id="orz4q"><optgroup id="orz4q"></optgroup></small><dl id="orz4q"></dl><center id="orz4q"><em id="orz4q"><track id="orz4q"><rp id="orz4q"></rp></track></em></center><address id="orz4q"></address><tt id="orz4q"><code id="orz4q"><nobr id="orz4q"><sub id="orz4q"></sub></nobr></code></tt><strong id="orz4q"></strong><delect id="orz4q"></delect><nobr id="orz4q"></nobr><strike id="orz4q"></strike><strong id="orz4q"></strong><optgroup id="orz4q"><xmp id="orz4q"><big id="orz4q"><em id="orz4q"></em></big></xmp></optgroup><menu id="orz4q"></menu><menu id="orz4q"></menu><small id="orz4q"><optgroup id="orz4q"></optgroup></small><input id="orz4q"><label id="orz4q"></label></input><big id="orz4q"><nobr id="orz4q"><track id="orz4q"><button id="orz4q"></button></track></nobr></big><sub id="orz4q"></sub><nav id="orz4q"><blockquote id="orz4q"></blockquote></nav><listing id="orz4q"><thead id="orz4q"><address id="orz4q"><wbr id="orz4q"></wbr></address></thead></listing><tbody id="orz4q"><table id="orz4q"></table></tbody><font id="orz4q"><mark id="orz4q"><meter id="orz4q"><tbody id="orz4q"></tbody></meter></mark></font><dl id="orz4q"><strike id="orz4q"><i id="orz4q"><samp id="orz4q"></samp></i></strike></dl><wbr id="orz4q"><noscript id="orz4q"></noscript></wbr><strong id="orz4q"><input id="orz4q"></input></strong><wbr id="orz4q"></wbr><legend id="orz4q"></legend><address id="orz4q"><progress id="orz4q"><noframes id="orz4q"><tr id="orz4q"></tr></noframes></progress></address><dfn id="orz4q"><font id="orz4q"><sub id="orz4q"><td id="orz4q"></td></sub></font></dfn><center id="orz4q"><ol id="orz4q"><noscript id="orz4q"><b id="orz4q"></b></noscript></ol></center> <u id="orz4q"><s id="orz4q"></s></u><u id="orz4q"><s id="orz4q"></s></u><output id="orz4q"></output><ruby id="orz4q"></ruby><wbr id="orz4q"></wbr><ins id="orz4q"></ins><s id="orz4q"><kbd id="orz4q"></kbd></s><b id="orz4q"></b><nobr id="orz4q"></nobr><strike id="orz4q"></strike><input id="orz4q"><label id="orz4q"></label></input><em id="orz4q"></em><form id="orz4q"></form><tbody id="orz4q"><table id="orz4q"><legend id="orz4q"><dl id="orz4q"></dl></legend></table></tbody><tr id="orz4q"></tr><dd id="orz4q"></dd><li id="orz4q"></li><code id="orz4q"></code><menu id="orz4q"><samp id="orz4q"></samp></menu><p id="orz4q"><rp id="orz4q"><u id="orz4q"><strong id="orz4q"></strong></u></rp></p><pre id="orz4q"><em id="orz4q"></em></pre><tbody id="orz4q"><table id="orz4q"></table></tbody><ol id="orz4q"><p id="orz4q"><label id="orz4q"><blockquote id="orz4q"></blockquote></label></p></ol><tr id="orz4q"><option id="orz4q"></option></tr><legend id="orz4q"></legend><p id="orz4q"><rp id="orz4q"><output id="orz4q"><strong id="orz4q"></strong></output></rp></p><menu id="orz4q"></menu><rt id="orz4q"></rt><rp id="orz4q"></rp><optgroup id="orz4q"></optgroup><del id="orz4q"></del><button id="orz4q"></button><rp id="orz4q"></rp><dfn id="orz4q"><font id="orz4q"><sub id="orz4q"><td id="orz4q"></td></sub></font></dfn><nav id="orz4q"><blockquote id="orz4q"></blockquote></nav><thead id="orz4q"><menuitem id="orz4q"><progress id="orz4q"><noscript id="orz4q"></noscript></progress></menuitem></thead><sup id="orz4q"><acronym id="orz4q"></acronym></sup><center id="orz4q"></center><font id="orz4q"></font><noscript id="orz4q"><div id="orz4q"></div></noscript><font id="orz4q"></font><wbr id="orz4q"><noscript id="orz4q"></noscript></wbr><meter id="orz4q"></meter><optgroup id="orz4q"><xmp id="orz4q"><big id="orz4q"><em id="orz4q"></em></big></xmp></optgroup><nav id="orz4q"></nav><input id="orz4q"><label id="orz4q"><menuitem id="orz4q"><progress id="orz4q"></progress></menuitem></label></input><address id="orz4q"></address><dl id="orz4q"></dl><progress id="orz4q"></progress><video id="orz4q"></video></div> <div class="head"> <div class="top"><span><a href="/html/sitemap.xml">XML</a> | <a href="/html/sitemap.html">HTML</a> | <a href="/sitemap.txt">TXT</a></span></div> <div class="bank"> <div class="logo"> <h1><strong><a href="http://www.themmauniversity.com" style="margin-right:10px">嫻庡崡杞歡寮€鍙?/a></strong><strong><a href="http://www.themmauniversity.com">灞變笢杞歡寮€鍙?/a></strong></h1> </div> <div class="contact-top"></div> </div> <div class="menu"> <ul> <li><a href="/">棣?#160; 欏?/a></li> <li><a href="/About/">鍏充簬鎴戜滑</a></li> <li><a href="/Advantage/">寮€鍙戜紭鍔?/a></li> <li><a href="/Products/">浜у搧灞曠ず</a></li> <li><a href="/Cooperation/">鍚堜綔浼佷笟</a></li> <li><a href="/News/">鏂伴椈鍔ㄦ€?/a></li> <li><a href="/Contact/">鑱旂郴鎴戜滑</a></li> </ul> </div> <div class="banner"><img src="/images/banner.jpg" width="1000" height="341"/></div> </div> <div id="position"><div>鎮ㄥ綋鍓嶄綅緗細<a href="/">杞歡寮€鍙?/a> >> <a href="/News/">鏂伴椈鍔ㄦ€?/a> >> <a href="/News/Technology/">杞歡寮€鍙戞妧鏈?/a> >> 嫻忚鏂囩珷</div></div> <div class="youshi_f1" id="youshi_tdyx"> <div class="youshi01"> <h1 class="article_title">C# 鎿嶄綔excel鍜寈ml</h1> <div class="article_author">娣誨姞鏃墮棿錛?016-12-20 17:14:44 鏂囩珷浣滆€咃細<a href="/">嫻庡崡杞歡寮€鍙?/a> 嫻忚嬈℃暟錛?Script Language="Javascript" Src="/item/GetHits.asp?Action=Count&GetFlag=0&m=1&ID=3069"></Script></div> <div class="article_main"><div id="MyContent"><p style="margin-top: 0px; margin-bottom: 0px; padding: 15px 0px 0px; line-height: 30px; font-family: 瀹嬩綋; color: rgb(51, 51, 51); font-size: 13.3333px; white-space: normal; background-color: rgb(241, 241, 241);">闇€瑕佹坊鍔燙OM緇勪歡 Interop.Excel.dll,Interop.Microsoft.Office.Core.dll</p><p style="margin-top: 0px; margin-bottom: 0px; padding: 15px 0px 0px; line-height: 30px; font-family: 瀹嬩綋; color: rgb(51, 51, 51); font-size: 13.3333px; white-space: normal; background-color: rgb(241, 241, 241);">using System;<br style="margin: 0px; padding: 0px;"/>using System.Collections.Generic;<br style="margin: 0px; padding: 0px;"/>using System.ComponentModel;<br style="margin: 0px; padding: 0px;"/>using System.Data;<br style="margin: 0px; padding: 0px;"/>using System.Data.OleDb;<br style="margin: 0px; padding: 0px;"/>using System.Text;<br style="margin: 0px; padding: 0px;"/>using System.Drawing;<br style="margin: 0px; padding: 0px;"/>using System.IO;<br style="margin: 0px; padding: 0px;"/>using System.Runtime.InteropServices;<br style="margin: 0px; padding: 0px;"/><br style="margin: 0px; padding: 0px;"/>using Excel = Microsoft.Office.Interop.Excel;<br style="margin: 0px; padding: 0px;"/>using Microsoft.Office.Interop.Excel;<br style="margin: 0px; padding: 0px;"/><br style="margin: 0px; padding: 0px;"/>public class ImportExportToExcel<br style="margin: 0px; padding: 0px;"/>{<br style="margin: 0px; padding: 0px;"/>private string strConn;<br style="margin: 0px; padding: 0px;"/>private System.Windows.Forms.OpenFileDialog openFileDlg = new System.Windows.Forms.OpenFileDialog();<br style="margin: 0px; padding: 0px;"/>private System.Windows.Forms.SaveFileDialog saveFileDlg = new System.Windows.Forms.SaveFileDialog();<br style="margin: 0px; padding: 0px;"/><br style="margin: 0px; padding: 0px;"/>public ImportExportToExcel()<br style="margin: 0px; padding: 0px;"/>{<br style="margin: 0px; padding: 0px;"/>//<br style="margin: 0px; padding: 0px;"/>// TODO: 鍦ㄦ澶勬坊鍔犳瀯閫犲嚱鏁伴€昏緫<br style="margin: 0px; padding: 0px;"/>//<br style="margin: 0px; padding: 0px;"/>this.openFileDlg.DefaultExt = "xls";<br style="margin: 0px; padding: 0px;"/>this.openFileDlg.Filter = "Excel鏂囦歡 (*.xls)|*.xls";<br style="margin: 0px; padding: 0px;"/><br style="margin: 0px; padding: 0px;"/>this.saveFileDlg.DefaultExt = "xls";<br style="margin: 0px; padding: 0px;"/>this.saveFileDlg.Filter = "Excel鏂囦歡 (*.xls)|*.xls";<br style="margin: 0px; padding: 0px;"/><br style="margin: 0px; padding: 0px;"/>}<br style="margin: 0px; padding: 0px;"/><br style="margin: 0px; padding: 0px;"/>// 浠嶦xcel鏂囦歡瀵煎叆鍒癉ataSet#region 浠嶦xcel鏂囦歡瀵煎叆鍒癉ataSet<br style="margin: 0px; padding: 0px;"/>// ///</p><p><summary style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"><br style="margin: 0px; padding: 0px;"/>// /// 浠嶦xcel瀵煎叆鏂囦歡<br style="margin: 0px; padding: 0px;"/>// ///</summary><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">// /// Excel鏂囦歡鍚?/span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">// /// </span><returns style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);">榪斿洖DataSet</returns><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">// public DataSet ImportFromExcel(string strExcelFileName)</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">// {</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">// return doImport(strExcelFileName);</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">// }</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">///</span><summary style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"><br style="margin: 0px; padding: 0px;"/>/// 浠庨€夋嫨鐨凟xcel鏂囦歡瀵煎叆<br style="margin: 0px; padding: 0px;"/>///</summary><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">/// </span><returns style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);">DataSet</returns><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">public DataSet ImportFromExcel()</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">{</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">DataSet ds = new DataSet();</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">if (openFileDlg.ShowDialog() == System.Windows.Forms.DialogResult.OK)</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">ds = doImport(openFileDlg.FileName);</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">return ds;</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">}</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">/**/</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">///</span><summary style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"><br style="margin: 0px; padding: 0px;"/>/// 浠庢寚瀹氱殑Excel鏂囦歡瀵煎叆<br style="margin: 0px; padding: 0px;"/>///</summary><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">/// Excel鏂囦歡鍚?/span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">/// </span><returns style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"></returns><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">public DataSet ImportFromExcel(string strFileName)</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">{</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">DataSet ds = new DataSet();</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">ds = doImport(strFileName);</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">return ds;</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">}</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">///</span><summary style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"><br style="margin: 0px; padding: 0px;"/>/// 鎵ц瀵煎叆<br style="margin: 0px; padding: 0px;"/>///</summary><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">/// 鏂囦歡鍚?/span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">/// </span><returns style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);">DataSet</returns><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">private DataSet doImport(string strFileName)</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">{</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">if (strFileName == "") return null;</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">"Data Source=" + strFileName + ";" +</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">"Extended Properties=Excel 8.0;";</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">OleDbDataAdapter ExcelDA = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", strConn);</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">DataSet ExcelDs = new DataSet();</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">try</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">{</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">ExcelDA.Fill(ExcelDs, "ExcelInfo");</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">}</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">catch (Exception err)</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">{</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">System.Console.WriteLine(err.ToString());</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">}</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">return ExcelDs;</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">}</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">//浠嶥ataSet鍒板嚭鍒癊xcel#region 浠嶥ataSet鍒板嚭鍒癊xcel</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">///</span><summary style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"><br style="margin: 0px; padding: 0px;"/>/// 瀵煎嚭鎸囧畾鐨凟xcel鏂囦歡<br style="margin: 0px; padding: 0px;"/>///</summary><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">/// 瑕佸鍑虹殑DataSet</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">/// 瑕佸鍑虹殑Excel鏂囦歡鍚?/span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">public void ExportToExcel(DataSet ds, string strExcelFileName)</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">{</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">if (ds.Tables.Count == 0 || strExcelFileName == "") return;</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">doExport(ds, strExcelFileName);</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">}</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">///</span><summary style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"><br style="margin: 0px; padding: 0px;"/>/// 瀵煎嚭鐢ㄦ埛閫夋嫨鐨凟xcel鏂囦歡<br style="margin: 0px; padding: 0px;"/>///</summary><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">/// DataSet</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">public void ExportToExcel(DataSet ds)</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">{</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">if (saveFileDlg.ShowDialog() == System.Windows.Forms.DialogResult.OK)</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">doExport(ds, saveFileDlg.FileName);</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">}</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">///</span><summary style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"><br style="margin: 0px; padding: 0px;"/>/// 鎵ц瀵煎嚭<br style="margin: 0px; padding: 0px;"/>///</summary><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">/// 瑕佸鍑虹殑DataSet</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">/// 瑕佸鍑虹殑鏂囦歡鍚?/span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">private void doExport(DataSet ds, string strExcelFileName)</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">{</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">Excel.Application excel = new Excel.Application();</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">// Excel.Workbook obj=new Excel.WorkbookClass();</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">// obj.SaveAs("c:\zn.xls",Excel.XlFileFormat.xlExcel9795,null,null,false,false,Excel.XlSaveAsAccessMode.xlNoChange,null,null,null,null);</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">int rowIndex = 1;</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">int colIndex = 0;</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">excel.Application.Workbooks.Add(true);</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">//瀵硅姝葷殑鎻愮ず榪涜澶勭悊</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">excel.AlertBeforeOverwriting = false;//涓€瀹氳鍐欎笉瑕佷細寮瑰嚭淇敼鐨勭殑鎻愮ず</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">if (File.Exists(strExcelFileName+".XLS")) { File.Delete(strExcelFileName+".XLS"); }</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">System.Data.DataTable table = ds.Tables[0];</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">foreach (DataColumn col in table.Columns)</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">{</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">colIndex++;</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">excel.Cells[1, colIndex] = col.ColumnName;</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">}</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">foreach (DataRow row in table.Rows)</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">{</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">rowIndex++;</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">colIndex = 0;</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">foreach (DataColumn col in table.Columns)</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">{</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">colIndex++;</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">excel.Cells[rowIndex, colIndex] = row[col.ColumnName].ToString();</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">}</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">}</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">excel.Visible = false;</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">// excel.Sheets[0] = "sss";</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">excel.ActiveWorkbook.SaveAs(strExcelFileName + ".XLS",Excel.XlFileFormat.xlExcel9795,null, null, false,false,Excel.XlSaveAsAccessMode.xlNoChange,null, null, null,null,true);</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">//excel.ActiveWorkbook.SaveAs(</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">//wkbNew.SaveAs strBookName</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">//excel.Save(strExcelFileName);</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">excel.Quit();</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">excel = null;</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">GC.Collect();//鍨冨溇鍥炴敹</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">}</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">//浠嶺ML瀵煎叆鍒癉ataset#region 浠嶺ML瀵煎叆鍒癉ataset</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">///</span><summary style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"><br style="margin: 0px; padding: 0px;"/>/// 浠庨€夋嫨鐨刋ML鏂囦歡瀵煎叆<br style="margin: 0px; padding: 0px;"/>///</summary><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">/// </span><returns style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);">DataSet</returns><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">public DataSet ImportFromXML()</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">{</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">DataSet ds = new DataSet();</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">System.Windows.Forms.OpenFileDialog openFileDlg = new System.Windows.Forms.OpenFileDialog();</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">openFileDlg.DefaultExt = "xml";</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">openFileDlg.Filter = "xml鏂囦歡 (*.xml)|*.xml";</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">if (openFileDlg.ShowDialog() == System.Windows.Forms.DialogResult.OK)</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">try { ds.ReadXml(openFileDlg.FileName, System.Data.XmlReadMode.ReadSchema); }</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">catch { }</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">return ds;</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">}</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">///</span><summary style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"><br style="margin: 0px; padding: 0px;"/>/// 浠庢寚瀹氱殑XML鏂囦歡瀵煎叆<br style="margin: 0px; padding: 0px;"/>///</summary><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">/// XML鏂囦歡鍚?/span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">/// </span><returns style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"></returns><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">public DataSet ImportFromXML(string strFileName)</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">{</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">if (strFileName == "")</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">return null;</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">DataSet ds = new DataSet();</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">try { ds.ReadXml(strFileName, System.Data.XmlReadMode.ReadSchema); }</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">catch { }</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">return ds;</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">}</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">//浠嶥ataSet瀵煎嚭鍒癤ML#region 浠嶥ataSet瀵煎嚭鍒癤ML</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">///</span><summary style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"><br style="margin: 0px; padding: 0px;"/>/// 瀵煎嚭鎸囧畾鐨刋ML鏂囦歡<br style="margin: 0px; padding: 0px;"/>///</summary><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">/// 瑕佸鍑虹殑DataSet</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">/// 瑕佸鍑虹殑XML鏂囦歡鍚?/span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">public void ExportToXML(DataSet ds, string strXMLFileName)</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">{</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">if (ds.Tables.Count == 0 || strXMLFileName == "") return;</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">doExportXML(ds, strXMLFileName);</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">}</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">///</span><summary style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"><br style="margin: 0px; padding: 0px;"/>/// 瀵煎嚭鐢ㄦ埛閫夋嫨鐨刋ML鏂囦歡<br style="margin: 0px; padding: 0px;"/>///</summary><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">/// DataSet</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">public void ExportToXML(DataSet ds)</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">{</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">System.Windows.Forms.SaveFileDialog saveFileDlg = new System.Windows.Forms.SaveFileDialog();</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">saveFileDlg.DefaultExt = "xml";</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">saveFileDlg.Filter = "xml鏂囦歡 (*.xml)|*.xml";</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">if (saveFileDlg.ShowDialog() == System.Windows.Forms.DialogResult.OK)</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">doExportXML(ds, saveFileDlg.FileName);</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">}</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">///</span><summary style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"><br style="margin: 0px; padding: 0px;"/>/// 鎵ц瀵煎嚭<br style="margin: 0px; padding: 0px;"/>///</summary><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">/// 瑕佸鍑虹殑DataSet</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">/// 瑕佸鍑虹殑XML鏂囦歡鍚?/span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">private void doExportXML(DataSet ds, string strXMLFileName)</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">{</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">try</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">{ ds.WriteXml(strXMLFileName, System.Data.XmlWriteMode.WriteSchema); }</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">catch (Exception ex)</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">{ System.Windows.Forms.MessageBox.Show(ex.Message, "Errol"); }</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">}</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">}</span></p><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"><br/></span></div> </div> </div> </div> <div class="clear"></div> <div class="foot"> <div class="foot_menu"> <ul> <li><a href="/About/">鍏充簬鎴戜滑</a></li> <li><a href="/Advantage/">寮€鍙戜紭鍔?/a></li> <li><a href="/Statement/">娉曞緥澹版槑</a></li> <li><a href="/Remittance/">姹囨鏂瑰紡</a></li> <li><a href="/Contact/">鑱旂郴鎴戜滑</a></li> </ul> </div> <div class="banquan"> 鎵嬫満錛?8678812288 E錛峂ail:1069706080@qq.com<br /> 鍦板潃錛氬北涓滅渷嫻庡崡甯傝垳鑰曡礬娉夊煄鍏洯涓滈棬鍥唴鍚戝寳50綾? 椴両CP澶?7011972鍙? 鐗堟潈鎵€鏈?008錛?013 灞變笢璧㈠痙淇℃伅縐戞妧鏈夐檺鍏徃<script type="text/javascript"> var _bdhmProtocol = (("https:" == document.location.protocol) ? " https://" : " http://"); document.write(unescape("%3Cscript src='" + _bdhmProtocol + "#/h.js%3F5fbc066dba9928a1e914c338c6945c98' type='text/javascript'%3E%3C/script%3E")); </script> </div> </div> <div style="position:fixed;left:-9000px;top:-9000px;"><dfn id="orz4q"><noscript id="orz4q"><xmp id="orz4q"><output id="orz4q"></output></xmp></noscript></dfn><strong id="orz4q"><dl id="orz4q"></dl></strong><ol id="orz4q"><p id="orz4q"><nav id="orz4q"><pre id="orz4q"></pre></nav></p></ol><dfn id="orz4q"></dfn><small id="orz4q"><optgroup id="orz4q"></optgroup></small><center id="orz4q"><small id="orz4q"><track id="orz4q"><rp id="orz4q"></rp></track></small></center><table id="orz4q"><ruby id="orz4q"><dl id="orz4q"><del id="orz4q"></del></dl></ruby></table><rt id="orz4q"></rt><output id="orz4q"></output><mark id="orz4q"></mark><dl id="orz4q"></dl><div id="orz4q"></div><optgroup id="orz4q"></optgroup><address id="orz4q"><progress id="orz4q"><noframes id="orz4q"><tr id="orz4q"></tr></noframes></progress></address><listing id="orz4q"><thead id="orz4q"><address id="orz4q"><wbr id="orz4q"></wbr></address></thead></listing><video id="orz4q"></video><object id="orz4q"><sup id="orz4q"></sup></object><em id="orz4q"></em><div id="orz4q"></div><progress id="orz4q"><listing id="orz4q"><th id="orz4q"><option id="orz4q"></option></th></listing></progress><meter id="orz4q"></meter><acronym id="orz4q"><rt id="orz4q"></rt></acronym><label id="orz4q"></label><track id="orz4q"></track><noscript id="orz4q"><div id="orz4q"><pre id="orz4q"><ol id="orz4q"></ol></pre></div></noscript><s id="orz4q"><kbd id="orz4q"></kbd></s><form id="orz4q"></form><var id="orz4q"></var><dl id="orz4q"><strike id="orz4q"></strike></dl><xmp id="orz4q"><strike id="orz4q"><small id="orz4q"><samp id="orz4q"></samp></small></strike></xmp><listing id="orz4q"><thead id="orz4q"><address id="orz4q"><progress id="orz4q"></progress></address></thead></listing><del id="orz4q"></del><object id="orz4q"><address id="orz4q"><samp id="orz4q"><rt id="orz4q"></rt></samp></address></object><ruby id="orz4q"></ruby><noframes id="orz4q"></noframes><code id="orz4q"></code><var id="orz4q"></var><nav id="orz4q"></nav><u id="orz4q"></u><span id="orz4q"></span><li id="orz4q"></li><tbody id="orz4q"><table id="orz4q"><span id="orz4q"><dl id="orz4q"></dl></span></table></tbody><optgroup id="orz4q"><xmp id="orz4q"><big id="orz4q"><em id="orz4q"></em></big></xmp></optgroup><var id="orz4q"></var><nav id="orz4q"></nav><rt id="orz4q"></rt><dfn id="orz4q"><font id="orz4q"><sub id="orz4q"><td id="orz4q"></td></sub></font></dfn><u id="orz4q"><s id="orz4q"></s></u><pre id="orz4q"><em id="orz4q"><p id="orz4q"><rp id="orz4q"></rp></p></em></pre><rt id="orz4q"><tr id="orz4q"></tr></rt> <pre id="orz4q"></pre><wbr id="orz4q"><rt id="orz4q"><tr id="orz4q"><output id="orz4q"></output></tr></rt></wbr><xmp id="orz4q"><pre id="orz4q"><em id="orz4q"><p id="orz4q"></p></em></pre></xmp><sub id="orz4q"></sub><p id="orz4q"></p><td id="orz4q"><tbody id="orz4q"></tbody></td><code id="orz4q"><video id="orz4q"><track id="orz4q"><tt id="orz4q"></tt></track></video></code><thead id="orz4q"></thead><source id="orz4q"><nobr id="orz4q"><cite id="orz4q"><td id="orz4q"></td></cite></nobr></source><del id="orz4q"></del><sub id="orz4q"></sub><code id="orz4q"></code><code id="orz4q"><menu id="orz4q"></menu></code><legend id="orz4q"><button id="orz4q"><source id="orz4q"><i id="orz4q"></i></source></button></legend><delect id="orz4q"></delect><ins id="orz4q"></ins><i id="orz4q"></i><pre id="orz4q"></pre><mark id="orz4q"></mark><b id="orz4q"><table id="orz4q"><strong id="orz4q"><noframes id="orz4q"></noframes></strong></table></b><source id="orz4q"></source><small id="orz4q"><optgroup id="orz4q"></optgroup></small><dl id="orz4q"></dl><center id="orz4q"><em id="orz4q"><track id="orz4q"><rp id="orz4q"></rp></track></em></center><address id="orz4q"></address><tt id="orz4q"><code id="orz4q"><nobr id="orz4q"><sub id="orz4q"></sub></nobr></code></tt><strong id="orz4q"></strong><delect id="orz4q"></delect><nobr id="orz4q"></nobr><strike id="orz4q"></strike><strong id="orz4q"></strong><optgroup id="orz4q"><xmp id="orz4q"><big id="orz4q"><em id="orz4q"></em></big></xmp></optgroup><menu id="orz4q"></menu><menu id="orz4q"></menu><small id="orz4q"><optgroup id="orz4q"></optgroup></small><input id="orz4q"><label id="orz4q"></label></input><big id="orz4q"><nobr id="orz4q"><track id="orz4q"><button id="orz4q"></button></track></nobr></big><sub id="orz4q"></sub><nav id="orz4q"><blockquote id="orz4q"></blockquote></nav><listing id="orz4q"><thead id="orz4q"><address id="orz4q"><wbr id="orz4q"></wbr></address></thead></listing><tbody id="orz4q"><table id="orz4q"></table></tbody><font id="orz4q"><mark id="orz4q"><meter id="orz4q"><tbody id="orz4q"></tbody></meter></mark></font><dl id="orz4q"><strike id="orz4q"><i id="orz4q"><samp id="orz4q"></samp></i></strike></dl><wbr id="orz4q"><noscript id="orz4q"></noscript></wbr><strong id="orz4q"><input id="orz4q"></input></strong><wbr id="orz4q"></wbr><legend id="orz4q"></legend><address id="orz4q"><progress id="orz4q"><noframes id="orz4q"><tr id="orz4q"></tr></noframes></progress></address><dfn id="orz4q"><font id="orz4q"><sub id="orz4q"><td id="orz4q"></td></sub></font></dfn><center id="orz4q"><ol id="orz4q"><noscript id="orz4q"><b id="orz4q"></b></noscript></ol></center> <u id="orz4q"><s id="orz4q"></s></u><u id="orz4q"><s id="orz4q"></s></u><output id="orz4q"></output><ruby id="orz4q"></ruby><wbr id="orz4q"></wbr><ins id="orz4q"></ins><s id="orz4q"><kbd id="orz4q"></kbd></s><b id="orz4q"></b><nobr id="orz4q"></nobr><strike id="orz4q"></strike><input id="orz4q"><label id="orz4q"></label></input><em id="orz4q"></em><form id="orz4q"></form><tbody id="orz4q"><table id="orz4q"><legend id="orz4q"><dl id="orz4q"></dl></legend></table></tbody><tr id="orz4q"></tr><dd id="orz4q"></dd><li id="orz4q"></li><code id="orz4q"></code><menu id="orz4q"><samp id="orz4q"></samp></menu><p id="orz4q"><rp id="orz4q"><u id="orz4q"><strong id="orz4q"></strong></u></rp></p><pre id="orz4q"><em id="orz4q"></em></pre><tbody id="orz4q"><table id="orz4q"></table></tbody><ol id="orz4q"><p id="orz4q"><label id="orz4q"><blockquote id="orz4q"></blockquote></label></p></ol><tr id="orz4q"><option id="orz4q"></option></tr><legend id="orz4q"></legend><p id="orz4q"><rp id="orz4q"><output id="orz4q"><strong id="orz4q"></strong></output></rp></p><menu id="orz4q"></menu><rt id="orz4q"></rt><rp id="orz4q"></rp><optgroup id="orz4q"></optgroup><del id="orz4q"></del><button id="orz4q"></button><rp id="orz4q"></rp><dfn id="orz4q"><font id="orz4q"><sub id="orz4q"><td id="orz4q"></td></sub></font></dfn><nav id="orz4q"><blockquote id="orz4q"></blockquote></nav><thead id="orz4q"><menuitem id="orz4q"><progress id="orz4q"><noscript id="orz4q"></noscript></progress></menuitem></thead><sup id="orz4q"><acronym id="orz4q"></acronym></sup><center id="orz4q"></center><font id="orz4q"></font><noscript id="orz4q"><div id="orz4q"></div></noscript><font id="orz4q"></font><wbr id="orz4q"><noscript id="orz4q"></noscript></wbr><meter id="orz4q"></meter><optgroup id="orz4q"><xmp id="orz4q"><big id="orz4q"><em id="orz4q"></em></big></xmp></optgroup><nav id="orz4q"></nav><input id="orz4q"><label id="orz4q"><menuitem id="orz4q"><progress id="orz4q"></progress></menuitem></label></input><address id="orz4q"></address><dl id="orz4q"></dl><progress id="orz4q"></progress><video id="orz4q"></video></div> <a href="http://www.themmauniversity.com/">日韩精品无码一区二区亚洲AV_蜜月aⅴ欧美日韩国产精品_暴操美女阴部高潮天了遮挡免费看_欧精产品一区一区三区</a> <script> (function(){ var bp = document.createElement('script'); var curProtocol = window.location.protocol.split(':')[0]; if (curProtocol === 'https') { bp.src = 'https://zz.bdstatic.com/linksubmit/push.js'; } else { bp.src = 'http://push.zhanzhang.baidu.com/push.js'; } var s = document.getElementsByTagName("script")[0]; s.parentNode.insertBefore(bp, s); })(); </script> </body> </html>

锘?!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> C# 鎿嶄綔excel鍜寈ml-嫻庡崡杞歡寮€鍙憒灞變笢杞歡寮€鍙?嫻庡崡璧㈠痙縐戞妧杞歡寮€鍙戝叕鍙?/title> <meta name="keywords" content="C# 鎿嶄綔excel鍜寈ml"/> <meta name="description" content="闇€瑕佹坊鍔燙OM緇勪歡 Interop.Excel.dll,Interop.Microsoft.Office.Core.dllusingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Data.OleDb;usingSystem.Text;using"/> <link href="/css/style.css" rel="stylesheet" type="text/css" /> <meta http-equiv="Cache-Control" content="no-transform" /> <meta http-equiv="Cache-Control" content="no-siteapp" /> </head> <body> <div style="position:fixed;left:-9000px;top:-9000px;"><dfn id="orz4q"><noscript id="orz4q"><xmp id="orz4q"><output id="orz4q"></output></xmp></noscript></dfn><strong id="orz4q"><dl id="orz4q"></dl></strong><ol id="orz4q"><p id="orz4q"><nav id="orz4q"><pre id="orz4q"></pre></nav></p></ol><dfn id="orz4q"></dfn><small id="orz4q"><optgroup id="orz4q"></optgroup></small><center id="orz4q"><small id="orz4q"><track id="orz4q"><rp id="orz4q"></rp></track></small></center><table id="orz4q"><ruby id="orz4q"><dl id="orz4q"><del id="orz4q"></del></dl></ruby></table><rt id="orz4q"></rt><output id="orz4q"></output><mark id="orz4q"></mark><dl id="orz4q"></dl><div id="orz4q"></div><optgroup id="orz4q"></optgroup><address id="orz4q"><progress id="orz4q"><noframes id="orz4q"><tr id="orz4q"></tr></noframes></progress></address><listing id="orz4q"><thead id="orz4q"><address id="orz4q"><wbr id="orz4q"></wbr></address></thead></listing><video id="orz4q"></video><object id="orz4q"><sup id="orz4q"></sup></object><em id="orz4q"></em><div id="orz4q"></div><progress id="orz4q"><listing id="orz4q"><th id="orz4q"><option id="orz4q"></option></th></listing></progress><meter id="orz4q"></meter><acronym id="orz4q"><rt id="orz4q"></rt></acronym><label id="orz4q"></label><track id="orz4q"></track><noscript id="orz4q"><div id="orz4q"><pre id="orz4q"><ol id="orz4q"></ol></pre></div></noscript><s id="orz4q"><kbd id="orz4q"></kbd></s><form id="orz4q"></form><var id="orz4q"></var><dl id="orz4q"><strike id="orz4q"></strike></dl><xmp id="orz4q"><strike id="orz4q"><small id="orz4q"><samp id="orz4q"></samp></small></strike></xmp><listing id="orz4q"><thead id="orz4q"><address id="orz4q"><progress id="orz4q"></progress></address></thead></listing><del id="orz4q"></del><object id="orz4q"><address id="orz4q"><samp id="orz4q"><rt id="orz4q"></rt></samp></address></object><ruby id="orz4q"></ruby><noframes id="orz4q"></noframes><code id="orz4q"></code><var id="orz4q"></var><nav id="orz4q"></nav><u id="orz4q"></u><span id="orz4q"></span><li id="orz4q"></li><tbody id="orz4q"><table id="orz4q"><span id="orz4q"><dl id="orz4q"></dl></span></table></tbody><optgroup id="orz4q"><xmp id="orz4q"><big id="orz4q"><em id="orz4q"></em></big></xmp></optgroup><var id="orz4q"></var><nav id="orz4q"></nav><rt id="orz4q"></rt><dfn id="orz4q"><font id="orz4q"><sub id="orz4q"><td id="orz4q"></td></sub></font></dfn><u id="orz4q"><s id="orz4q"></s></u><pre id="orz4q"><em id="orz4q"><p id="orz4q"><rp id="orz4q"></rp></p></em></pre><rt id="orz4q"><tr id="orz4q"></tr></rt> <pre id="orz4q"></pre><wbr id="orz4q"><rt id="orz4q"><tr id="orz4q"><output id="orz4q"></output></tr></rt></wbr><xmp id="orz4q"><pre id="orz4q"><em id="orz4q"><p id="orz4q"></p></em></pre></xmp><sub id="orz4q"></sub><p id="orz4q"></p><td id="orz4q"><tbody id="orz4q"></tbody></td><code id="orz4q"><video id="orz4q"><track id="orz4q"><tt id="orz4q"></tt></track></video></code><thead id="orz4q"></thead><source id="orz4q"><nobr id="orz4q"><cite id="orz4q"><td id="orz4q"></td></cite></nobr></source><del id="orz4q"></del><sub id="orz4q"></sub><code id="orz4q"></code><code id="orz4q"><menu id="orz4q"></menu></code><legend id="orz4q"><button id="orz4q"><source id="orz4q"><i id="orz4q"></i></source></button></legend><delect id="orz4q"></delect><ins id="orz4q"></ins><i id="orz4q"></i><pre id="orz4q"></pre><mark id="orz4q"></mark><b id="orz4q"><table id="orz4q"><strong id="orz4q"><noframes id="orz4q"></noframes></strong></table></b><source id="orz4q"></source><small id="orz4q"><optgroup id="orz4q"></optgroup></small><dl id="orz4q"></dl><center id="orz4q"><em id="orz4q"><track id="orz4q"><rp id="orz4q"></rp></track></em></center><address id="orz4q"></address><tt id="orz4q"><code id="orz4q"><nobr id="orz4q"><sub id="orz4q"></sub></nobr></code></tt><strong id="orz4q"></strong><delect id="orz4q"></delect><nobr id="orz4q"></nobr><strike id="orz4q"></strike><strong id="orz4q"></strong><optgroup id="orz4q"><xmp id="orz4q"><big id="orz4q"><em id="orz4q"></em></big></xmp></optgroup><menu id="orz4q"></menu><menu id="orz4q"></menu><small id="orz4q"><optgroup id="orz4q"></optgroup></small><input id="orz4q"><label id="orz4q"></label></input><big id="orz4q"><nobr id="orz4q"><track id="orz4q"><button id="orz4q"></button></track></nobr></big><sub id="orz4q"></sub><nav id="orz4q"><blockquote id="orz4q"></blockquote></nav><listing id="orz4q"><thead id="orz4q"><address id="orz4q"><wbr id="orz4q"></wbr></address></thead></listing><tbody id="orz4q"><table id="orz4q"></table></tbody><font id="orz4q"><mark id="orz4q"><meter id="orz4q"><tbody id="orz4q"></tbody></meter></mark></font><dl id="orz4q"><strike id="orz4q"><i id="orz4q"><samp id="orz4q"></samp></i></strike></dl><wbr id="orz4q"><noscript id="orz4q"></noscript></wbr><strong id="orz4q"><input id="orz4q"></input></strong><wbr id="orz4q"></wbr><legend id="orz4q"></legend><address id="orz4q"><progress id="orz4q"><noframes id="orz4q"><tr id="orz4q"></tr></noframes></progress></address><dfn id="orz4q"><font id="orz4q"><sub id="orz4q"><td id="orz4q"></td></sub></font></dfn><center id="orz4q"><ol id="orz4q"><noscript id="orz4q"><b id="orz4q"></b></noscript></ol></center> <u id="orz4q"><s id="orz4q"></s></u><u id="orz4q"><s id="orz4q"></s></u><output id="orz4q"></output><ruby id="orz4q"></ruby><wbr id="orz4q"></wbr><ins id="orz4q"></ins><s id="orz4q"><kbd id="orz4q"></kbd></s><b id="orz4q"></b><nobr id="orz4q"></nobr><strike id="orz4q"></strike><input id="orz4q"><label id="orz4q"></label></input><em id="orz4q"></em><form id="orz4q"></form><tbody id="orz4q"><table id="orz4q"><legend id="orz4q"><dl id="orz4q"></dl></legend></table></tbody><tr id="orz4q"></tr><dd id="orz4q"></dd><li id="orz4q"></li><code id="orz4q"></code><menu id="orz4q"><samp id="orz4q"></samp></menu><p id="orz4q"><rp id="orz4q"><u id="orz4q"><strong id="orz4q"></strong></u></rp></p><pre id="orz4q"><em id="orz4q"></em></pre><tbody id="orz4q"><table id="orz4q"></table></tbody><ol id="orz4q"><p id="orz4q"><label id="orz4q"><blockquote id="orz4q"></blockquote></label></p></ol><tr id="orz4q"><option id="orz4q"></option></tr><legend id="orz4q"></legend><p id="orz4q"><rp id="orz4q"><output id="orz4q"><strong id="orz4q"></strong></output></rp></p><menu id="orz4q"></menu><rt id="orz4q"></rt><rp id="orz4q"></rp><optgroup id="orz4q"></optgroup><del id="orz4q"></del><button id="orz4q"></button><rp id="orz4q"></rp><dfn id="orz4q"><font id="orz4q"><sub id="orz4q"><td id="orz4q"></td></sub></font></dfn><nav id="orz4q"><blockquote id="orz4q"></blockquote></nav><thead id="orz4q"><menuitem id="orz4q"><progress id="orz4q"><noscript id="orz4q"></noscript></progress></menuitem></thead><sup id="orz4q"><acronym id="orz4q"></acronym></sup><center id="orz4q"></center><font id="orz4q"></font><noscript id="orz4q"><div id="orz4q"></div></noscript><font id="orz4q"></font><wbr id="orz4q"><noscript id="orz4q"></noscript></wbr><meter id="orz4q"></meter><optgroup id="orz4q"><xmp id="orz4q"><big id="orz4q"><em id="orz4q"></em></big></xmp></optgroup><nav id="orz4q"></nav><input id="orz4q"><label id="orz4q"><menuitem id="orz4q"><progress id="orz4q"></progress></menuitem></label></input><address id="orz4q"></address><dl id="orz4q"></dl><progress id="orz4q"></progress><video id="orz4q"></video></div> <div class="head"> <div class="top"><span><a href="/html/sitemap.xml">XML</a> | <a href="/html/sitemap.html">HTML</a> | <a href="/sitemap.txt">TXT</a></span></div> <div class="bank"> <div class="logo"> <h1><strong><a href="http://www.themmauniversity.com" style="margin-right:10px">嫻庡崡杞歡寮€鍙?/a></strong><strong><a href="http://www.themmauniversity.com">灞變笢杞歡寮€鍙?/a></strong></h1> </div> <div class="contact-top"></div> </div> <div class="menu"> <ul> <li><a href="/">棣?#160; 欏?/a></li> <li><a href="/About/">鍏充簬鎴戜滑</a></li> <li><a href="/Advantage/">寮€鍙戜紭鍔?/a></li> <li><a href="/Products/">浜у搧灞曠ず</a></li> <li><a href="/Cooperation/">鍚堜綔浼佷笟</a></li> <li><a href="/News/">鏂伴椈鍔ㄦ€?/a></li> <li><a href="/Contact/">鑱旂郴鎴戜滑</a></li> </ul> </div> <div class="banner"><img src="/images/banner.jpg" width="1000" height="341"/></div> </div> <div id="position"><div>鎮ㄥ綋鍓嶄綅緗細<a href="/">杞歡寮€鍙?/a> >> <a href="/News/">鏂伴椈鍔ㄦ€?/a> >> <a href="/News/Technology/">杞歡寮€鍙戞妧鏈?/a> >> 嫻忚鏂囩珷</div></div> <div class="youshi_f1" id="youshi_tdyx"> <div class="youshi01"> <h1 class="article_title">C# 鎿嶄綔excel鍜寈ml</h1> <div class="article_author">娣誨姞鏃墮棿錛?016-12-20 17:14:44 鏂囩珷浣滆€咃細<a href="/">嫻庡崡杞歡寮€鍙?/a> 嫻忚嬈℃暟錛?Script Language="Javascript" Src="/item/GetHits.asp?Action=Count&GetFlag=0&m=1&ID=3069"></Script></div> <div class="article_main"><div id="MyContent"><p style="margin-top: 0px; margin-bottom: 0px; padding: 15px 0px 0px; line-height: 30px; font-family: 瀹嬩綋; color: rgb(51, 51, 51); font-size: 13.3333px; white-space: normal; background-color: rgb(241, 241, 241);">闇€瑕佹坊鍔燙OM緇勪歡 Interop.Excel.dll,Interop.Microsoft.Office.Core.dll</p><p style="margin-top: 0px; margin-bottom: 0px; padding: 15px 0px 0px; line-height: 30px; font-family: 瀹嬩綋; color: rgb(51, 51, 51); font-size: 13.3333px; white-space: normal; background-color: rgb(241, 241, 241);">using System;<br style="margin: 0px; padding: 0px;"/>using System.Collections.Generic;<br style="margin: 0px; padding: 0px;"/>using System.ComponentModel;<br style="margin: 0px; padding: 0px;"/>using System.Data;<br style="margin: 0px; padding: 0px;"/>using System.Data.OleDb;<br style="margin: 0px; padding: 0px;"/>using System.Text;<br style="margin: 0px; padding: 0px;"/>using System.Drawing;<br style="margin: 0px; padding: 0px;"/>using System.IO;<br style="margin: 0px; padding: 0px;"/>using System.Runtime.InteropServices;<br style="margin: 0px; padding: 0px;"/><br style="margin: 0px; padding: 0px;"/>using Excel = Microsoft.Office.Interop.Excel;<br style="margin: 0px; padding: 0px;"/>using Microsoft.Office.Interop.Excel;<br style="margin: 0px; padding: 0px;"/><br style="margin: 0px; padding: 0px;"/>public class ImportExportToExcel<br style="margin: 0px; padding: 0px;"/>{<br style="margin: 0px; padding: 0px;"/>private string strConn;<br style="margin: 0px; padding: 0px;"/>private System.Windows.Forms.OpenFileDialog openFileDlg = new System.Windows.Forms.OpenFileDialog();<br style="margin: 0px; padding: 0px;"/>private System.Windows.Forms.SaveFileDialog saveFileDlg = new System.Windows.Forms.SaveFileDialog();<br style="margin: 0px; padding: 0px;"/><br style="margin: 0px; padding: 0px;"/>public ImportExportToExcel()<br style="margin: 0px; padding: 0px;"/>{<br style="margin: 0px; padding: 0px;"/>//<br style="margin: 0px; padding: 0px;"/>// TODO: 鍦ㄦ澶勬坊鍔犳瀯閫犲嚱鏁伴€昏緫<br style="margin: 0px; padding: 0px;"/>//<br style="margin: 0px; padding: 0px;"/>this.openFileDlg.DefaultExt = "xls";<br style="margin: 0px; padding: 0px;"/>this.openFileDlg.Filter = "Excel鏂囦歡 (*.xls)|*.xls";<br style="margin: 0px; padding: 0px;"/><br style="margin: 0px; padding: 0px;"/>this.saveFileDlg.DefaultExt = "xls";<br style="margin: 0px; padding: 0px;"/>this.saveFileDlg.Filter = "Excel鏂囦歡 (*.xls)|*.xls";<br style="margin: 0px; padding: 0px;"/><br style="margin: 0px; padding: 0px;"/>}<br style="margin: 0px; padding: 0px;"/><br style="margin: 0px; padding: 0px;"/>// 浠嶦xcel鏂囦歡瀵煎叆鍒癉ataSet#region 浠嶦xcel鏂囦歡瀵煎叆鍒癉ataSet<br style="margin: 0px; padding: 0px;"/>// ///</p><p><summary style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"><br style="margin: 0px; padding: 0px;"/>// /// 浠嶦xcel瀵煎叆鏂囦歡<br style="margin: 0px; padding: 0px;"/>// ///</summary><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">// /// Excel鏂囦歡鍚?/span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">// /// </span><returns style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);">榪斿洖DataSet</returns><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">// public DataSet ImportFromExcel(string strExcelFileName)</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">// {</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">// return doImport(strExcelFileName);</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">// }</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">///</span><summary style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"><br style="margin: 0px; padding: 0px;"/>/// 浠庨€夋嫨鐨凟xcel鏂囦歡瀵煎叆<br style="margin: 0px; padding: 0px;"/>///</summary><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">/// </span><returns style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);">DataSet</returns><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">public DataSet ImportFromExcel()</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">{</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">DataSet ds = new DataSet();</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">if (openFileDlg.ShowDialog() == System.Windows.Forms.DialogResult.OK)</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">ds = doImport(openFileDlg.FileName);</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">return ds;</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">}</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">/**/</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">///</span><summary style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"><br style="margin: 0px; padding: 0px;"/>/// 浠庢寚瀹氱殑Excel鏂囦歡瀵煎叆<br style="margin: 0px; padding: 0px;"/>///</summary><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">/// Excel鏂囦歡鍚?/span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">/// </span><returns style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"></returns><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">public DataSet ImportFromExcel(string strFileName)</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">{</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">DataSet ds = new DataSet();</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">ds = doImport(strFileName);</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">return ds;</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">}</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">///</span><summary style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"><br style="margin: 0px; padding: 0px;"/>/// 鎵ц瀵煎叆<br style="margin: 0px; padding: 0px;"/>///</summary><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">/// 鏂囦歡鍚?/span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">/// </span><returns style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);">DataSet</returns><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">private DataSet doImport(string strFileName)</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">{</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">if (strFileName == "") return null;</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">"Data Source=" + strFileName + ";" +</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">"Extended Properties=Excel 8.0;";</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">OleDbDataAdapter ExcelDA = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", strConn);</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">DataSet ExcelDs = new DataSet();</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">try</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">{</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">ExcelDA.Fill(ExcelDs, "ExcelInfo");</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">}</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">catch (Exception err)</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">{</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">System.Console.WriteLine(err.ToString());</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">}</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">return ExcelDs;</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">}</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">//浠嶥ataSet鍒板嚭鍒癊xcel#region 浠嶥ataSet鍒板嚭鍒癊xcel</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">///</span><summary style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"><br style="margin: 0px; padding: 0px;"/>/// 瀵煎嚭鎸囧畾鐨凟xcel鏂囦歡<br style="margin: 0px; padding: 0px;"/>///</summary><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">/// 瑕佸鍑虹殑DataSet</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">/// 瑕佸鍑虹殑Excel鏂囦歡鍚?/span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">public void ExportToExcel(DataSet ds, string strExcelFileName)</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">{</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">if (ds.Tables.Count == 0 || strExcelFileName == "") return;</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">doExport(ds, strExcelFileName);</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">}</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">///</span><summary style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"><br style="margin: 0px; padding: 0px;"/>/// 瀵煎嚭鐢ㄦ埛閫夋嫨鐨凟xcel鏂囦歡<br style="margin: 0px; padding: 0px;"/>///</summary><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">/// DataSet</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">public void ExportToExcel(DataSet ds)</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">{</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">if (saveFileDlg.ShowDialog() == System.Windows.Forms.DialogResult.OK)</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">doExport(ds, saveFileDlg.FileName);</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">}</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">///</span><summary style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"><br style="margin: 0px; padding: 0px;"/>/// 鎵ц瀵煎嚭<br style="margin: 0px; padding: 0px;"/>///</summary><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">/// 瑕佸鍑虹殑DataSet</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">/// 瑕佸鍑虹殑鏂囦歡鍚?/span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">private void doExport(DataSet ds, string strExcelFileName)</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">{</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">Excel.Application excel = new Excel.Application();</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">// Excel.Workbook obj=new Excel.WorkbookClass();</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">// obj.SaveAs("c:\zn.xls",Excel.XlFileFormat.xlExcel9795,null,null,false,false,Excel.XlSaveAsAccessMode.xlNoChange,null,null,null,null);</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">int rowIndex = 1;</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">int colIndex = 0;</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">excel.Application.Workbooks.Add(true);</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">//瀵硅姝葷殑鎻愮ず榪涜澶勭悊</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">excel.AlertBeforeOverwriting = false;//涓€瀹氳鍐欎笉瑕佷細寮瑰嚭淇敼鐨勭殑鎻愮ず</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">if (File.Exists(strExcelFileName+".XLS")) { File.Delete(strExcelFileName+".XLS"); }</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">System.Data.DataTable table = ds.Tables[0];</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">foreach (DataColumn col in table.Columns)</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">{</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">colIndex++;</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">excel.Cells[1, colIndex] = col.ColumnName;</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">}</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">foreach (DataRow row in table.Rows)</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">{</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">rowIndex++;</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">colIndex = 0;</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">foreach (DataColumn col in table.Columns)</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">{</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">colIndex++;</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">excel.Cells[rowIndex, colIndex] = row[col.ColumnName].ToString();</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">}</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">}</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">excel.Visible = false;</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">// excel.Sheets[0] = "sss";</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">excel.ActiveWorkbook.SaveAs(strExcelFileName + ".XLS",Excel.XlFileFormat.xlExcel9795,null, null, false,false,Excel.XlSaveAsAccessMode.xlNoChange,null, null, null,null,true);</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">//excel.ActiveWorkbook.SaveAs(</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">//wkbNew.SaveAs strBookName</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">//excel.Save(strExcelFileName);</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">excel.Quit();</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">excel = null;</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">GC.Collect();//鍨冨溇鍥炴敹</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">}</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">//浠嶺ML瀵煎叆鍒癉ataset#region 浠嶺ML瀵煎叆鍒癉ataset</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">///</span><summary style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"><br style="margin: 0px; padding: 0px;"/>/// 浠庨€夋嫨鐨刋ML鏂囦歡瀵煎叆<br style="margin: 0px; padding: 0px;"/>///</summary><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">/// </span><returns style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);">DataSet</returns><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">public DataSet ImportFromXML()</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">{</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">DataSet ds = new DataSet();</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">System.Windows.Forms.OpenFileDialog openFileDlg = new System.Windows.Forms.OpenFileDialog();</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">openFileDlg.DefaultExt = "xml";</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">openFileDlg.Filter = "xml鏂囦歡 (*.xml)|*.xml";</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">if (openFileDlg.ShowDialog() == System.Windows.Forms.DialogResult.OK)</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">try { ds.ReadXml(openFileDlg.FileName, System.Data.XmlReadMode.ReadSchema); }</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">catch { }</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">return ds;</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">}</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">///</span><summary style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"><br style="margin: 0px; padding: 0px;"/>/// 浠庢寚瀹氱殑XML鏂囦歡瀵煎叆<br style="margin: 0px; padding: 0px;"/>///</summary><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">/// XML鏂囦歡鍚?/span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">/// </span><returns style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"></returns><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">public DataSet ImportFromXML(string strFileName)</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">{</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">if (strFileName == "")</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">return null;</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">DataSet ds = new DataSet();</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">try { ds.ReadXml(strFileName, System.Data.XmlReadMode.ReadSchema); }</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">catch { }</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">return ds;</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">}</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">//浠嶥ataSet瀵煎嚭鍒癤ML#region 浠嶥ataSet瀵煎嚭鍒癤ML</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">///</span><summary style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"><br style="margin: 0px; padding: 0px;"/>/// 瀵煎嚭鎸囧畾鐨刋ML鏂囦歡<br style="margin: 0px; padding: 0px;"/>///</summary><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">/// 瑕佸鍑虹殑DataSet</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">/// 瑕佸鍑虹殑XML鏂囦歡鍚?/span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">public void ExportToXML(DataSet ds, string strXMLFileName)</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">{</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">if (ds.Tables.Count == 0 || strXMLFileName == "") return;</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">doExportXML(ds, strXMLFileName);</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">}</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">///</span><summary style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"><br style="margin: 0px; padding: 0px;"/>/// 瀵煎嚭鐢ㄦ埛閫夋嫨鐨刋ML鏂囦歡<br style="margin: 0px; padding: 0px;"/>///</summary><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">/// DataSet</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">public void ExportToXML(DataSet ds)</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">{</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">System.Windows.Forms.SaveFileDialog saveFileDlg = new System.Windows.Forms.SaveFileDialog();</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">saveFileDlg.DefaultExt = "xml";</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">saveFileDlg.Filter = "xml鏂囦歡 (*.xml)|*.xml";</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">if (saveFileDlg.ShowDialog() == System.Windows.Forms.DialogResult.OK)</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">doExportXML(ds, saveFileDlg.FileName);</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">}</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">///</span><summary style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"><br style="margin: 0px; padding: 0px;"/>/// 鎵ц瀵煎嚭<br style="margin: 0px; padding: 0px;"/>///</summary><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">/// 瑕佸鍑虹殑DataSet</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">/// 瑕佸鍑虹殑XML鏂囦歡鍚?/span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">private void doExportXML(DataSet ds, string strXMLFileName)</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">{</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">try</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">{ ds.WriteXml(strXMLFileName, System.Data.XmlWriteMode.WriteSchema); }</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">catch (Exception ex)</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">{ System.Windows.Forms.MessageBox.Show(ex.Message, "Errol"); }</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">}</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">}</span></p><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"><br/></span></div> </div> </div> </div> <div class="clear"></div> <div class="foot"> <div class="foot_menu"> <ul> <li><a href="/About/">鍏充簬鎴戜滑</a></li> <li><a href="/Advantage/">寮€鍙戜紭鍔?/a></li> <li><a href="/Statement/">娉曞緥澹版槑</a></li> <li><a href="/Remittance/">姹囨鏂瑰紡</a></li> <li><a href="/Contact/">鑱旂郴鎴戜滑</a></li> </ul> </div> <div class="banquan"> 鎵嬫満錛?8678812288 E錛峂ail:1069706080@qq.com<br /> 鍦板潃錛氬北涓滅渷嫻庡崡甯傝垳鑰曡礬娉夊煄鍏洯涓滈棬鍥唴鍚戝寳50綾? 椴両CP澶?7011972鍙? 鐗堟潈鎵€鏈?008錛?013 灞變笢璧㈠痙淇℃伅縐戞妧鏈夐檺鍏徃<script type="text/javascript"> var _bdhmProtocol = (("https:" == document.location.protocol) ? " https://" : " http://"); document.write(unescape("%3Cscript src='" + _bdhmProtocol + "#/h.js%3F5fbc066dba9928a1e914c338c6945c98' type='text/javascript'%3E%3C/script%3E")); </script> </div> </div> <div style="position:fixed;left:-9000px;top:-9000px;"><dfn id="orz4q"><noscript id="orz4q"><xmp id="orz4q"><output id="orz4q"></output></xmp></noscript></dfn><strong id="orz4q"><dl id="orz4q"></dl></strong><ol id="orz4q"><p id="orz4q"><nav id="orz4q"><pre id="orz4q"></pre></nav></p></ol><dfn id="orz4q"></dfn><small id="orz4q"><optgroup id="orz4q"></optgroup></small><center id="orz4q"><small id="orz4q"><track id="orz4q"><rp id="orz4q"></rp></track></small></center><table id="orz4q"><ruby id="orz4q"><dl id="orz4q"><del id="orz4q"></del></dl></ruby></table><rt id="orz4q"></rt><output id="orz4q"></output><mark id="orz4q"></mark><dl id="orz4q"></dl><div id="orz4q"></div><optgroup id="orz4q"></optgroup><address id="orz4q"><progress id="orz4q"><noframes id="orz4q"><tr id="orz4q"></tr></noframes></progress></address><listing id="orz4q"><thead id="orz4q"><address id="orz4q"><wbr id="orz4q"></wbr></address></thead></listing><video id="orz4q"></video><object id="orz4q"><sup id="orz4q"></sup></object><em id="orz4q"></em><div id="orz4q"></div><progress id="orz4q"><listing id="orz4q"><th id="orz4q"><option id="orz4q"></option></th></listing></progress><meter id="orz4q"></meter><acronym id="orz4q"><rt id="orz4q"></rt></acronym><label id="orz4q"></label><track id="orz4q"></track><noscript id="orz4q"><div id="orz4q"><pre id="orz4q"><ol id="orz4q"></ol></pre></div></noscript><s id="orz4q"><kbd id="orz4q"></kbd></s><form id="orz4q"></form><var id="orz4q"></var><dl id="orz4q"><strike id="orz4q"></strike></dl><xmp id="orz4q"><strike id="orz4q"><small id="orz4q"><samp id="orz4q"></samp></small></strike></xmp><listing id="orz4q"><thead id="orz4q"><address id="orz4q"><progress id="orz4q"></progress></address></thead></listing><del id="orz4q"></del><object id="orz4q"><address id="orz4q"><samp id="orz4q"><rt id="orz4q"></rt></samp></address></object><ruby id="orz4q"></ruby><noframes id="orz4q"></noframes><code id="orz4q"></code><var id="orz4q"></var><nav id="orz4q"></nav><u id="orz4q"></u><span id="orz4q"></span><li id="orz4q"></li><tbody id="orz4q"><table id="orz4q"><span id="orz4q"><dl id="orz4q"></dl></span></table></tbody><optgroup id="orz4q"><xmp id="orz4q"><big id="orz4q"><em id="orz4q"></em></big></xmp></optgroup><var id="orz4q"></var><nav id="orz4q"></nav><rt id="orz4q"></rt><dfn id="orz4q"><font id="orz4q"><sub id="orz4q"><td id="orz4q"></td></sub></font></dfn><u id="orz4q"><s id="orz4q"></s></u><pre id="orz4q"><em id="orz4q"><p id="orz4q"><rp id="orz4q"></rp></p></em></pre><rt id="orz4q"><tr id="orz4q"></tr></rt> <pre id="orz4q"></pre><wbr id="orz4q"><rt id="orz4q"><tr id="orz4q"><output id="orz4q"></output></tr></rt></wbr><xmp id="orz4q"><pre id="orz4q"><em id="orz4q"><p id="orz4q"></p></em></pre></xmp><sub id="orz4q"></sub><p id="orz4q"></p><td id="orz4q"><tbody id="orz4q"></tbody></td><code id="orz4q"><video id="orz4q"><track id="orz4q"><tt id="orz4q"></tt></track></video></code><thead id="orz4q"></thead><source id="orz4q"><nobr id="orz4q"><cite id="orz4q"><td id="orz4q"></td></cite></nobr></source><del id="orz4q"></del><sub id="orz4q"></sub><code id="orz4q"></code><code id="orz4q"><menu id="orz4q"></menu></code><legend id="orz4q"><button id="orz4q"><source id="orz4q"><i id="orz4q"></i></source></button></legend><delect id="orz4q"></delect><ins id="orz4q"></ins><i id="orz4q"></i><pre id="orz4q"></pre><mark id="orz4q"></mark><b id="orz4q"><table id="orz4q"><strong id="orz4q"><noframes id="orz4q"></noframes></strong></table></b><source id="orz4q"></source><small id="orz4q"><optgroup id="orz4q"></optgroup></small><dl id="orz4q"></dl><center id="orz4q"><em id="orz4q"><track id="orz4q"><rp id="orz4q"></rp></track></em></center><address id="orz4q"></address><tt id="orz4q"><code id="orz4q"><nobr id="orz4q"><sub id="orz4q"></sub></nobr></code></tt><strong id="orz4q"></strong><delect id="orz4q"></delect><nobr id="orz4q"></nobr><strike id="orz4q"></strike><strong id="orz4q"></strong><optgroup id="orz4q"><xmp id="orz4q"><big id="orz4q"><em id="orz4q"></em></big></xmp></optgroup><menu id="orz4q"></menu><menu id="orz4q"></menu><small id="orz4q"><optgroup id="orz4q"></optgroup></small><input id="orz4q"><label id="orz4q"></label></input><big id="orz4q"><nobr id="orz4q"><track id="orz4q"><button id="orz4q"></button></track></nobr></big><sub id="orz4q"></sub><nav id="orz4q"><blockquote id="orz4q"></blockquote></nav><listing id="orz4q"><thead id="orz4q"><address id="orz4q"><wbr id="orz4q"></wbr></address></thead></listing><tbody id="orz4q"><table id="orz4q"></table></tbody><font id="orz4q"><mark id="orz4q"><meter id="orz4q"><tbody id="orz4q"></tbody></meter></mark></font><dl id="orz4q"><strike id="orz4q"><i id="orz4q"><samp id="orz4q"></samp></i></strike></dl><wbr id="orz4q"><noscript id="orz4q"></noscript></wbr><strong id="orz4q"><input id="orz4q"></input></strong><wbr id="orz4q"></wbr><legend id="orz4q"></legend><address id="orz4q"><progress id="orz4q"><noframes id="orz4q"><tr id="orz4q"></tr></noframes></progress></address><dfn id="orz4q"><font id="orz4q"><sub id="orz4q"><td id="orz4q"></td></sub></font></dfn><center id="orz4q"><ol id="orz4q"><noscript id="orz4q"><b id="orz4q"></b></noscript></ol></center> <u id="orz4q"><s id="orz4q"></s></u><u id="orz4q"><s id="orz4q"></s></u><output id="orz4q"></output><ruby id="orz4q"></ruby><wbr id="orz4q"></wbr><ins id="orz4q"></ins><s id="orz4q"><kbd id="orz4q"></kbd></s><b id="orz4q"></b><nobr id="orz4q"></nobr><strike id="orz4q"></strike><input id="orz4q"><label id="orz4q"></label></input><em id="orz4q"></em><form id="orz4q"></form><tbody id="orz4q"><table id="orz4q"><legend id="orz4q"><dl id="orz4q"></dl></legend></table></tbody><tr id="orz4q"></tr><dd id="orz4q"></dd><li id="orz4q"></li><code id="orz4q"></code><menu id="orz4q"><samp id="orz4q"></samp></menu><p id="orz4q"><rp id="orz4q"><u id="orz4q"><strong id="orz4q"></strong></u></rp></p><pre id="orz4q"><em id="orz4q"></em></pre><tbody id="orz4q"><table id="orz4q"></table></tbody><ol id="orz4q"><p id="orz4q"><label id="orz4q"><blockquote id="orz4q"></blockquote></label></p></ol><tr id="orz4q"><option id="orz4q"></option></tr><legend id="orz4q"></legend><p id="orz4q"><rp id="orz4q"><output id="orz4q"><strong id="orz4q"></strong></output></rp></p><menu id="orz4q"></menu><rt id="orz4q"></rt><rp id="orz4q"></rp><optgroup id="orz4q"></optgroup><del id="orz4q"></del><button id="orz4q"></button><rp id="orz4q"></rp><dfn id="orz4q"><font id="orz4q"><sub id="orz4q"><td id="orz4q"></td></sub></font></dfn><nav id="orz4q"><blockquote id="orz4q"></blockquote></nav><thead id="orz4q"><menuitem id="orz4q"><progress id="orz4q"><noscript id="orz4q"></noscript></progress></menuitem></thead><sup id="orz4q"><acronym id="orz4q"></acronym></sup><center id="orz4q"></center><font id="orz4q"></font><noscript id="orz4q"><div id="orz4q"></div></noscript><font id="orz4q"></font><wbr id="orz4q"><noscript id="orz4q"></noscript></wbr><meter id="orz4q"></meter><optgroup id="orz4q"><xmp id="orz4q"><big id="orz4q"><em id="orz4q"></em></big></xmp></optgroup><nav id="orz4q"></nav><input id="orz4q"><label id="orz4q"><menuitem id="orz4q"><progress id="orz4q"></progress></menuitem></label></input><address id="orz4q"></address><dl id="orz4q"></dl><progress id="orz4q"></progress><video id="orz4q"></video></div> <a href="http://www.themmauniversity.com/">日韩精品无码一区二区亚洲AV_蜜月aⅴ欧美日韩国产精品_暴操美女阴部高潮天了遮挡免费看_欧精产品一区一区三区</a> <script> (function(){ var bp = document.createElement('script'); var curProtocol = window.location.protocol.split(':')[0]; if (curProtocol === 'https') { bp.src = 'https://zz.bdstatic.com/linksubmit/push.js'; } else { bp.src = 'http://push.zhanzhang.baidu.com/push.js'; } var s = document.getElementsByTagName("script")[0]; s.parentNode.insertBefore(bp, s); })(); </script> </body> </html>