91av视频/亚洲h视频/操亚洲美女/外国一级黄色毛片 - 国产三级三级三级三级

  • 大小: 59KB
    文件類型: .rar
    金幣: 2
    下載: 0 次
    發(fā)布日期: 2021-06-06
  • 語(yǔ)言: C#
  • 標(biāo)簽: XML??C#??asp.net??

資源簡(jiǎn)介

C#讀取XML文件并寫入數(shù)據(jù)庫(kù)的三種方法，直接寫入和先讀取到內(nèi)存再寫入數(shù)據(jù)庫(kù)

資源截圖

代碼片段和文件信息 

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數(shù)據(jù)寫入數(shù)據(jù)庫(kù)
{
????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（）;??//綁定數(shù)據(jù)
????????}

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

????????????????for?（int?i?=?0;?i?????????????????{
????????????????????xmlDocument?xdoc?=?new?xmlDocument（）;
????????????????????xdoc.Load（Server.MapPath（“xml/“?+?filenamelist[i]））;??//加載xml文件
????????????????????//xmlNode?xn?=?xdoc.SelectSingleNode（“Result“）;??//獲取根節(jié)點(diǎn)
????????????????????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（）;
????????????????????????}

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

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----

?????文件???????9216??2012-12-28?08:50??將xml數(shù)據(jù)寫入數(shù)據(jù)庫(kù)\將xml數(shù)據(jù)寫入數(shù)據(jù)庫(kù)\bin\將xml數(shù)據(jù)寫入數(shù)據(jù)庫(kù).dll

?????文件??????17920??2012-12-28?08:50??將xml數(shù)據(jù)寫入數(shù)據(jù)庫(kù)\將xml數(shù)據(jù)寫入數(shù)據(jù)庫(kù)\bin\將xml數(shù)據(jù)寫入數(shù)據(jù)庫(kù).pdb

?????文件????????325??2012-12-26?11:01??將xml數(shù)據(jù)寫入數(shù)據(jù)庫(kù)\將xml數(shù)據(jù)寫入數(shù)據(jù)庫(kù)\Firstxml.xml

?????文件????????846??2012-12-26?10:31??將xml數(shù)據(jù)寫入數(shù)據(jù)庫(kù)\將xml數(shù)據(jù)寫入數(shù)據(jù)庫(kù)\Firstxml.xsd

?????文件???????1996??2012-12-26?10:40??將xml數(shù)據(jù)寫入數(shù)據(jù)庫(kù)\將xml數(shù)據(jù)寫入數(shù)據(jù)庫(kù)\Index.aspx

?????文件???????3719??2012-12-26?10:03??將xml數(shù)據(jù)寫入數(shù)據(jù)庫(kù)\將xml數(shù)據(jù)寫入數(shù)據(jù)庫(kù)\Index.aspx.cs

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

?????文件??????????3??2012-12-26?12:28??將xml數(shù)據(jù)寫入數(shù)據(jù)庫(kù)\將xml數(shù)據(jù)寫入數(shù)據(jù)庫(kù)\Jscript1.js

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

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

?????文件???????9216??2012-12-28?08:50??將xml數(shù)據(jù)寫入數(shù)據(jù)庫(kù)\將xml數(shù)據(jù)寫入數(shù)據(jù)庫(kù)\obj\Debug\將xml數(shù)據(jù)寫入數(shù)據(jù)庫(kù).dll

?????文件??????17920??2012-12-28?08:50??將xml數(shù)據(jù)寫入數(shù)據(jù)庫(kù)\將xml數(shù)據(jù)寫入數(shù)據(jù)庫(kù)\obj\Debug\將xml數(shù)據(jù)寫入數(shù)據(jù)庫(kù).pdb

?????文件???????1355??2012-12-26?09:37??將xml數(shù)據(jù)寫入數(shù)據(jù)庫(kù)\將xml數(shù)據(jù)寫入數(shù)據(jù)庫(kù)\Properties\AssemblyInfo.cs

?????文件????????542??2012-12-26?10:03??將xml數(shù)據(jù)寫入數(shù)據(jù)庫(kù)\將xml數(shù)據(jù)寫入數(shù)據(jù)庫(kù)\Web.config

?????文件???????1240??2012-12-26?09:37??將xml數(shù)據(jù)寫入數(shù)據(jù)庫(kù)\將xml數(shù)據(jù)寫入數(shù)據(jù)庫(kù)\Web.Debug.config

?????文件???????1301??2012-12-26?09:37??將xml數(shù)據(jù)寫入數(shù)據(jù)庫(kù)\將xml數(shù)據(jù)寫入數(shù)據(jù)庫(kù)\Web.Release.config

?????文件????????427??2012-12-26?09:58??將xml數(shù)據(jù)寫入數(shù)據(jù)庫(kù)\將xml數(shù)據(jù)寫入數(shù)據(jù)庫(kù)\xml\name.xml

?????文件???????1080??2012-12-28?08:49??將xml數(shù)據(jù)寫入數(shù)據(jù)庫(kù)\將xml數(shù)據(jù)寫入數(shù)據(jù)庫(kù)\XtoD.aspx

?????文件???????4119??2012-12-28?08:50??將xml數(shù)據(jù)寫入數(shù)據(jù)庫(kù)\將xml數(shù)據(jù)寫入數(shù)據(jù)庫(kù)\XtoD.aspx.cs

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

?????文件???????4977??2012-12-28?08:49??將xml數(shù)據(jù)寫入數(shù)據(jù)庫(kù)\將xml數(shù)據(jù)寫入數(shù)據(jù)庫(kù)\將xml數(shù)據(jù)寫入數(shù)據(jù)庫(kù).csproj

?????文件???????1086??2012-12-28?08:49??將xml數(shù)據(jù)寫入數(shù)據(jù)庫(kù)\將xml數(shù)據(jù)寫入數(shù)據(jù)庫(kù)\將xml數(shù)據(jù)寫入數(shù)據(jù)庫(kù).csproj.user

?????文件?????190355??2012-12-28?08:43??將xml數(shù)據(jù)寫入數(shù)據(jù)庫(kù)\將xml數(shù)據(jù)寫入數(shù)據(jù)庫(kù)\省市縣.xml

?????文件????????971??2012-12-26?09:39??將xml數(shù)據(jù)寫入數(shù)據(jù)庫(kù)\將xml數(shù)據(jù)寫入數(shù)據(jù)庫(kù).sln

????..A..H.?????24064??2012-12-27?15:27??將xml數(shù)據(jù)寫入數(shù)據(jù)庫(kù)\將xml數(shù)據(jù)寫入數(shù)據(jù)庫(kù).suo

?????目錄??????????0??2012-12-26?09:37??將xml數(shù)據(jù)寫入數(shù)據(jù)庫(kù)\將xml數(shù)據(jù)寫入數(shù)據(jù)庫(kù)\obj\Debug\TempPE

?????目錄??????????0??2012-12-31?09:54??將xml數(shù)據(jù)寫入數(shù)據(jù)庫(kù)\將xml數(shù)據(jù)寫入數(shù)據(jù)庫(kù)\obj\Debug

?????目錄??????????0??2012-12-31?09:54??將xml數(shù)據(jù)寫入數(shù)據(jù)庫(kù)\將xml數(shù)據(jù)寫入數(shù)據(jù)庫(kù)\bin

?????目錄??????????0??2012-12-31?09:54??將xml數(shù)據(jù)寫入數(shù)據(jù)庫(kù)\將xml數(shù)據(jù)寫入數(shù)據(jù)庫(kù)\obj

?????目錄??????????0??2012-12-31?09:54??將xml數(shù)據(jù)寫入數(shù)據(jù)庫(kù)\將xml數(shù)據(jù)寫入數(shù)據(jù)庫(kù)\Properties

............此處省略6個(gè)文件信息

評(píng)論

共有 條評(píng)論