Combo - DataSource




Sql = "Select * from Articoli order by Articolo"
DatSet = New DataSet("Articoli")
DatAdpter = New OleDb.OleDbDataAdapter(Sql, Dbazienda)
DatAdpter.Fill(DatSet, "Articoli")

BindSrc = New BindingSource
BindSrc.DataSource = DatSet
BindSrc.DataMember = "Articoli"
'ComboBox1.DataBindings.Add(New System.Windows.Forms.Binding("SelectedValue", BindSrc, "Articolo"))

'ComboBox1.DataBindings.Add(New System.Windows.Forms.Binding("SelectedItem", BindSrc, "Id"))

ComboBox1.DisplayMember = "Articolo"
ComboBox1.ValueMember = "id"
ComboBox1.DataSource = DatSet.Tables("Articoli")


'************************

' questo e' migliore

'************************


Me.ComboBox1.DataBindings.Add(New System.Windows.Forms.Binding("SelectedValue", BindSrc, "IdCliente", True))
Me.ComboBox1.DataSource = Me.ClientiBinding
Me.ComboBox1.DisplayMember = "Nominativo"
Me.ComboBox1.FormattingEnabled = True
Me.ComboBox1.ValueMember = "Id"










( combodatasource.html )- by Paolo Puglisi - Modifica del 17/12/2023