Re: Execute SQL statement on Dataset

The dataset is not an in memory database engine. You can't do anything like
that.

"pierrev" <pierrev@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6B435078-7D6C-4F86-ADED-D8B4A6C0CFBA@xxxxxxxxxxxxxxxx
> Hi,
>
> Is there a way to execute SQL statement on a Dataset?
>
> For example, my Dataset contains 1 table and I want to execute the
> following
> SQL statement:
>
> UPDATE table1 SET Field1='x' WHERE Field2='y'
>
> I know I can use filter and loop on the rows but I have many SQL
> statements
> I'ld like to reuse them.
>
> Thanks,
>
>


.

Relevant Pages

  • Re: Urgent....globale variables...
    ... it was a global parameter in a dts package ... that I had to throw into a variable in an execute sql statement. ...
    (microsoft.public.sqlserver.dts)
  • Re: Execute SQL statement on Dataset
    ... A DataSet contains a Tables collection that is made up of DataTable objects. ... FilterExpression argument allows you to query a DataTable in a SQL fasion. ... >> Is there a way to execute SQL statement on a Dataset? ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Execute SQL statement on Dataset
    ... Thanks Marina, this exactly what I wanted to know. ... > The dataset is not an in memory database engine. ... >> Is there a way to execute SQL statement on a Dataset? ...
    (microsoft.public.dotnet.framework.adonet)
  • Execute SQL statement on Dataset
    ... Is there a way to execute SQL statement on a Dataset? ... I'ld like to reuse them. ... Prev by Date: ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Sessions and Pagination Problem
    ... I don't get an error with the query. ... I have multiple if statements that append "AND"'s to the SQL statement ... If you click on page numbers and the prev or next links, ...
    (comp.lang.php)