Solved

Help with using Gridview to save data in XML file

Posted on 2011-09-18
3
523 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
  • 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

Independent Software Vendors: 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

Suggested Solutions

ASP.Net to Oracle Connectivity Recently I had to develop an ASP.NET application connecting to an Oracle database.As I am doing it first time ,I had to solve several problems. This article will help to such developers  to develop an ASP.NET client…
Many times as a report developer I've been asked to display normalized data such as three rows with values Jack, Joe, and Bob as a single comma-separated string such as 'Jack, Joe, Bob', and vice versa.  Here's how to do it. 
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

680 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