Help with updating table - Please respond

[Gary Paris]

I am trying a test. I want to update one Last Name to "Smith". How can I
do this? What code is missing?

Dim con As New
SqlClient.SqlConnection("server=TESTSERVER;uid=sa;pwd=;database=ServiceMaster")

Dim daContact As New SqlClient.SqlDataAdapter("SELECT first_name,
last_name From Contact ORDER BY last_name, first_name", con)

Dim ds As New DataSet
daContact.Fill(ds, "Contact")

Dim tbl As DataTable = ds.Tables(0)
Dim row As DataRow

row.BeginEdit()
ds.Tables("Contact").Rows(1).Item("last_name") = "Smith"
row.EndEdit()

' *********** IS THIS CORRECT *********** Not sure
'daContact.Update(ds.Tables("Contact"))
'

 

[Stef]

Hi

Try following:

daContact.update(ds)

regards
Stef

 

[Gary Paris]

I tried the update you suggested but received the following error:

update unable to find TableMapping ['Table'] or DataTable 'Table'

so I changed the command to: daContact.update(ds.tables(0))

and received the following error:

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