one quick question...(NO ANWER YET)

[siomai]

I'm not really sure if my logic is right so I need your opinion on this...

I have a form with textboxes and a datagrid. What i want to do is to edit and delete the displayed record...by the way, the texboxes are bound to a table and the datagrid is bound to another table, I already have my relationship...so, is it right that I have two update statements? one for the master table and one for the detail table? if so, why won't it work?

Hope someone could correct me on this....thanks a lot people!

this is my code for updating:

daDoc.Update(ds) 'for the master table
daTran.Update(ds) 'for the detail table

Please also suggest a better code for updating! thanks a bunch!

[mendhak]

Is that all you have for the update?

Post the code that goes before and after that, to give us a better view.

[siomai]

well, for my delete button my code is:

Private Sub btnDel_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDel.Click
        Try
            BindingContext(ds, "QuoteDoc").RemoveAt(BindingContext(ds, "QuoteDoc").Position)
            BindingContext(ds, "QuoteTran").RemoveAt(BindingContext(ds, "QuoteTran").Position)
            daDoc.Update(ds)
            daTran.Update(ds)
 
        Catch ex As Exception
        End Try
    End Sub

[mendhak]

Sorry, I really don't know what BindingContext is. (Can you explain?)

Try this:

Dim cbuild As SqlClient.SqlCommandBuilder
cbuild = New SqlClient.SqlCommandBuilder(daDoc)
            daDoc.DeleteCommand = cbuild.GetDeleteCommand()
            daDoc.Update(ds, "Products")
            ds.AcceptChanges()
            daDoc.DeleteCommand.Connection.Close()

Then repeat for daTrans.

[siomai]

i just found this code from microsoft visual basic .net step by step book. It defined bindingcontext as an object that keeps track of all the CurrencyManager objects on my form...

I'll try your code and let you know what happens...thanks!

[siomai]

hi!

I tried using ur code but it didn't delete the record in my database and did not display any error when I run it...

this is my code now...could you tell me what's wrong with it?

Private Sub btnDel_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDel.Click
            Dim cbuild As System.Data.OleDb.OleDbCommandBuilder
            Try
            cbuild = New System.Data.OleDb.OleDbCommandBuilder(daDoc)
            daDoc.DeleteCommand = cbuild.GetDeleteCommand
            daDoc.Update(ds, "QuoteDoc")
            ds.AcceptChanges()
            daDoc.DeleteCommand.Connection.Close()
 
            cbuild = New System.Data.OleDb.OleDbCommandBuilder(daTran)
            daTran.DeleteCommand = cbuild.GetDeleteCommand
            daTran.Update(ds, "Quotetran")
            ds.AcceptChanges()
            daTran.DeleteCommand.Connection.Close()
            MsgBox("Record deleted.", MsgBoxStyle.OKOnly, "Update")
        Catch ex As Exception
        End Try
    End Sub

[mendhak]

Remove one of the ds.AcceptChanges lines, and try putting the remaining ds.AcceptChanges at the end of the sub.

[siomai]

I followed your instructions and your code but it still did not delete the record in my dataset and in my tables. What I did is I attached the bindingcontext line and it deleted the record in my dataset and table. The problem now is, it only deletes the record in my master table (QuoteDoc). The details of the record are still in my details table (QuoteTran). What should I do? What's wrong with the codes?

Private Sub btnDel_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDel.Click
    Dim cbuild As System.Data.OleDb.OleDbCommandBuilder
        Try
 
            BindingContext(ds, "QuoteDoc").RemoveAt(BindingContext(ds, "QuoteDoc").Position)
            cbuild = New System.Data.OleDb.OleDbCommandBuilder(daDoc)
            daDoc.DeleteCommand = cbuild.GetDeleteCommand
            daDoc.Update(ds, "QuoteDoc")
                BindingContext(ds, "QuoteTran").RemoveAt(BindingContext(ds, "QuoteTran").Position)
                cbuild = New System.Data.OleDb.OleDbCommandBuilder(daTran)
                daTran.DeleteCommand = cbuild.GetDeleteCommand
                daTran.Update(ds, "Quotetran")
                ds.AcceptChanges()
                daTran.DeleteCommand.Connection.Close()
 
            MsgBox("Record deleted.", MsgBoxStyle.OKOnly, "Update")
        Catch ex As Exception
        End Try
    End Sub