Update a single datarow

I have this code:

VB Code:

oSqlDataAdapter = New SqlDataAdapter(oSqlCommand)
            Dim ComBuilder As New SqlCommandBuilder(oSqlDataAdapter)
 
            Dim DataRows(0) As DataRow
            DataRows(0) = Data
            oSqlDataAdapter.Update(DataRows)

Where Data is a DataRow.
The SQL query of my command is:

VB Code:

Public ReadOnly Property EditSQL() As String
        Get
            Dim SQL As String
 
            SQL = "SELECT BookingDetail.BookingKey "
            SQL &= ",ISNULL(BookingDetail.AssetKey, 0) AS AssetKey "
            SQL &= ",ISNULL(BookingDetail.ClientKey, 0) AS ClientKey "
            SQL &= ",ISNULL(BookingDetail.ContactKey,0) AS ContactKey "
            SQL &= ",ISNULL(BookingDetail.BookedFrom, getDate()) AS BookedFrom "
            SQL &= ",ISNULL(BookingDetail.BookedTo, GetDate()) AS BookedTo "
            SQL &= ",ISNULL(BookingDetail.LayoutKey, 0) AS LayoutKey "
            SQL &= ",ISNULL(BookingDetail.Guests, 0) AS Guests "
            SQL &= ",ISNULL(BookingDetail.PrepTimeBefore, 0) AS PrepTimeBefore "
            SQL &= ",ISNULL(BookingDetail.PrepTimeAfter, 0) AS PrepTimeAfter "
            SQL &= ",ISNULL(BookingDetail.Comments, '') AS Comments "
            SQL &= ",ISNULL(BookingDetail.UpdateUserID, 0) AS UpdateUserID "
            SQL &= "FROM BookingDetail "
 
            Return SQL
        End Get
    End Property

No errors occur on the update statement, but it doesn't save to the db.

WOka

is there anything special you need to do to save a datarow to the db?

Woof

I believe that you need to update the dataset, not the datarow.

VB Code:

oSqlDataAdapter = New SqlDataAdapter(oSqlCommand)
Dim ComBuilder As New SqlCommandBuilder(oSqlDataAdapter)
Dim ds as New DataSet
 
oSqlDataAdapter.Fill(ds,"myTable")
Dim DataRows(0) As DataRow
DataRows(0) = Data
oSqlDataAdapter.Update(ds,"myTable")

I'm new at this, so it's just a guess.

Well the update of the data adapetr accepts datarows...
plus I don't have a table with the datrow as it's been destroyed.
I create a new datariow, and pass that back to the UI froma function.
The table that contained this gets toasted.

if I try to add the datarow back to another data table then I get an error saying that is already assigned to a datatable.

Woof