How can i refresh ADO data control?

[mohanq]

hi,

I am using ADO Data Control to display the records in MSHFlexGrid control.
I set the recordsource property to adodc control with the query in the form of string variable.

dim str
if cmbMembers.text = "" then
str = "select * from temp where id like "M*"
else
str = "select * from temp where id not like "M*"
end if
Adodc1.recordsource = str
adodc1.refresh

set mshflexgrid1.datasource = adodc1
mshflexgrid1.refresh

My problem is, when cmbMembers.text is null, it needs to display the records in null condition specified above, and if cmbMember.text is not null, it needs to display records specifed above in else condition.

when i used above code snippet, adodc control is not refresh and displays with previous output. pls let me know how to resolve it.

thanks in advance,
mohan.

 

[CCLINT]

Change the * asterisk to % percent sign. [/b][/i][/u]_{*******************************************************
General remarks:
If this post contains any suggestions for the use or distribution of code, components or files of any sort, it is still your responsibility to assure that you have the proper license and distribution rights to do so!}