Re: Execute SQL statement on Dataset

>While you can use the "Select" method/property against a table, to find a
>subset of the rows, this will not permit one to execute an action against
>all of those rows--not without visiting each one.

So, is this not a way to do it? The question was "Is there a way to execute
SQL statement on a Dataset?" The Select method allows for a SQL type of
criteria to be used. Granted it must be accompanied by DataTable techniques
for row movement, it does allow for SQL type statements to be used in
conjunction with a DataTable.

I was responding to Marina who said "You can't do anything like that." .
You most certainly can.



.

Relevant Pages

  • Re: COBOL and DB2 vs. Java and DB2
    ... the doors off SQL type approaches. ... was not nearly as efficient as traditional mainframe databases. ... whether these would "blow the doors off" an SQL type approach (by which I ... take it you mean Relational Database). ...
    (comp.lang.cobol)
  • Re: Execute SQL statement on Dataset
    ... but it definitely helps to limit rows to work with ... > execute SQL statement on a Dataset?" ... The Select method allows for a SQL ... it does allow for SQL type statements to be ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Execute SQL statement on Dataset
    ... But it does give you SQL "like" capabilities with a DataTable ... >> execute SQL statement on a Dataset?" ... it does allow for SQL type statements to be ...
    (microsoft.public.dotnet.framework.adonet)