XML写回SQLSEVER使用最原始的遍例单元格

 

            int rowcount = dsxml.Tables[0].Rows.Count;
            if (rowcount > 0)
            {
                int columncount = dsxml.Tables[0].Columns.Count;
                //请空所有记录
                SqlConnection con = new SqlConnection(constr);
                SqlCommand cmd = new SqlCommand("TRUNCATE TABLE XMLTestTbl", con);
                con.Open();
                cmd.ExecuteNonQuery();


                //获取数据库源
                DataSet dsdb = new DataSet();
                SqlConnection con2 = new SqlConnection(constr);
                SqlDataAdapter adapter = new SqlDataAdapter("select * from XMLTestTbl", con2);
                SqlCommandBuilder scb = new SqlCommandBuilder(adapter);
                adapter.Fill(dsdb, "XML");
                //再建表
                for (int i = 0; i < rowcount; i++)
                {
                    DataRow dr = dsdb.Tables["XML"].NewRow();
                    for (int j = 0; j < columncount; j++)
                    {
                        dr[j] = dsxml.Tables[0].Rows[i][j];
                    }
                    dsdb.Tables["XML"].Rows.Add(dr);
                }
                adapter.Update(dsdb, "XML");
                this.Message.Text = "copy finished";
                con.Close();
                con2.Close();
            }

     //改进后的记录
     //请空所有记录
            string constr = ConfigurationManager.ConnectionStrings["ConStr"].ConnectionString;
            SqlConnection con2 = new SqlConnection(constr);
            SqlCommand cmd = new SqlCommand("TRUNCATE TABLE XMLTestTbl", con2);
            con2.Open();
            cmd.ExecuteNonQuery();
            //
            DataSet dsxml = new DataSet();
            dsxml.ReadXml(Server.MapPath("test.xml"));
            DataSet dsdb = new DataSet();
            SqlConnection con = new SqlConnection(constr);
            con.Open();
            SqlDataAdapter adapter = new SqlDataAdapter("select * from XMLTestTbl", con);
            SqlCommandBuilder scb = new SqlCommandBuilder(adapter);
            adapter.Update(dsxml);