1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
|
Dim MaBindSource1 As New BindingSource
MaBindSource1.AddNew()
CmdDelCli.Visible = False
ActionCli = "INS"
Requete = "SELECT ID_CONT, CON_LBL FROM T_CONTRAT"
'initilisation objet commande
MaCmd.CommandText = Requete
MaCmd.Connection = CnxBase
'initialisation de l'adapter
AdapBase.SelectCommand = MaCmd
' ouverture de la connexion
CnxBase.Open()
AdapBase.Fill(DstBase, "ListeCont1")
'fermeture de la connexion
CnxBase.Close()
'initialisation du datatable
DtContrat1 = DstBase.Tables("ListeCont1")
'initialisation bindingsource
MaBindSource1.DataSource = DtContrat1
ComboContratClient.DataBindings.Add(New Binding("Text", MaBindSource1, "Con_lbl")) |
Partager