DataSet refresh after Update

Let say there is a DataSet containing some data given by SQL command from
SQLServerCE database.
This DataSet we bind to a control that Shows the data.
Than (somehow) we modify showed data in database (by UPDATE for example).

Do we need to reload the DataSet or control to see the changes?
If Yes what are the tricks not to refresh whole DataSet, but only changed
row(s)?

Thanks
Freestyler

Jon
Wed Oct 06 05:59:15 CDT 2004

Freestyler <freestyler@gazeta.pl> wrote:
> Let say there is a DataSet containing some data given by SQL command from
> SQLServerCE database.
> This DataSet we bind to a control that Shows the data.
> Than (somehow) we modify showed data in database (by UPDATE for example).
>
> Do we need to reload the DataSet or control to see the changes?

Yes. DataSets are disconnected from the database.

> If Yes what are the tricks not to refresh whole DataSet, but only changed
> row(s)?

Well, you could keep a "last modified" timestamp in the database, and
only fetch things with a timestamp later than the last fetch time...

--
Jon Skeet - <skeet@pobox.com>
http://www.pobox.com/~skeet
If replying to the group, please do not mail me too

Freestyler
Fri Oct 08 07:20:01 CDT 2004

>> Let say there is a DataSet containing some data given by SQL command from
>> SQLServerCE database.
>> This DataSet we bind to a control that Shows the data.
>> Than (somehow) we modify showed data in database (by UPDATE for example).
>>
>> Do we need to reload the DataSet or control to see the changes?
>
> Yes. DataSets are disconnected from the database.

Really? I heard that there is a possibility to put some input or update
commands or stored procedures dealing with hanges saved to DataSet.
Is it not supported in CF?

Regards
Freestyler

ilyatum
Fri Oct 08 13:42:49 CDT 2004

It is supported (see DataAdapter class) and works the same way as on the
desktop.
However, DataSet is not a live connection to the database; it's an offline
in memory database.
DataAdapter is used to move data between DataSet and database and it's not
automatic.
If you want a live cursor (which might be appropriate with SQL CE),
consider using DataReader class instead.

Best regards,

Ilya

This posting is provided "AS IS" with no warranties, and confers no rights.


--------------------
> From: "Freestyler" <freestyler@gazeta.pl>
> Newsgroups: microsoft.public.dotnet.framework.compactframework
> Subject: Re: DataSet refresh after Update
> Date: Fri, 8 Oct 2004 14:20:01 +0200
> Organization: "Portal Gazeta.pl -> http://www.gazeta.pl"
> Lines: 17
> Message-ID: <ck60n4$8a8$1@inews.gazeta.pl>
> References: <ck0hpe$8lc$1@inews.gazeta.pl>
<MPG.1bcde05da9644db298b5e8@msnews.microsoft.com>
> NNTP-Posting-Host: aa42.internetdsl.tpnet.pl
> X-Trace: inews.gazeta.pl 1097238053 8520 80.53.158.42 (8 Oct 2004
12:20:53 GMT)
> X-Complaints-To: usenet@agora.pl
> NNTP-Posting-Date: Fri, 8 Oct 2004 12:20:53 +0000 (UTC)
> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
> X-Priority: 3
> X-RFC2646: Format=Flowed; Original
> X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
> X-User: freestyler
> X-MSMail-Priority: Normal
> Path:
cpmsftngxa06.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.s
ul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsfeeds.phibee.net!n
ntp.idg.pl!newsfeed.gazeta.pl!news.gazeta.pl!not-for-mail
> Xref: cpmsftngxa06.phx.gbl
microsoft.public.dotnet.framework.compactframework:62805
> X-Tomcat-NG: microsoft.public.dotnet.framework.compactframework
>
> >> Let say there is a DataSet containing some data given by SQL command
from
> >> SQLServerCE database.
> >> This DataSet we bind to a control that Shows the data.
> >> Than (somehow) we modify showed data in database (by UPDATE for
example).
> >>
> >> Do we need to reload the DataSet or control to see the changes?
> >
> > Yes. DataSets are disconnected from the database.
>
> Really? I heard that there is a possibility to put some input or update
> commands or stored procedures dealing with hanges saved to DataSet.
> Is it not supported in CF?
>
> Regards
> Freestyler
>
>
>