Hello All...
I need help about MCCB...
Why the data always change to blank after i click new button or edit button
hope attached picture help to explain the problem
Here the code i write on Form_load
ds = New DataSet("Daftar") Tblanggota = ds.Tables.Add("Anggota") With Tblanggota .Columns.Add("KODE", GetType(String)) .Columns.Add("NAMA", GetType(String)) End With 'fill TblAnggota Using conn As New OleDbConnection(str) conn.Open() Using cmd = conn.CreateCommand() 'mengisikan data Anggota. Dim query = <sql> SELECT KodeAnggota as KODE, NamaAnggota as NAMA FROM MstAnggota ORDER BY KodeAnggota </sql>.Value() cmd.CommandText = query Dim adapter = New OleDbDataAdapter(cmd) adapter.SelectCommand = cmd Tblanggota.Rows.Add(New Object() {"", ""}) adapter.Fill(Tblanggota) End Using With CmbAnggota .DataSource = Tblanggota '.SelectedValue = "" .AutoSizeDropDownToBestFit = True .BestFitColumns() .AutoFilter = True .DisplayMember = "KODE" .ValueMember = "KODE" .Text = "" TxtNamaAnggota.Text = "" 'Dim filter As New FilterDescriptor() 'filter.PropertyName = Me.CmbAnggota.DisplayMember 'filter.[Operator] = FilterOperator.Contains 'Me.CmbAnggota.EditorControl.MasterTemplate.FilterDescriptors.Add(filter) 'CmbAnggota.MultiColumnComboBoxElement.EditorControl.EnableCustomFiltering = True 'AddHandler CmbAnggota.MultiColumnComboBoxElement.EditorControl.CustomFiltering, AddressOf CmbAnggota_CustomFiltering 'AddHandler CmbAnggota.KeyDown, AddressOf CmbAnggota_KeyDown End With conn.Close() End Using TxtNamaAnggota.DataBindings.Add("Text", Tblanggota, "NAMA")I have tried to move the code on button_click event. but the i got the same result.
Thanks before