Saturday, 5 October 2013

Multipal delete in vb.net

Multipal delete in vb.net


Private Sub chkall_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles chkall.CheckedChanged
        If chkall.CheckState = CheckState.Checked Then
            For i As Integer = 0 To dgvfacultyassign.Rows.Count - 1
                dgvfacultyassign.Item(0, i).Value = True
            Next
        Else
            For i As Integer = 0 To dgvfacultyassign.Rows.Count - 1
                dgvfacultyassign.Item(0, i).Value = False
            Next
        End If
    End Sub
Private Sub btdelete_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btdelete.Click
        Try
            For i As Integer = 0 To dgvfacultyassign.Rows.Count - 1
                If dgvfacultyassign.Item(0, i).Value = True Then
                    exedelete("delete FROM assignsubject where Streamname= '" & dgvfacultyassign.Item(1, i).Value & "' and subjectname='" & dgvfacultyassign.Item(2, i).Value & "' ")
                End If
            Next
        Catch ex As Exception
            MsgBox(ex.Message)
        End Try
        If Not d = 0 Then
            frmmsg.lblmsg.Text = "Delete Successfully..."
            frmmsg.ShowDialog()
        Else
            MsgBox("Check Recored As You Want To Delete")
        End If
        d = 0
        fill()
    End Sub

No comments:

Post a Comment