How to bind data from XML file to GridView

Question

0.00/5 (No votes)

See more:

I have this XML file structure:

HTML

<StudentsSystem>
   <Students StudentId="">
    <FirstName></FirstName>
    <LastName></LastName>
    <Gender></Gender>
    <BirthDate></BirthDate>
    <HomeCity></HomeCity>
    <Address></Address>
    <Class></Class>
    <StudiesYear></StudiesYear>
  </Students>

  <Tutors TutorID="">
    <FirstName></FirstName>
    <LastName></LastName>
    <NickName></NickName>
    <Gender></Gender>
    <BirthDate></BirthDate>
    <HomeCity></HomeCity>
    <Address></Address>
    <Mobile></Mobile>
    <Email></Email>
    <Class></Class>
    <Subject></Subject>
  </Tutors>
  

</StudentsSystem>

and I want to bind Tutors to gridview,
I tried this:

C#

using (DataSet ds = new DataSet())
    {
        ds.ReadXml(Server.MapPath("~/StudentsSystem.xml"));
        GridView1.DataSource = ds;
        GridView1.DataBind();
    }

But this's wrong and get the whole XML file..
What could I write?!

Posted 18-Jun-15 13:45pm

Y.Ahmad

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Mathi Mani · Accepted Answer · 2015-06-18T14:30:00

Solution 1

The parsing will create 2 datatables in the dataset. One for Students and one for Tutors.
If you want to bind the Tutors to the gridview, you can do it on one of the following ways.

C#

using (DataSet ds = new DataSet())
    {
        ds.ReadXml(Server.MapPath("~/StudentsSystem.xml"));
        GridView1.DataSource = ds.Tables[1];//Tutors is the second table and it is zero based index
        GridView1.DataBind();
    }

OR

C#

using (DataSet ds = new DataSet())
    {
        ds.ReadXml(Server.MapPath(&quot;~/StudentsSystem.xml&quot;));
        GridView1.DataSource = ds.Tables["Tutors"];
        GridView1.DataBind();
    }

I would suggest the second one as it is easy to identify using table names.

Posted 18-Jun-15 14:30pm

Mathi Mani

Updated 19-Jun-15 6:50am

v2

Comments

Y.Ahmad 19-Jun-15 2:58am

ammmm
Thank you
I noticed that, when I add new row, I can't find this row in the XML file..
I work with sedna, and Sedna saves the changes in its Database..
How can I save the record in the XML file?!
This's my code:
<pre lang="c#">
string sGender = "Male";
if (RBFemale.Checked)
sGender="Female";

string sQuery = "update insert <Tutors TutorID='"+Guid.NewGuid().ToString()+"'>" +
"<FirstName>"+TxtFirstName.Text+"</FirstName>"+
"<LastName>"+TxtLastName.Text+"</LastName>"+
"<NickName>"+TxtNickName.Text+"</NickName>"+
"<Gender>"+sGender+"</Gender>"+
"<BirthDate>"+txtBirthDate.Text+"</BirthDate>"+
"<HomeCity>"+txtHomeCity.Text+"</HomeCity>"+
"<Address>"+TxtAddress.Text+"</Address>"+
"<Mobile>"+TxtMobile.Text+"</Mobile>"+
"<Email>"+TxtEmail.Text+"</Email>"+
"<Class>"+txtClass.Text+"</Class>"+
"<Subject>"+txtSubject.Text+"</Subject>"+
"into document('StudentSystem')/Users";

SednaSession s = new SednaSession();

s.Start("localhost", SednaSession.DEFAULT_SERVER_PORT, "StudentSystem", "SYSTEM", "MANAGER");

SednaQueryResults sql = s.Execute(sQuery);

if (s.HasTransaction)
{
s.CommitTransaction();

lblStatus.Text = "Tutor has been added successfully";
s.Close();
}
else
{
lblStatus.Text = "error!";
s.Close();
}
</pre>

Mathi Mani 19-Jun-15 12:53pm

Refer this link http://stackoverflow.com/questions/8398031/how-to-insert-data-into-an-existing-xml-file-in-asp-net for inserting data into an existing XML