Saving Data when modified

[daniel aristidou]

Hi guys im stuck in vb08 again......

Im trying to save the database after editing with a datagrid.
It saves ok when a new record has been added but not when existing data has been modified.

This is the code im using

Try
 Me.Validate()
 Me.Customerbindingsource.endedit()
 Me.customertableadapter.update(me.fortedataset1.Customers)
 msg("Data saved")
Catch ex as exception
 Msg("saved Failed")
 e.cancel = True
End try

The error occurs on the Me.Customertableadapter.update(me.fortedataset1.Cu stomers) line
The default error message is:
"Update requires a valid updatecommand when passed datarow with modified rows"

Any solution?

Daniel(~_~)

[QVeen72]

Hi,

Check the Update Command for the Customeradapter.
usually, "Update" Statements are not built automatically, you have to Create a New for Update with proper SQL Syntax..

REgards
Veena

[daniel aristidou]

Hi,

Check the Update Command for the Customeradapter.
usually, "Update" Statements are not built automatically, you have to Create a New for Update with proper SQL Syntax..

REgards
Veena

Then what does the
Me.Customerstableadapter.Update(etc)
Do?

[QVeen72]

Hi,

Post here , What is your Update SQL Statement...?
May be, Update Statement is there but there is no proper "Where Conditions"..
Its better if Where Condition is based on the PK of the table..

REgards
Veena

[daniel aristidou]

Hi,

Post here , What is your Update SQL Statement...?
May be, Update Statement is there but there is no proper "Where Conditions"..
Its better if Where Condition is based on the PK of the table..

REgards
Veena

I cannot find a statement anywhere except for the fill data statement which is used to copy the records from the dataset to the adapter.

[QVeen72]

Hi,

Right-Click the adatpter object >> Edit Queries in dataSet Designer
Select Adapter RightClick >> Add Queries >> Next >> Select OptionUpdate
>> Next
Check What is the Updte Statement..

Regards
Veena

[daniel aristidou]

Hi,

Right-Click the adatpter object >> Edit Queries in dataSet Designer
Select Adapter RightClick >> Add Queries >> Next >> Select OptionUpdate
>> Next
Check What is the Updte Statement..

Regards
Veena

The Update statement is simply "update"

[daniel aristidou]

The Update statement is simply "update"

But how do i enforce the statement

[daniel aristidou]

But how do i enforce the statement

I moved on to this
Dim adpt as tableadapter
adpt.updatecommand() But im stuck on that......it wont let me use it. and seems to return "Nothing"

Also as per The Sql Statment. I dont know sql at all. can some one help me create an update statement It says whenever i try ........."token line 1, tokenline to 25"