读xml插入数据库

 

1.         SqlConnection conn = new SqlConnection();
2.         conn.ConnectionString= System.Configuration.ConfigurationManager.ConnectionStrings["xml_connstring"].ToString();
3.         conn.Open();
4.         DataSet ds = new DataSet();
5.         DataTable dt = new DataTable();
6.         DataTable dt2 = new DataTable();
7.         string sql,sql2;
8.         sql="select orid,nums,price,khid,khxm from orders where 1=2";
9.         SqlDataAdapter da = new SqlDataAdapter(sql, conn);
10.         da.Fill(dt);
11.         sql2 = "select pro_id,pro_name,num,jiage from order_pro where 1=2";
12.         SqlDataAdapter da2 = new SqlDataAdapter(sql2, conn);
13.         da2.Fill(dt2);
14.         SqlCommandBuilder sbd = new SqlCommandBuilder(da);
15.         SqlCommandBuilder sbd2 = new SqlCommandBuilder(da2);
17.         XmlDocument xd = new XmlDocument();
18.         xd.Load(FileUpload1.PostedFile.FileName);
19.         XmlNodeList nodelist = xd.SelectSingleNode("root").ChildNodes;
20.         foreach (XmlNode xn in nodelist)
21.         {
22.             XmlNodeList nodelist1 = xn.ChildNodes;
23.             DataRow dr = dt.NewRow();
24.             for(int i=0;i<nodelist1.Count;i++)
25.             {
26.                 XmlElement xe = (XmlElement)nodelist1[i];
27.                 if (xe.Name == "pro")
28.                 {
29.                     XmlNodeList nodelist2 = xe.ChildNodes;
30.                     DataRow dr2 = dt2.NewRow();
31.                     foreach (XmlNode xn2 in nodelist2)
32.                     {
33.                         XmlElement xe2 = (XmlElement)xn2;
34.                         dr2[xe2.Name] = xe2.InnerText;
35.                     }
36.                     dt2.Rows.Add(dr2);
38.                 }
39.                 else
40.                 {
41.                     dr[xe.Name] = xe.InnerText;
42.                     
43.                 }
44.             }
45.             dt.Rows.Add(dr);
46.             
47.         }
48.         GridView1.DataSource = dt.DefaultView;
49.         GridView1.DataBind();
50.         GridView2.DataSource = dt2.DefaultView;
51.         GridView2.DataBind();
52.         da.Update(dt);
53.         da2.Update(dt2);
54.         conn.Close();
55.     }

 

1. <?xml version="1.0" encoding="utf-8" ?>
2. <root>
3.   <ding>
4.   <orid>0001</orid>
5.   <nums>2</nums>
6.   <price>502</price>
7.   <pro>
8.     <pro_id>10001</pro_id>
9.     <pro_name>测试产品</pro_name>
10.     <num>1</num>
11.     <jiage>251</jiage>
12.   </pro>
13.     <pro>
14.       <pro_id>10001</pro_id>
15.       <pro_name>测试产品</pro_name>
16.       <num>1</num>
17.       <jiage>251</jiage>
18.     </pro>
19.   <khid>1002</khid>
20.   <khxm>测试</khxm>
21.   </ding>
22.   <ding>
23.     <orid>0001</orid>
24.     <nums>2</nums>
25.     <price>502</price>
26.     <pro>
27.       <pro_id>12546</pro_id>
28.       <pro_name>测试产品2</pro_name>
29.       <num>1</num>
30.       <jiage>251</jiage>
31.     </pro>
32.     <khid>1002</khid>
33.     <khxm>测试</khxm>
34.   </ding>
35. </root>