Re: Execute SQL statement on Dataset

I said you cannot execute update statements on a dataset like that. And you
cannot do that!

There are obviously ways to accomplish that. But I assumed the original
question was regarding literally executing SQL statements on the dataset -
which is not possible.

"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