I am a fresher to VB and now stuck with a code for my project.
Project Description : I have a .xlsx Excel File which has two Coulmns "Key" and "Summary", I have populated combobox on the form
using DataSet as shown below :
Dim dt As New System.Data.DataTable() dt = cn.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, Nothing) Dim sheetname As String = dt.Rows(0)("table_name").ToString() Dim da As New OleDbDataAdapter("SELECT Key + ' ' + Summary as Details FROM [" & sheetname & "]", cn) da.Fill(ds, sheetname) da.Dispose() cn.Close() If dt IsNot Nothing OrElse dt.Rows.Count > 0 Then Try ' For Loop to add data to the List of DropDown For i = 0 To ds.Tables(0).Rows.Count - 1 Me.ComboBox1.Items.Add(ds.Tables(0).Rows(i).Item(0)) Next
Now I have to give ComboBox1 a AutoComplete feature so that user needn't have to scroll a huge list.
However I unable to do the same, I tried various ways but none worked. Would really appreciate any help.