Hello
i have the dataset (data) which contains numbers of rows and
these rows are displayed in datagrid
i added delete command coloum in the datagrid
and i want when the user click the delete button
the associated row is deleted from the dataset and from the database

the code is:

Dim id As Integer
id = e.Item.ItemIndex
Dim strdel As String = "delete from AllAlumni where AllAlumniNum=" & id
Dim sqlcommand As SqlCommand = New SqlCommand(strdel, cnn)
Dim adapt As New SqlDataAdapter
adapt.UpdateCommand = sqlcommand
adapt.Update(data, "AllAllumni")
it doesn't work

thanks
sara