Deleting An item from a List Box from a Database

Well, according to the link you posted earlier (http://i53.tinypic.com/n5kb9v.jpg), there is a column called "Member_ID" in tblEvents in the database.

So are you saying that you didn't cater for it at all when you created the tblEvents DataTable in your DataSet? I was hoping that you had allowed for it but had called it something else. 

the thing is that i dont have any relation between tblEvents and tblMembers

Here's an example of using a TableMapping.

Suppose, in the 'tblEvents' table in the database, you have a column called 'Member_ID'.

However, in the 'tblEvents' DataTable in the DataSet, you've called this column 'ID' instead.

When you create your DataAdapter, add these lines:

ITableMapping mapping = da.TableMappings.Add("Table", "tblEvents");
mapping.ColumnMappings.Add("Member_ID", "ID");

Now, when you update the database it should look for the "Table" mapping by default and (hopefully) all will be well.

Are you using any column names in that particular DataTable which are different from the table in the underlying database? I'm thinking in particular of Member_ID which is the one that was showing up before when you received the InvalidOperationException.

If you are, then either:

1. We'll need to create TableMappings for those columns, so that the Update() method can find them.

2. You'll need to change the names of those columns in the DataTable so that they're the same as the ones in the database.

i cant because of this exception : Update unable to find TableMapping['Table'] or DataTable 'Table'.

In that last line, I'd update the whole DataSet rather than the individual table:

da.Update(ds);

Vulpes it worked like that correctly the delete but when i refresh or reload form the items i deleted will pop up again i dont think i deleted them from the db this is my code :

   public void deleteEvent(ListBox list_event)
        {
                int i = list_event.SelectedIndex;

                ds.Tables["tblEvents"].Rows[i].Delete();
                ds.AcceptChanges();
                da.Update(ds.Tables["tblEvents"]);
        }

im getting this exception now :/

http://i53.tinypic.com/n5kb9v.jpg

Help pls