I am using listview and combobox to search the value from combobox,how could i filter the values using combobx .Here is the code i am using.
FillCombobox(ComboBox1, "Select slno,custname,address,tinno,cstno from tbl_custinfo", "custname", "custname", "custname")
Listview Filled
Public Sub FillList1()
sSql = "Select slno,custname,address,tinno,cstno from tbl_custinfo"
With lstcust
.Clear()
.View = View.Details
.FullRowSelect = True
.GridLines = True
.Columns.Add("SLNO", 0)
.Columns.Add("Customer Name", 290)
.Columns.Add("Address", 500)
.Columns.Add("Tin No", 103)
.Columns.Add("Customer No", 125)
FillListView(lstcust, GetData(sSql))
End With
End Sub
Used To filter by combobox
Private Sub ComboBox1_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ComboBox1.SelectedIndexChanged
sSql = "Select slno,custname,address,tinno,cstno from tbl_custinfo where stu='A' and custname Like '" & ComboBox1.Text.Replace("'", "''") & "%'"
If lstcust.Items.Count = 0 Then
Call FillList1()
MsgBox("Selected Records Not Found")
ElseIf lstcust.Items.Count > 0 Then
End If
End Sub
Can any one help?