ADO .NET

  • Thread starter Thread starter shawrie
  • Start date Start date
S

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 ?

thanks
Shawrie
 
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 ?
Click to expand...


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


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
Click to expand...

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,

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


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
Click to expand...

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?
 
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
 
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


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
 
thanks again for your help and advice. Just one last thing for
inserting a record is the new resultset faster than using
executenonquery ?
 
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


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