How to search the data from ms access database in vb6 0

[deepuhoney]

Hello,
how to display the searched data in vb6.0 wih using ms access and adodc connectivity ...ple tel me how it do ?????

 

[PhilFrisbie]

You should be able to easily find code samples if you search for them.

 

[zoehan]

"you need to use datagrid and adodc"
----sample code and sample table and field
adodc1.recordsource = "SELECT * FROM SAMPLE_TABLE WHERE SAMPLE_FIELD = '" + TXTSAMPLE.TEXT + "'" * you can add more...

NOTE: be sure to connect adodc to database and put this sample code (select * form sample_table) to recordsource of adodc, then connect the datagrid to adodc(in datasource of datagrid)

 

[tnilk01]

"you need to use datagrid and adodc"
----sample code and sample table and field
adodc1.recordsource = "SELECT * FROM SAMPLE_TABLE WHERE SAMPLE_FIELD = '" + TXTSAMPLE.TEXT + "'" * you can add more...

NOTE: be sure to connect adodc to database and put this sample code (select * form sample_table) to recordsource of adodc, then connect the datagrid to adodc(in datasource of datagrid)

 

[tnilk01]

sir can you give me the complete codes....thank you and Godbless