Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Help with using Gridview to save data in XML file

Posted on 2011-09-18
3
Medium Priority
?
538 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 2000 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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

User art_snob (http://www.experts-exchange.com/M_6114203.html) encountered strange behavior of Android Web browser on his Mobile Web site. It took a while to find the true cause. It happens so, that the Android Web browser (at least up to OS ver. 2.…
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. 
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…

704 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