Re: Execute SQL statement on Dataset


Thanks Marina, this exactly what I wanted to know.

"Marina" wrote:

> 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: Execute SQL statement on Dataset
    ... The dataset is not an in memory database engine. ... > Is there a way to execute SQL statement on a Dataset? ... Prev by Date: ...
    (microsoft.public.dotnet.framework.adonet)
  • 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)
  • 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: Cannot import data into SQL Server database from FileMaker Pro 5.5
    ... > Can you use the same sql statement using the same provider using a ... > Allan Mitchell MCSE,MCDBA, ... >> When I'm trying to execute DTS package,I got some error. ... Marina ...
    (microsoft.public.sqlserver.dts)
Loading