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" |