Compare Two Datatables
in [VB.NET]
|
Prev: .INI in VB.Net?
Next: Code to Extract Text from PDF
From: John Wright on 2 Jul 2008 12:15 I have two datatables that I load. One I load from LDAP, the other gets loaded from Excel. I need to check to see which names are in the LDAP that are not in the Excel table and vica versa. There are about 300 records in each. Short of a brute force attack on this, does anyone have an elegant way to list the non-matches in each table? Thanks. John
From: Cor Ligthert[MVP] on 2 Jul 2008 12:51 John, Loop trough your both tables with a for each dr as datarow in datatable.rows and use than in the other table the rowcollection find with the key from dr if it exist. http://msdn.microsoft.com/en-us/library/ydd48eyk(vs.85).aspx Cor "John Wright" <riley_wright(a)hotmail.com> schreef in bericht news:eLyhk7F3IHA.4536(a)TK2MSFTNGP06.phx.gbl... >I have two datatables that I load. One I load from LDAP, the other gets >loaded from Excel. I need to check to see which names are in the LDAP that >are not in the Excel table and vica versa. There are about 300 records in >each. Short of a brute force attack on this, does anyone have an elegant >way to list the non-matches in each table? > > Thanks. > > John >
From: Patrice on 2 Jul 2008 12:54 If you really need to optimize you could progress in parallel in two sorted lists (you'll have the initial sort cost, then you'll basically browse each list once in parallel to find out the difference). I would try that only once I'm 100% sure the simpelst approach is not quick enough... -- Patrice "John Wright" <riley_wright(a)hotmail.com> a �crit dans le message de groupe de discussion : eLyhk7F3IHA.4536(a)TK2MSFTNGP06.phx.gbl... > I have two datatables that I load. One I load from LDAP, the other gets > loaded from Excel. I need to check to see which names are in the LDAP > that are not in the Excel table and vica versa. There are about 300 > records in each. Short of a brute force attack on this, does anyone have > an elegant way to list the non-matches in each table? > > Thanks. > > John >
From: Miro on 2 Jul 2008 13:17 Doesnt SQL server have a compare on two databases as well? -If the two have the same schema ? I remember reading something up on this a while ago. I cannot remember if it was "in code .net" or if it was part of the sql server options. Might be a good quick way if this is a one time thing. If it even exists of what I am talking about. - otherwise - sorry for the post. Miro "Cor Ligthert[MVP]" <notmyfirstname(a)planet.nl> wrote in message news:DF24F5C5-951F-45C6-A066-9350438AF537(a)microsoft.com... > John, > > Loop trough your both tables with a for each dr as datarow in > datatable.rows > and use than in the other table the rowcollection find with the key from > dr if it exist. > > http://msdn.microsoft.com/en-us/library/ydd48eyk(vs.85).aspx > > Cor > > > "John Wright" <riley_wright(a)hotmail.com> schreef in bericht > news:eLyhk7F3IHA.4536(a)TK2MSFTNGP06.phx.gbl... >>I have two datatables that I load. One I load from LDAP, the other gets >>loaded from Excel. I need to check to see which names are in the LDAP >>that are not in the Excel table and vica versa. There are about 300 >>records in each. Short of a brute force attack on this, does anyone have >>an elegant way to list the non-matches in each table? >> >> Thanks. >> >> John >> >
From: John Wright on 2 Jul 2008 13:31
Thanks Cor for the suggestion. Now I guess this needs to get a little Fuzzy. I need to do a like comparison search on the rows as well. Most of the rows are the same, but there are some that are slightly different. For example in on list the lastname will be Smith III (Smith the 3rd) while in the other list it is just Smith. So I would like to make a 1 for 1 comparison at the row level as suggested then, use the unmatched names and do a like search to provide the user of possible matches. Any suggestions on doing a like search? John "Patrice" <http://www.chez.com/scribe/> wrote in message news:3F47C52C-2D0C-4183-8CD4-7A3FDFF10A3A(a)microsoft.com... > If you really need to optimize you could progress in parallel in two > sorted lists (you'll have the initial sort cost, then you'll basically > browse each list once in parallel to find out the difference). > > I would try that only once I'm 100% sure the simpelst approach is not > quick enough... > > -- > Patrice > > "John Wright" <riley_wright(a)hotmail.com> a �crit dans le message de groupe > de discussion : eLyhk7F3IHA.4536(a)TK2MSFTNGP06.phx.gbl... >> I have two datatables that I load. One I load from LDAP, the other gets >> loaded from Excel. I need to check to see which names are in the LDAP >> that are not in the Excel table and vica versa. There are about 300 >> records in each. Short of a brute force attack on this, does anyone have >> an elegant way to list the non-matches in each table? >> >> Thanks. >> >> John >> > |