Problem with dataset in .NET 2.0 Update requires a valid UpdateCom

[Shaun O''Callaghan]

Hi All,

I have a typed dataset on a Windows form on Smart Device Application that
displays data from a Sql Server Mobile database.

The problem is, whenever I want to add a new record I first make a call to:

myTableBindingS ource.AddNew();

and this inserts a blank row.

When I've completed editing I make a call to:

myTableBindingS ource.EndEdit() ;
myTableTableAda pter.Update(myD ataSet.myTable) ;

and this works fine, no problems at all.
However, when I load the form and want to edit an existing record and not
add a new one... the Update command fails with:

"Update requires a valid UpdateCommand when passed DataRow collection with
modified rows"
I'm pretty sure this is something pretty basic I've missed. I've tried
making calls to myDataSet.myTab le.AcceptChange s() but this doesn't work
either. I know that it's because the Update statement on the
myTableTableAda pter object isn't being initialized correctly.

Does anyone know how to make sure the Update command is generated correctly
and the changes can be persisted back into the database?

Thanks,

Shaun O'Callaghan

[chanmm]

Bear in mind that when you are using SQL mobile the database path that you
set is in the mobile device and not your development machine.

chanmm

"Shaun O''Callaghan" <Sh************ *@discussions.m icrosoft.com> wrote in
message news:95******** *************** ***********@mic rosoft.com...

Hi All,

I have a typed dataset on a Windows form on Smart Device Application that
displays data from a Sql Server Mobile database.

The problem is, whenever I want to add a new record I first make a call
to:

myTableBindingS ource.AddNew();

and this inserts a blank row.

When I've completed editing I make a call to:

myTableBindingS ource.EndEdit() ;
myTableTableAda pter.Update(myD ataSet.myTable) ;

and this works fine, no problems at all.
However, when I load the form and want to edit an existing record and not
add a new one... the Update command fails with:

"Update requires a valid UpdateCommand when passed DataRow collection with
modified rows"
I'm pretty sure this is something pretty basic I've missed. I've tried
making calls to myDataSet.myTab le.AcceptChange s() but this doesn't work
either. I know that it's because the Update statement on the
myTableTableAda pter object isn't being initialized correctly.

Does anyone know how to make sure the Update command is generated
correctly
and the changes can be persisted back into the database?

Thanks,

Shaun O'Callaghan