How to send the client's xml and schema submission to the server and save the dataset to the database?

king0604

Can the schema be saved on the client? (Similar to xml data island)

king0604

Can it only be opened as a file?

lich2006

What does schema mean?

lich2006

string OrderNumERP = null;
        DB d = new DB ();
        XmlDocument xd = new XmlDocument ();
        xd.Load (File1.Value);
        XmlNodeList xnl = xd.GetElementsByTagName ("SCSSalesOrderHeader");
        for (int i = 0; i <xnl.Count; i ++)
        {
            sql = "insert into Header values ​​(";
            foreach (XmlNode xn in xnl [i] .ChildNodes)
            {

                sql = sql + "'" + xn.InnerText + "',";
            }
            OrderNumERP = xnl [i] .ChildNodes [3] .InnerText;
            sql = sql.Substring (0, sql.Length-1);
            sql = sql + ")";
            d.gengxin (sql);
        }


public void gengxin (string sql)
    {

        string name = ConfigurationManager.AppSettings ["name"];
        SqlConnection scon = new SqlConnection (con);
        scon.Open ();
        SqlCommand scom = new SqlCommand (sql, scon);
        scom.ExecuteNonQuery ();
        scon.Close ();
    }
Written messy