Author: Piornet | Posted on: 10/7/2009 2:54:38 PM | Views : 273

Hi,
This is probably an extremely simple question, but I'm trying to find the best and least resource intensive way to match a column in two DataTables.  I have an XML feed of users currently logged into a legacy system, which I parse into a DataTable.  I then have the Membership.GetAllUsers() method.  I want to see if XML.Name has a corresponding entry in Membership.UserName.  (We display the XML feed on our intranet - my ultimate goal is, if the XML.Name matches to Membership.UserName to have a link to their profile.)


I hope I haven't made this too confusing.  As an example, let's say my XML list has the following names:

John Doe
Sarah Doe
Bill Doe


And Membership.GetAllUsers() returns this:
Pete Doe
Karen Doe
John Doe
Andrea Doe


Then, in this example, I'd like to find out that John Doe provided a match between the two DataTables.&n ...

Go to the complete details ...