Symbianize Forum

Most of our features and services are available only to members, so we encourage you to login or register a new account. Registration is free, fast and simple. You only need to provide a valid email. Being a member you'll gain access to all member forums and features, post a message to ask question or provide answer, and share or find resources related to mobile phones, tablets, computers, game consoles, and multimedia.

All that and more, so what are you waiting for, click the register button and join us now! Ito ang website na ginawa ng pinoy para sa pinoy!

vb 6 search

mhaaack

Recruit
Basic Member
Messages
16
Reaction score
0
Points
16
mga boss pa help po. complete code po sa pag search using datagrid and adodc po.
 
mga boss pa help po. complete code po sa pag search using datagrid and adodc po.

adodc.recordsource = "select *from TableName where TableField = '" & trim(txtsearch.Text) & "' order by TableField"
adodc.refresh

adodc.recordsource = "select *from TableName where TableField like '" & trim(txtsearch.Text) & "' order by TableField"
adodc.refresh

adodc.recordsource = "select *from TableName where TableField like '%" & trim(txtsearch.Text) & "%' order by TableField"
adodc.refresh

adodc.find "TableField = '" & trim(txtsearch.Text) & "'"
adodc.find "TableField like '" & trim(txtsearch.Text) & "'"
adodc.find "TableField like '%" & trim(txtsearch.Text) & "%'"

lahat po ng mga yan may pagkakaiba sa pagsearch. Ewan if nakatulong yan sau!
 
adodc.recordsource = "select *from TableName where TableField = '" & trim(txtsearch.Text) & "' order by TableField"
adodc.refresh

adodc.recordsource = "select *from TableName where TableField like '" & trim(txtsearch.Text) & "' order by TableField"
adodc.refresh

adodc.recordsource = "select *from TableName where TableField like '%" & trim(txtsearch.Text) & "%' order by TableField"
adodc.refresh

adodc.find "TableField = '" & trim(txtsearch.Text) & "'"
adodc.find "TableField like '" & trim(txtsearch.Text) & "'"
adodc.find "TableField like '%" & trim(txtsearch.Text) & "%'"

lahat po ng mga yan may pagkakaiba sa pagsearch. Ewan if nakatulong yan sau!

nag eerror po boss pahelp :c
View attachment 203534View attachment 203536
 

Attachments

  • error1.png
    error1.png
    139.7 KB · Views: 5
  • error.png
    error.png
    121.6 KB · Views: 0
Back
Top Bottom