Re: DataTables

<bernardpace@xxxxxxxxx> ha scritto nel messaggio
news:1124437974.809860.89770@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

> I have two DataTables with same schema(2 columns: ID, value).
>
> These 2 tables are full of rows. Now I require to check if any
> data(value) in table 1 already exits in table 2.
>
> Is there a simple way to do this?

You need a loop for each row in the first table.
Check if the table2.Select(yourCondition) returns some rows, if not there
aren't compatible rows in the second table.


--
Reporting tool: http://www.neodatatype.net


.

Relevant Pages

  • Re: Dataset (ASP.net) has two datatables. is this normal?
    ... > Is it common to see two datatables within a dataset? ... > to "dbo" and the other belongs to the user who will be accessing the page. ... > TIA, Randy ... Prev by Date: ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Joins with Datatables
    ... but you can use a DataRelation between them and work with it that way as ... > intention of being able to work of disconnected way (datatables, schema, ... Prev by Date: ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Counting records in a dataset
    ... It's the datatables inside the datasets ... and have the results post to a textbox (txtResult). ... Dim Command As Odbc.OdbcCommand = New Odbc.OdbcCommandFROM ... Prev by Date: ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Best practice for showing data from diferent queries in same form
    ... Can you cache them in memory as datatables then do a random selection? ... Prev by Date: ...
    (microsoft.public.dotnet.framework.aspnet)