ADO .NET

hello im currently working on a simple application for PDA's that
simply writes a record and reads a record. Whats the best to use
datareader and using raw sql commands or datasets? Any one got any
recommendations ?

thanks
Shawrie

E®!k
Sat Feb 17 12:46:56 CST 2007

Shawrie
> hello im currently working on a simple application for PDA's that
> simply writes a record and reads a record. Whats the best to use
> datareader and using raw sql commands or datasets? Any one got any
> recommendations ?
>


Depends on what you are doing, I would suggest to also look at the
SqlCEResultset. That is an updateable datareader, very fast, much faster
than a dataset.

Erik

shawrie
Sat Feb 17 13:01:56 CST 2007

On 17 Feb, 18:46, "E=AE!k Visser" <burod...@planet.nl> wrote:
> Shawrie
>
> > hello im currently working on a simple application for PDA's that
> > simply writes a record and reads a record. Whats the best to use
> > datareader and using raw sql commands or datasets? Any one got any
> > recommendations ?
>
> Depends on what you are doing, I would suggest to also look at the
> SqlCEResultset. That is an updateable datareader, very fast, much faster
> than a dataset.
>
> Erik

basically i will have a database table of product information. A user
will type in a product code i will then look it up in the database and
display the information. Also they can also fill in a form and this
will be written to the database.

what cirmcustances would you use a dataset in a PDA application?

Ginny
Sat Feb 17 14:31:16 CST 2007

shawrie,

I don't usually use DataSet on mobile devices, but I'd consider it if the
data originates as XML. For SQLce I use SqlCeResultSet as Erik suggested.

--
Ginny


"shawrie" <neil.shaw@sanderson.com> wrote in message
news:1171738916.224921.233380@q2g2000cwa.googlegroups.com...
On 17 Feb, 18:46, "E®!k Visser" <burod...@planet.nl> wrote:
> Shawrie
>
> > hello im currently working on a simple application for PDA's that
> > simply writes a record and reads a record. Whats the best to use
> > datareader and using raw sql commands or datasets? Any one got any
> > recommendations ?
>
> Depends on what you are doing, I would suggest to also look at the
> SqlCEResultset. That is an updateable datareader, very fast, much faster
> than a dataset.
>
> Erik

basically i will have a database table of product information. A user
will type in a product code i will then look it up in the database and
display the information. Also they can also fill in a form and this
will be written to the database.

what cirmcustances would you use a dataset in a PDA application?

shawrie
Sat Feb 17 15:24:38 CST 2007

thanks for help is the sqlceresultset new? ive never come across that
for the compact framework
also is this better than using sqlcedatareader,execute reader just
simply writing a single record to a database



On 17 Feb, 20:31, "Ginny Caughey [MVP]"
<ginny.caughey.onl...@wasteworks.com> wrote:
> shawrie,
>
> I don't usually use DataSet on mobile devices, but I'd consider it if the
> data originates as XML. For SQLce I use SqlCeResultSet as Erik suggested.
>
> --
> Ginny
>
> "shawrie" <neil.s...@sanderson.com> wrote in message
>
> news:1171738916.224921.233380@q2g2000cwa.googlegroups.com...
> On 17 Feb, 18:46, "E=AE!k Visser" <burod...@planet.nl> wrote:
>
> > Shawrie
>
> > > hello im currently working on a simple application for PDA's that
> > > simply writes a record and reads a record. Whats the best to use
> > > datareader and using raw sql commands or datasets? Any one got any
> > > recommendations ?
>
> > Depends on what you are doing, I would suggest to also look at the
> > SqlCEResultset. That is an updateable datareader, very fast, much faster
> > than a dataset.
>
> > Erik
>
> basically i will have a database table of product information. A user
> will type in a product code i will then look it up in the database and
> display the information. Also they can also fill in a form and this
> will be written to the database.
>
> what cirmcustances would you use a dataset in a PDA application?

Ginny
Sat Feb 17 16:26:06 CST 2007

SqlCeResultSet was introduced with CF version 2. SqlCeResultSet inherits
from SqlCeDataReader and gives you the ability to update the data including
inserting records, which you cannot do using SqlCeDataReader.

--
Ginny


"shawrie" <neil.shaw@sanderson.com> wrote in message
news:1171747478.102093.21820@k78g2000cwa.googlegroups.com...
thanks for help is the sqlceresultset new? ive never come across that
for the compact framework
also is this better than using sqlcedatareader,execute reader just
simply writing a single record to a database



On 17 Feb, 20:31, "Ginny Caughey [MVP]"
<ginny.caughey.onl...@wasteworks.com> wrote:
> shawrie,
>
> I don't usually use DataSet on mobile devices, but I'd consider it if the
> data originates as XML. For SQLce I use SqlCeResultSet as Erik suggested.
>
> --
> Ginny
>
> "shawrie" <neil.s...@sanderson.com> wrote in message
>
> news:1171738916.224921.233380@q2g2000cwa.googlegroups.com...
> On 17 Feb, 18:46, "E®!k Visser" <burod...@planet.nl> wrote:
>
> > Shawrie
>
> > > hello im currently working on a simple application for PDA's that
> > > simply writes a record and reads a record. Whats the best to use
> > > datareader and using raw sql commands or datasets? Any one got any
> > > recommendations ?
>
> > Depends on what you are doing, I would suggest to also look at the
> > SqlCEResultset. That is an updateable datareader, very fast, much faster
> > than a dataset.
>
> > Erik
>
> basically i will have a database table of product information. A user
> will type in a product code i will then look it up in the database and
> display the information. Also they can also fill in a form and this
> will be written to the database.
>
> what cirmcustances would you use a dataset in a PDA application?

shawrie
Sat Feb 17 16:55:43 CST 2007

thanks again for your help and advice. Just one last thing for
inserting a record is the new resultset faster than using
executenonquery ?


On 17 Feb, 22:26, "Ginny Caughey [MVP]"
<ginny.caughey.onl...@wasteworks.com> wrote:
> SqlCeResultSet was introduced with CF version 2. SqlCeResultSet inherits
> from SqlCeDataReader and gives you the ability to update the data includi=
ng
> inserting records, which you cannot do using SqlCeDataReader.
>
> --
> Ginny
>
> "shawrie" <neil.s...@sanderson.com> wrote in message
>
> news:1171747478.102093.21820@k78g2000cwa.googlegroups.com...
> thanks for help is the sqlceresultset new? ive never come across that
> for the compact framework
> also is this better than using sqlcedatareader,execute reader just
> simply writing a single record to a database
>
> On 17 Feb, 20:31, "Ginny Caughey [MVP]"
>
>
>
> <ginny.caughey.onl...@wasteworks.com> wrote:
> > shawrie,
>
> > I don't usually use DataSet on mobile devices, but I'd consider it if t=
he
> > data originates as XML. For SQLce I use SqlCeResultSet as Erik suggeste=
d=2E
>
> > --
> > Ginny
>
> > "shawrie" <neil.s...@sanderson.com> wrote in message
>
> >news:1171738916.224921.233380@q2g2000cwa.googlegroups.com...
> > On 17 Feb, 18:46, "E=AE!k Visser" <burod...@planet.nl> wrote:
>
> > > Shawrie
>
> > > > hello im currently working on a simple application for PDA's that
> > > > simply writes a record and reads a record. Whats the best to use
> > > > datareader and using raw sql commands or datasets? Any one got any
> > > > recommendations ?
>
> > > Depends on what you are doing, I would suggest to also look at the
> > > SqlCEResultset. That is an updateable datareader, very fast, much fas=
ter
> > > than a dataset.
>
> > > Erik
>
> > basically i will have a database table of product information. A user
> > will type in a product code i will then look it up in the database and
> > display the information. Also they can also fill in a form and this
> > will be written to the database.
>
> > what cirmcustances would you use a dataset in a PDA application?- Hide =
quoted text -
>
> - Show quoted text -

Ginny
Sat Feb 17 18:04:14 CST 2007

I haven't timed inserting a single record, but it is faster inserting many
records so I assume it is also faster for a single record.

--
Ginny


"shawrie" <neil.shaw@sanderson.com> wrote in message
news:1171752943.398229.131480@t69g2000cwt.googlegroups.com...
thanks again for your help and advice. Just one last thing for
inserting a record is the new resultset faster than using
executenonquery ?


On 17 Feb, 22:26, "Ginny Caughey [MVP]"
<ginny.caughey.onl...@wasteworks.com> wrote:
> SqlCeResultSet was introduced with CF version 2. SqlCeResultSet inherits
> from SqlCeDataReader and gives you the ability to update the data
> including
> inserting records, which you cannot do using SqlCeDataReader.
>
> --
> Ginny
>
> "shawrie" <neil.s...@sanderson.com> wrote in message
>
> news:1171747478.102093.21820@k78g2000cwa.googlegroups.com...
> thanks for help is the sqlceresultset new? ive never come across that
> for the compact framework
> also is this better than using sqlcedatareader,execute reader just
> simply writing a single record to a database
>
> On 17 Feb, 20:31, "Ginny Caughey [MVP]"
>
>
>
> <ginny.caughey.onl...@wasteworks.com> wrote:
> > shawrie,
>
> > I don't usually use DataSet on mobile devices, but I'd consider it if
> > the
> > data originates as XML. For SQLce I use SqlCeResultSet as Erik
> > suggested.
>
> > --
> > Ginny
>
> > "shawrie" <neil.s...@sanderson.com> wrote in message
>
> >news:1171738916.224921.233380@q2g2000cwa.googlegroups.com...
> > On 17 Feb, 18:46, "E®!k Visser" <burod...@planet.nl> wrote:
>
> > > Shawrie
>
> > > > hello im currently working on a simple application for PDA's that
> > > > simply writes a record and reads a record. Whats the best to use
> > > > datareader and using raw sql commands or datasets? Any one got any
> > > > recommendations ?
>
> > > Depends on what you are doing, I would suggest to also look at the
> > > SqlCEResultset. That is an updateable datareader, very fast, much
> > > faster
> > > than a dataset.
>
> > > Erik
>
> > basically i will have a database table of product information. A user
> > will type in a product code i will then look it up in the database and
> > display the information. Also they can also fill in a form and this
> > will be written to the database.
>
> > what cirmcustances would you use a dataset in a PDA application?- Hide
> > quoted text -
>
> - Show quoted text -