Read values from XML File and save in MySQL Database using C#

Last Reply on May 13, 2013 07:18 AM By Mudassar

Posted on May 13, 2013 01:33 AM

how to splite lat and lon from xml file and store into mysql database.

plz reply as early as possiable.

Posted on May 13, 2013 07:18 AM

This way

 

        DataSet ds = new DataSet();
        ds.ReadXml(Server.MapPath("~/XML/Lat_Lan.xml"));
        foreach (DataRow row in ds.Tables["Point"].Rows)
        {
            string lat = row["coordinates"].ToString().Split(',')[0];
            string lon = row["coordinates"].ToString().Split(',')[1];
            //Save to database here

        }