Update a single datarow

[Wokawidget]

I have this 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:

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

[Wokawidget]

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

Woof

[campster]

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

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.

[Wokawidget]

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