Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 277
  • Last Modified:

Easy question on using Select in typed DataSet

I have a dataset based off of the following sample XML

<ContactSet>
            <Contact email="jdoe@yahoo.com" contact_id="12122">
                  <Status>Online</Status>
                  <SynchronizeStatus>Modify</SynchronizeStatus>
                  <Title>Ms.</Title>
                  <FirstName>Jane</FirstName>
                  <MiddleName>Leigh</MiddleName>
                  <LastName>Doe</LastName>
                  <EntryID>1234</EntryID>
                  <EntryID>4567</EntryID>
            </Contact>
      </ContactSet>

I can select a contact by e-mail address simply by doing

ContactSet.ContactRow[] rows = (ContactSet.ContactRow[])contactSet.Contact.Select("email='"+email_or_id+"'");

Can I easily select a CONTACT based on the entryID?

I've tried doing

contactSet.EntryID.Select("EntryID='"+entryid+"'") but it says that it cannot find the EntryID column.  What should I be selecting on here?
                  
0
jjacksn
Asked:
jjacksn
1 Solution
 
smeggheadCommented:
Maybe it's because entryid occurs twice and it names them EntryID1 and EntryID2 or something (I'm just guessing).

Try itterating through the columns printing out the column names.. to see what it's calling them

Smg.
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!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now