how to filter data
-
hi all.. i have a question about how to filter the data.. acctually, what know how to filter data is object.recordset.filter = filterstring for example adodc1.recordset.filter = "author = 'david'" the question from the example above, it will filter only the word david.. so how i want to filter all the name david ?? for example in my database there are many david like david reader, david blake and what ever david, so how i want to filter all the name david?? after i filter it, how i want to display all record back.. what i do is with this code adodc1.recordset. filter = "" or adodc1.recordset.filter = adfilternone but there are nothing happen.. actually, i display my data with datagrid.. can someone know how to solve the problem.. thanks.. areon25
-
hi all.. i have a question about how to filter the data.. acctually, what know how to filter data is object.recordset.filter = filterstring for example adodc1.recordset.filter = "author = 'david'" the question from the example above, it will filter only the word david.. so how i want to filter all the name david ?? for example in my database there are many david like david reader, david blake and what ever david, so how i want to filter all the name david?? after i filter it, how i want to display all record back.. what i do is with this code adodc1.recordset. filter = "" or adodc1.recordset.filter = adfilternone but there are nothing happen.. actually, i display my data with datagrid.. can someone know how to solve the problem.. thanks.. areon25
areon25 wrote:
adodc1.recordset.filter = "author = 'david'" the question from the example above, it will filter only the word david.. so how i want to filter all the name david ?? for example in my database there are many david like david reader, david blake and what ever david, so how i want to filter all the name david?? after i filter it, how i want to display all record back.. what i do is with this code adodc1.recordset. filter = "" or adodc1.recordset.filter = adfilternone but there are nothing happen.. actually, i display my data with datagrid.. can someone know how to solve the problem.. thanks..
I also used to work with data in access or from vb6. I never use filter to get data. But it doesn't mean that it is wrong at all. What I usually done is query data by using sql statement. I suggest you to read some information from here[^], and you might get some idea relate to your question.