怎样把xml存入数据库，请前辈给个例子，小弟先感谢了！

Question

本帖最后由 salecn 于 2010-07-01 22:50:24 编辑

Answer 1

XmlDocument doc=new XmlDocument();
dic.LoadXML("");
DataSet ds=new DataSet();
ds.ReadXml("");
XmlDocument遍历

Answer 2

            string path = strXmlPath;
            DataSet ds = new DataSet();
            XmlDocument doc = new XmlDocument();
            try
            {
                //将XML文件读入内存
                doc.Load(strXmlPath);
                XmlNodeReader reader = new XmlNodeReader(doc);
                //将XML文件写入到DataSet
                ds.ReadXml(reader);
                reader.Close();
            }
            catch (Exception ex)
            {
                return;
            }            //ds中有两张表，一张存有type
            //另一张result_id，msid，area_no，area_name
            //楼主再将ds写入数据库即可
            希望能帮到你，呵呵

Answer 3

table 本来就是从xml 过来的然后你自己构造一个table 就ok 了

Answer 4

  protected void insertdata_Click(object sender, EventArgs e)
        {
            try
            {
                string constr = "Server=.;Database=Test;Uid=sa;Pwd=123456";
                SqlConnection con = new SqlConnection(constr);
                con.Open();
                insertTableData(con);
                con.Close();
            }
            catch (Exception ex) {  }
            finally
            {
            }
           
        }        private void insertTableData(SqlConnection con)
        {
            XmlDocument xmld = new XmlDocument();
            xmld.Load(Path.GetDirectoryName(Assembly.GetExecutingAssembly().GetName().CodeBase) + "\\strXml.xml");
            XmlNode xmlnode = xmld.SelectSingleNode("yhjx_result");
            XmlNode typenode = xmlnode.SelectSingleNode("response");
            string type = typenode.ChildNodes[1].InnerText;
            XmlNode resultnode = typenode.SelectSingleNode("result");
            string result_id = resultnode.ChildNodes[1].InnerText;
            string msid = resultnode.ChildNodes[3].InnerText;
            string area_no = resultnode.ChildNodes[5].InnerText;
            string area_name = resultnode.ChildNodes[7].InnerText;            string insertstr = "insert into resulttable values('" + type + "','" + result_id + "','" + msid + "','" + area_no + "','" + area_name + "')";
            SqlCommand sqlcom = new SqlCommand(insertstr,con);
            sqlcom.ExecuteNonQuery();
        }

Answer 5

insert into table1 (memo) values("xml")