[RESOLVED] [2005] Datagridview update error

[LuxCoder]

I am using the following update command in the button click event:

 ElseIf TypeOf Me.ActiveMdiChild Is WkPayment Then
            Dim ChildForm As WkPayment = DirectCast(Me.ActiveMdiChild, WkPayment)

            ChildForm.Validate()
            ChildForm.EMPDRAWBindingSource.EndEdit()
            ChildForm.EMPDRAWTableAdapter.Update(ChildForm.EmPaY.EMPDRAW)
            MsgBox("        Update successful       ")

and i am getting the following error:

Update requires a valid UpdateCommand when passed DataRow collection with modified rows.

What could possibly be wrong ?

[stanav]

It's telling you exactly what you need to do: you need to provide the update commandtext for your table adapter.

[Aspnot]

I agree with stanav. Can you provide the code to setup your Table Adapter? There is probably a SelectCommand property without an UpdateCommand property.

[jmcilhinney]

If your TableAdapter has no UpdateCommand then either your query does not return a primary key or it contains join. Either way the wizard cannot generate an UpdateCommand automatically.

How did you create this TableAdapter? Does it correspond directly to a table in your database? If so then that table must not have a primary key. How can you update a record if you can't uniquely identify it? How can you uniquely identify a record without a primary key?

If you created the query yourself then you must either have not included the table's primary key or else the query references more than one table. In that case you will have to create the UpdateCommand yourself because the wizard can't do it.

[LuxCoder]

Now that i have to set primary key, how should i do it? From the Dataset designer or should i create the same table again with the primary key in the database?

[LuxCoder]

Okies, issue resolved ! Have created new table with the primary key ! Thanks.

[Aeterna]

I need to know how to do this as well. Lux can you please provide the code? What do I put for Update and Delete commandtext ?