Solved

Help with using Gridview to save data in XML file

Posted on 2011-09-18
3
524 Views
Last Modified: 2012-05-12
Hi,

I have many questions on how to solve an issue, below are my following questions:

After I loading the grid with my Donorxml file.
1. How do I only add data in the grid if it doesn't already exist in Donor.xml? (If it does use the existing data to avoiding adding duplicate data)
2. If the data i enter in the grid is new, how do I save it in Donor.xml with a new ID?
3. When I select multiple rows in the grid and press Save, how do i save the IDs of the rows selected to my link.xml file
For  example when I enter:
BEL
CAN
USA
In Grid1 ( three rows of data)
I need to save them in Donor.xml  while I create new IDs as shown below:
<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<Root>

  <Donor>

    <DonorID>1</DonorID>

    <Name>BEL</Name>

  </Donor>

  <Donor>

    <DonorID>2</DonorID>

    <Name>CAN</Name>

  </Donor>

  <Donor>

    <DonorID>3</DonorID>

    <Name>USA</Name>

  </Donor>

</Root>

And  at the same time save the newly created IDs to one record in my Link.xmk filke

  <Link>

    <LinkID>1</LinkID>

    <DonorID>1,2,3</DonorID>

  </Link>

 

How do I modify the code to use a grid for multiple entries and saving their IDs to link.xml?

Code: (This code works for entering a single country in a textbox and saving it to Donor.xml and it's ID to Link.xml, as mentioned, now I need to be able to save multiple IDs in Link.xml after selecting multiple rows in a Grid)

 

'Donor

        Dim MyDocDonor As XDocument = XDocument.Load(Application.StartupPath & "/Donor.xml")

        Dim LargestDonorID = (From el In MyDocDonor.Descendants("Donor") Select CInt(el.<DonorID>.Value)).ToList

        LargestDonorID.Sort()

        Dim CheckForItem = (From el In MyDocDonor.Descendants("Donor").Elements("Name") Select el.Value).ToList

        If Not CheckForItem.Contains(Me.TextBox1.Text.ToString) Then

            Dim xNew As XElement = New XElement("Donor")

            xNew.Add(New XElement("DonorID", (LargestDonorID.Last() + 1)))

            xNew.Add(New XElement("Name", Me.TextBox1.Text.ToString))

            MyDocDonor.Root.Add(xNew)

            MyDocDonor.Save(Application.StartupPath & "/Donor.xml")

        End If

        'Link

        Dim MyDocLink As XDocument = XDocument.Load(Application.StartupPath & "/Link.xml")

        Dim LinkID = (From el In MyDocLink.Descendants("Link") Select CInt(el.<LinkID>.Value)).ToList

        LinkID.Sort()

        Dim xNewLink As XElement = New XElement("Link")

        xNewLink.Add(New XElement("LinkID", (LinkID.Last() + 1)))

        xNewLink.Add(New XElement("DonorID", (LargestDonorID.Last() + 1)))

        MyDocLink.Root.Add(xNewLink)

        MyDocLink.Save(Application.StartupPath & "/Link.xml")

Thanks,

Victor


0
Comment
Question by:vcharles
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 16

Accepted Solution

by:
Easwaran Paramasivam earned 500 total points
ID: 36558256
You can use Dataset's WriteXML method to create XML file from Gridview. Refer: http://forums.asp.net/t/1000516.aspx/1

To form Link.xml traverse each row of the grid. Refer: http://forums.asp.net/t/998341.aspx/1

To avoid duplicate rows to be entered in a grid view refer http://usingaspdotnet.blogspot.com/2011/03/avoid-insertion-of-duplicate-using.html.
0
 

Author Comment

by:vcharles
ID: 36570053
Hello,

Thank you for the links but they did not address my issue with xml and vb.bet, can you please help me with the code I posted in muy initial post, to help prevent entering duplicate data in a GriView using XML as a datasource?

Thanks,

Victor
0
 

Author Closing Comment

by:vcharles
ID: 36581829
Thank You!
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This article shows how to use the open source plupload control to upload multiple images. The images are resized on the client side before uploading and the upload is done in chunks. Background I had to provide a way for user…
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

736 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question