COMBO PARA CANTONES Y PARROQUIAS

Agregar en el DATASET de CANTONES

SELECT CodProv, CodCant, Canton FROM CANTONES WHERE Codprov=?

Agregar en el DATASET de PARROQUIAS

SELECT Codprov, Provincia, codcant, Canton, codparr, parroquia FROM PARROQUIAS WHERE Codprov=?  and Codcant=?

Private Sub Prov_nacComboBox_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Prov_nacComboBox.SelectedIndexChanged

        Me.CANTONESTableAdapter.BUSCARCANTON(Me.BDDECEDataSet.CANTONES, Prov_nacComboBox.SelectedValue)

    End Sub

  

    Private Sub Cant_nacComboBox_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Cant_nacComboBox.SelectedIndexChanged

        Me.PARROQUIASTableAdapter.buscarparroquia(Me.BDDECEDataSet.PARROQUIAS, CInt(Prov_nacComboBox.SelectedValue), CInt(Cant_nacComboBox.SelectedValue))

    End Sub