Re: Execute SQL statement on Dataset

Yes, I know. But it does give you SQL "like" capabilities with a DataTable
and that's the point I was making.


"Val Mazur (MVP)" <group51a@xxxxxxxxxxx> wrote in message
news:OBb9VW2VFHA.2660@xxxxxxxxxxxxxxxxxxxxxxx
> This Select is more like a WHERE clause. After selection you would need to
> loop through the rows, but it definitely helps to limit rows to work with
>
> --
> Val Mazur
> Microsoft MVP
>
> http://xport.mvps.org
>
>
>
> "Scott M." <s-mar@xxxxxxxxxxxxx> wrote in message
> news:u754rD2VFHA.2124@xxxxxxxxxxxxxxxxxxxxxxx
>> >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: 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)
  • Error adding SQL adapter
    ... Failed to execute SQL statement. ... Please ensure supplied syntax is correct. ...
    (microsoft.public.biztalk.general)
  • RE: Error adding SQL adapter
    ... ALTER procedure usp_GetOfficeIRSCenter @officeid varchar ... "Mike Watson" wrote: ... can you post the SQL that you are trying to generate??? ... >> Failed to execute SQL statement. ...
    (microsoft.public.biztalk.general)
  • Re: SQL Adapter: Cannot generate metadata (Solved)
    ... I get as far as the Statement Information page of the SQL Transport Schema ... Clicking "Generate" generates the expected script: ... "Failed to execute SQL Statement. ... New transaction cannot enlist in the specified transaction ...
    (microsoft.public.biztalk.general)
  • Re: Problem With Insert with MySQLdb
    ... I can read from the database ... the SQL statement in the function). ... The idea is that transactions are not committed into the database until you "commit" them - and if you hit problems halfway through a sequence of updates that really shouldn't be left half finished, you can execute "abort" instead, and none of them will be done. ...
    (comp.lang.python)
Loading