filtering records based on users input

[peterparker]

---

this is my problem with my system, I have a simple combobox control in my form in order to search the users, i want to filter the records in my database based on users input(like you search in google there is a drop down list)I want my combobox drop down when it matches the criteria to the database. this is my code, but it doesnt work, am using vb.net 2005

con.open()
ds = new dataset()
cmd = new oledbcommand("Select SerialNumber from Itemname where SerialNumber Like ' % " & me.Combobox1.Text & " % ' ", con)
da = new oledbdataAdapter(cmd)
da.fill(ds,"Itemname")
me.combobox1.datasource = ds.tables("Itemname")
me.combobox1.displaymember="SerialNumber"
me.combobox1.dropdwnstyle = combobox1.simple
me.combobox1.dropdown = true
me.combobox1.Autocompletemode = combobox1.SuggestAppend

please do help, i never seen this in google. thank you so much.

[rhex_tendo]

'bro vb.net 2008 ako gamit..

'try dw ang DropdownStyle kay Dropdown bro
'para ma.check if naa sulod ang combobox
'if naa,
'i think naa pa kuwang ana bro....

combobox1.AutoCompleteSource=Listitems

'try dw ni bro
'

[peterparker]

i try it naman bro, but still it doesnt work, walay mo drop down, murag npa ni kulang ngali, the same raman ni sa 2008 bro, giunsa nimo imoha? thank you

[rhex_tendo]

'ing.ani ako paagi bro:

Public Sub FillCombobox(ByVal cboCombo As ComboBox, ByVal sSQL As String, ByVal strTable As String, ByVal strDisplayMember As String, ByVal strValueMember As String)

''Try
'' OpenDB()

'' Dim da As SqlDataAdapter = New SqlDataAdapter(sSQL, cn)
'' Dim dt As New DataSet

'' da.Fill(dt, strTable)

'' cboCombo.DataSource = dt.Tables(strTable).DefaultView
'' cboCombo.DisplayMember = strDisplayMember
'' cboCombo.ValueMember = strValueMember
''Catch ex As Exception
''
''Finally
'' cn.Close()
''End Try
Try
Dim myConn As SqlConnection = New SqlConnection(cnString)
Dim da As SqlDataAdapter = New SqlDataAdapter(sSQL, myConn)
Dim dt As DataTable = New DataTable(strTable)

da.Fill(dt)
cboCombo.DataSource = dt
cboCombo.DisplayMember = strDisplayMember
cboCombo.ValueMember = strValueMember

Catch ex As Exception

End Try

End Sub

'then pgtawag kay:

FillCombobox(cboCustomer, "SELECT CustID,CustName FROM tbl_000_Customer ORDER BY CustName", "tbl_000_Customer", "CustName", "CustID")

'...usually sa designer mn ko mag.set sa iya source... .XSD
'...designer sab ko mgset properties s combobox... try lang ...

[peterparker]

lamat kaau bro, ako ni i try imong code. thanks again, ill give u feedback then

[fixyourself]

this is my problem with my system, I have a simple combobox control in my form in order to search the users, i want to filter the records in my database based on users input(like you search in google there is a drop down list)I want my combobox drop down when it matches the criteria to the database. this is my code, but it doesnt work, am using vb.net 2005

con.open()
ds = new dataset()
cmd = new oledbcommand("Select SerialNumber from Itemname where SerialNumber Like ' % " & me.Combobox1.Text & " % ' ", con)
da = new oledbdataAdapter(cmd)
da.fill(ds,"Itemname")
me.combobox1.datasource = ds.tables("Itemname")
me.combobox1.displaymember="SerialNumber"
me.combobox1.dropdwnstyle = combobox1.simple
me.combobox1.dropdown = true
me.combobox1.Autocompletemode = combobox1.SuggestAppend

please do help, i never seen this in google. thank you so much.

when ni ma execute nga mga lines? while nag type ka sa combo box nga ni actas textbox?

if wa ko msayup cross thread operation mana.

[darkhero]

hmmm.. install sa nko akong visual studio bro. years na nga wala ko nakagamit ana da. kadali lang

[peterparker]

as the user type the combobox it will filter letter by letter pero based ni sa field sa database bro example serialnumber, kana ra ang mag dropdown sa combobox bro. thank you

[peterparker]

ok bro lamat kaau

[peterparker]

ms access akong gamit ani mga bro