SqlceDataAdapter.Update

[Luca Vajani]

Hi, I'm trying to update a Table on sqlserverce.

I fill the datatable with a SqlCEDataAdapter,
I fill the schema, so I'have the informations about primary keys.
But when I try to call the DataAdapter.Update method it Throws an
sqlceException without message and innerexception.
Now I'm using then sqlcecommandbuilder. I tried also to assign the
insertcommand, updatecommand etc of the dataAdapter without results...

Any Suggestions?

Thanks,
Luca Vajani

 

[Darren Shaffer]

there are at least three approaches to creating data adapter commands for
use with
SQL CE and it's hard to help you without knowing what your code looks like
or the table
you are binding to. please head over to "microsoft.public.sqlserver.ce"
which is the
appropriate forum for this question and post your adapter code and the sql
ce table
definition. thank you.

 

[Ilya Tumanov [MS]]

You should examine error collection to determine the reason for this error.

Look up SqlCeException.Errors Property in VS documentation for a sample.



Best regards,



Ilya



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