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"))
'