Hi All,
I am creating a Device app with Pocket PC 2003, MS SQLCE 2.
I am trying to use typed datasets to populate a list.
I have created this part fine, except that when I run the app on the device there is a password problem with the device.
When I manually changed the Connection string used by the DataAdapter everything works fine.

However my manual change gets overwritten whenever I add a new query to the dataadapter.

Is there anyway to set the password before code generation so that it is included in my connection string for autogenerated code?

The stange thing about this is that I get a message whenever configuring/creating a new query that suggests that the password is going to be stored in the connection string and is that ok by me, of course I say yes at this stage. But still no password in connection string.

Many thanks for your assistance
Rod

======================================
They say, best men are molded out of faults,
And, for the most, become much more the better
For being a little bad.
======================================

__________________
======================================
"They say, best men are molded out of faults,
And, for the most, become much more the better
For being a little bad."
--Shakespeare
======================================

Never mind, I found the solution;
There is a property that can be set for the Dataset, Connection > ConnectionString.
For some reasn this was originally misbehaving, but after setting hte property manuall instead of the code all is good.
Thanks for your time.
Rod

======================================
They say, best men are molded out of faults,
And, for the most, become much more the better
For being a little bad.
======================================