delete data from datagrid

[chowboon]

Dear all,
how to select the row at the datagrid and press delete key to delete the data from the datagrid as well as database.
as i tried to delete the data from the datagrid, it just remove from the datagrid display only but not the database.

anybody can show me some code to do this feature,
thank you very much.

[RichardAtherton]

The row state will be set to deleted and when you update the data set, it will be removed from the database.

[EyeTalion]

so, just delete from the db and then refresh your grid

[stingrae]

ok, so suppose you don't want to refresh the whole grid. for instance, if you have 100 rows and you wish to delete row 95 from the grid, when you refresh the data grid, it then positions the current row to the very top, and then your user gets the ****s when they have to keep scrolling down to find "their current row"

what's the code to just delete one row of a datagrid?

[stingrae]

i suppose this is one to way to do it.....

            Dim intRow As Integer = grdMembers.CurrentRowIndex
            Group_MembersLoad(intGroupID, grdMembers)
            Try
                grdMembers.CurrentRowIndex = intRow - 1
            Catch
            End Try

(just taking me a while to put my brain into gear this morning - few dwinkies last night... )