Uses DataGrid to modify Access DB

[Geespot]

Hi


Im using a DataGrid to display and modify a table from an Access DB.

To do this I create a DataSet and fill it with MS Access database.
I then bind the DataGrid to the Dataset so the datagrid automatically displays everything.

I would like to use this DataGrid as my main editing for the Database including Updating/Deleting/Inserting.

But im having trouble working out If i need to insert/update or delete.

Basically when my application closes I wish to save the contents of the DataGrid ( which is binded to a DataSet ) back into a table in a MDB.

So users can delete rows, add rows and update rows.
Then when they exit, I wish to update the MDB table with all the changes from the DataSet.

How can I do this?
Currently this is what im doing

Dim oCB As OleDb.OleDbCommandBuilder = New OleDb.OleDbCommandBuilder(oAdp)
        Dim oComm As OleDb.OleDbCommand = oCB.GetUpdateCommand()
 
        Try
            '-- Updates the Database with the new item list
            oAdp.Update(dsMyItems, "MyItems")
 
        Catch ex As OleDb.OleDbException
            Console.WriteLine(ex.Message)
        End Try
 
        '-- Close the connection, we dont need to keep it open (or do we?)
        oConn.Close()

but the Try code catches an error when records have been added or delete.

[Wallabie]

The .GetUpdateCommand() only updates records. If you want to add new records you use .GetInsertCommand() and to delete the .GetDeleteCommand()

You will need a seperate functon for each one.

If you are using the command builder to add/update/delete then this bit doesn't look right to me, BUT! there are a number of different ways you can do the same things in .NET, so....maybe it's right.....:

Dim oComm As OleDb.OleDbCommand = oCB.GetUpdateCommand()

This is the way i've done it... it works, but god only knows if it's the correct way:
(daRt is the dataadapter)

        'Generate the command builders
        daRt.InsertCommand = cmdBuild.GetInsertCommand

Hope that helps you somewhat and doesn't confuse you even more

[Geespot]

Thanks

I did manage to do it. It was just my lack of knowledge of ADO.NET and databases that caused me problems. After reading through a book and some websites I managed to do it another way.