How to read XML Attributes using DataSet ReadXml and save in database using C# .Net

Ikramsha...

SOLVED CLOSED ACTIVE ANSWERED
User: Ikramshams
Posted: on May 15, 2013 11:06 PM
Forum: .Net Basics
Answer: 1
Views: 8173

I have xml files like below;

I have table structure like below:

id int, identity,

engURL nvarchar(500),

arURL nvarchar(500)

I want to insert data of engURL and arURL of xml file into the field of engURL and arURL of table of Database(SQL Server) using ASP.Net,C#. How I will do it please guide me.

<LinkList>
  <Link urlEng="http://www.aljazeerademo.com/Academy/About Academy" urlAr="http://www.aljazeerademo.com/AcademyAr/عن الأكاديمية" />
  <Link urlEng="http://www.aljazeerademo.com/Academy/Objectives" urlAr="http://www.aljazeerademo.com/AcademyAr/الاهداف" />
  <Link urlEng="http://www.aljazeerademo.com/Academy/Training Courses" urlAr="http://www.aljazeerademo.com/AcademyAr/الدورات التدريبية" />
  <Link urlEng="http://www.aljazeerademo.com/Academy/Saudi colors conference 2013" urlAr="http://www.aljazeerademo.com/AcademyAr/المؤتمر السعودي الثاني للدهانات والألوان 2013" />
</LinkList>

Download FREE API for Word, Excel and PDF in ASP.Net

Mudassar

0 5

Reply
ANSWER
User: Mudassar
Replied: on May 16, 2013 06:18 AM
Report

This way

 DataSet ds = new DataSet();
        ds.ReadXml(Server.MapPath("~/XML/Links.xml"), XmlReadMode.Auto);
        foreach (DataRow row in ds.Tables[0].Rows)
        {
            string urlEng = row.ItemArray[0].ToString();
            string urlAr = row.ItemArray[1].ToString();
            //Save to database here

        }

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

How to read XML Attributes using DataSet ReadXml and save in database using C# .Net

Company

Explore

Follow us

Contact Us