SqlDataSource with 2 tables joined....

Basically, you need to create 3 stored procedures here: one for selecting the records, one for updating an existing record, and one for deleting an existing record.

The select procedure is where you'll do the join to generate the recordset to be displayed in the grid.

The update procedure can do one or more updates to whichever tables need to be updated.

The logic of the delete procedure will most likely be the same as the update procedure, except it will be using the DELETE command instead.