wats wrong in this code for deleting a row frm datagrid...

[rhepsi]

Hii all,

im worried with a project where...

im trying to delete a row from the datagrid....

 
delete_button_click:...
 
 Dim index As Integer
        Dim rowcount As Integer
 
 
        For rowcount = 0 To myDS.Tables(0).Rows.Count - 1
 
            Dim dr As DataRow
            dr = myDS.Tables(0).Rows(index)
 
            If MessageBox.Show("Are you sure", "Delete", MessageBoxButtons.YesNo) = DialogResult.Yes Then
 
                dr.Delete()
                myDS.Tables(0).AcceptChanges()
                index = index - 1
 
            End If
 
 
            Dim cmSQL As New MySqlCommand
            Dim conSQL As New MySqlConnection
 
            If (conSQL.State = ConnectionState.Closed) Then
                conSQL.ConnectionString = connect.ConnectionString
                conSQL.Open()
                Dim strSQL As String = "DELETE ch_child_name, ch_date_of_birth, ch_blood_group, ch_child_standard, " & _
                " ch_child_gender, ch_child_standard_year, ch_worker_code " & _
                " FROM tbl_child_details WHERE ch_child_name = myDS.Tables(0).Rows.rowcount "
 
                cmSQL = New MySqlCommand
                cmSQL.Connection = conSQL
                cmSQL.CommandText = strSQL
                cmSQL.ExecuteNonQuery()
 
            End If
 
        Next rowcount
        index = index + 1
 
        Me.Close()
 
 

im aint getting any exception....but the row is not getting deleted.........

plz some one help...
thnxx..
hepsi..

[kenobewan]

Its not getting deleted in the db, datagrid or both?