using?System;
using?System.Collections.Generic;
using?System.Linq;
using?System.Web;
using?System.Web.UI;
using?System.Web.UI.WebControls;
using?System.IO;
using?System.Data.SqlClient;
using?System.xml;

namespace?將xml數據寫入數據庫
{
????public?partial?class?Index?:?System.Web.UI.Page
????{
????????protected?void?Page_Load（object?sender?EventArgs?e）
????????{

????????}
????????public?void?readfile（）
????????{
????????????DirectoryInfo?dinfo?=?new?DirectoryInfo（Server.MapPath（“xml/“））;
????????????Rep1.DataSource?=?dinfo.GetFiles（“*.xml“）;??//讀取xml文件夾下所有文件名
????????????Rep1.DataBind（）;??//綁定數據
????????}

????????protected?void?Button3_Click（object?sender?EventArgs?e）
????????{
????????????string?ss?=?Request.Form[“checkbox“];
????????????if?（ss?==?null）
????????????{
????????????????Response.Write（“ript>alert（‘請選擇要導入的文件!‘）;history.go（-1）;ript>“）;
????????????}
????????????else
????????????{
????????????????string?sqlconn?=?System.Configuration.ConfigurationManager.ConnectionStrings[“Strsqlconn“].ConnectionString;
????????????????SqlConnection?conn?=?new?SqlConnection（sqlconn）;
????????????????string[]?filenamelist?=?ss.Split（‘‘）;??//拆分數組

????????????????for?（int?i?=?0;?i?????????????????{
????????????????????xmlDocument?xdoc?=?new?xmlDocument（）;
????????????????????xdoc.Load（Server.MapPath（“xml/“?+?filenamelist[i]））;??//加載xml文件
????????????????????//xmlNode?xn?=?xdoc.SelectSingleNode（“Result“）;??//獲取根節點
????????????????????xmlNodeList?xnl?=?xdoc.GetElementsByTagName（“Result“）;
????????????????????for?（int?j?=?0;?j?????????????????????{
????????????????????????string?xmlId?=?xnl[j].ChildNodes[1].InnerText;?//記錄ID
????????????????????????string?tbname?=?xnl[j].ChildNodes[3].InnerText;?//表格填寫人
????????????????????????string?tbnametype?=?xnl[j].ChildNodes[5].InnerText;?//表格填寫人類型
????????????????????????string?tel?=?xnl[j].ChildNodes[7].InnerText;?//
????????????????????????string?timestamp?=?xnl[j].ChildNodes[9].InnerText;
????????????????????????string?name?=?xnl[j].ChildNodes[11].InnerText;
????????????????????????string?sex?=?xnl[j].ChildNodes[13].InnerText;
????????????????????????string?sql?=?“insert?into?tblResult?（IDsignsignClasscontact[timestamp]namegender）?values?（‘“?+?xmlId?+?“‘‘“?+?tbname?+?“‘‘“?+?tbnametype?+?“‘‘“?+?tel?+?“‘‘“?+?timestamp?+?“‘‘“?+?name?+?“‘‘“?+?sex?+?“‘）?“;
????????????????????????SqlCommand?cmd?=?new?SqlCommand（sql?conn）;
????????????????????????try
????????????????????????{
????????????????????????????conn.Open（）;
????????????????????????????cmd.ExecuteNonQuery（）;
????????????????????????????conn.Close（）;
????????????????????????}
????????????????????????finally
????????????????????????{
????????????????????????????conn.Close（）;
????????????????????????}

????????????????????}
????????????????????//把該文件移動到另外一個文件夾下
????????????????????string?oldfiles?=?Server.MapPath（“xml/“?+?filenamelist[i]

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件???????9216??2012-12-28?08:50??將xml數據寫入數據庫\將xml數據寫入數據庫\bin\將xml數據寫入數據庫.dll

?????文件??????17920??2012-12-28?08:50??將xml數據寫入數據庫\將xml數據寫入數據庫\bin\將xml數據寫入數據庫.pdb

?????文件????????325??2012-12-26?11:01??將xml數據寫入數據庫\將xml數據寫入數據庫\Firstxml.xml

?????文件????????846??2012-12-26?10:31??將xml數據寫入數據庫\將xml數據寫入數據庫\Firstxml.xsd

?????文件???????1996??2012-12-26?10:40??將xml數據寫入數據庫\將xml數據寫入數據庫\Index.aspx

?????文件???????3719??2012-12-26?10:03??將xml數據寫入數據庫\將xml數據寫入數據庫\Index.aspx.cs

?????文件???????1496??2012-12-26?10:25??將xml數據寫入數據庫\將xml數據寫入數據庫\Index.aspx.designer.cs

?????文件??????????3??2012-12-26?12:28??將xml數據寫入數據庫\將xml數據寫入數據庫\Jscript1.js

?????文件???????7834??2012-12-28?09:40??將xml數據寫入數據庫\將xml數據寫入數據庫\obj\Debug\DesignTimeResolveAssemblyReferencesInput.cache

?????文件????????642??2012-12-26?11:10??將xml數據寫入數據庫\將xml數據寫入數據庫\obj\Debug\將xml數據寫入數據庫.csproj.FileListAbsolute.txt

?????文件???????9216??2012-12-28?08:50??將xml數據寫入數據庫\將xml數據寫入數據庫\obj\Debug\將xml數據寫入數據庫.dll

?????文件??????17920??2012-12-28?08:50??將xml數據寫入數據庫\將xml數據寫入數據庫\obj\Debug\將xml數據寫入數據庫.pdb

?????文件???????1355??2012-12-26?09:37??將xml數據寫入數據庫\將xml數據寫入數據庫\Properties\AssemblyInfo.cs

?????文件????????542??2012-12-26?10:03??將xml數據寫入數據庫\將xml數據寫入數據庫\Web.config

?????文件???????1240??2012-12-26?09:37??將xml數據寫入數據庫\將xml數據寫入數據庫\Web.Debug.config

?????文件???????1301??2012-12-26?09:37??將xml數據寫入數據庫\將xml數據寫入數據庫\Web.Release.config

?????文件????????427??2012-12-26?09:58??將xml數據寫入數據庫\將xml數據寫入數據庫\xml\name.xml

?????文件???????1080??2012-12-28?08:49??將xml數據寫入數據庫\將xml數據寫入數據庫\XtoD.aspx

?????文件???????4119??2012-12-28?08:50??將xml數據寫入數據庫\將xml數據寫入數據庫\XtoD.aspx.cs

?????文件???????2531??2012-12-28?08:41??將xml數據寫入數據庫\將xml數據寫入數據庫\XtoD.aspx.designer.cs

?????文件???????4977??2012-12-28?08:49??將xml數據寫入數據庫\將xml數據寫入數據庫\將xml數據寫入數據庫.csproj

?????文件???????1086??2012-12-28?08:49??將xml數據寫入數據庫\將xml數據寫入數據庫\將xml數據寫入數據庫.csproj.user

?????文件?????190355??2012-12-28?08:43??將xml數據寫入數據庫\將xml數據寫入數據庫\省市縣.xml

?????文件????????971??2012-12-26?09:39??將xml數據寫入數據庫\將xml數據寫入數據庫.sln

????..A..H.?????24064??2012-12-27?15:27??將xml數據寫入數據庫\將xml數據寫入數據庫.suo

?????目錄??????????0??2012-12-26?09:37??將xml數據寫入數據庫\將xml數據寫入數據庫\obj\Debug\TempPE

?????目錄??????????0??2012-12-31?09:54??將xml數據寫入數據庫\將xml數據寫入數據庫\obj\Debug

?????目錄??????????0??2012-12-31?09:54??將xml數據寫入數據庫\將xml數據寫入數據庫\bin

?????目錄??????????0??2012-12-31?09:54??將xml數據寫入數據庫\將xml數據寫入數據庫\obj

?????目錄??????????0??2012-12-31?09:54??將xml數據寫入數據庫\將xml數據寫入數據庫\Properties

............此處省略6個文件信息