Link to home
Start Free TrialLog in
Avatar of priyabalaji
priyabalaji

asked on

Data grid

how to refresh a data grid instantly at run time?
Avatar of puloy
puloy

Are you using the DataGrid to show info from a database? And do you have an ADODC connection linked to the Datagrid? Because in that case you should refresh the adodc. like this
Adodc1.Refresh
And in that way you refresh the content of the datagrid.
Are you using the DataGrid to show info from a database? And do you have an ADODC connection linked
to the Datagrid? Because in that case you should refresh the adodc. like this
Adodc1.Refresh
And in that way you refresh the content of the datagrid.
Avatar of priyabalaji

ASKER

i have used a data environment connected to the data grid
Use datagrid.refresh
this will solve your problem.
i have tried but it does not work.
ASKER CERTIFIED SOLUTION
Avatar of Éric Moreau
Éric Moreau
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
hello priyabalaji garu

i am giving code, may be it will usefull to u

public sub DBGRDRefresh()

If DataEnvironment1.rsCommand1.State = adStateOpen  then  
DataEnvironment1.rsCommand1.Close
DataEnvironment1.rsCommand1.Open "Select * from Products"
Set DataGrid1.DataSource = DataEnvironment1

end sub


Jagadeesh

Please send me your code so that i can rectify where it is giving you a problem.
please GautamMukherjee , take your time reading https://www.experts-exchange.com/jsp/cmtyQuestAnswer.jsp
This question appears to be abandoned. A question regarding it will be left in the Community Support
area; if you have any comment about the question, please leave it here.

Unless there is objection or further activity, one of the moderators will be asked to accept the comment
of <emoreau>.

The link to the Community Support area is:
https://www.experts-exchange.com/jsp/qList.jsp?ta=commspt

DO NOT ACCEPT THIS COMMENT AS AN ANSWER.
Thanks, emoreau  for your help here.

I have finalized this question, and will monitor it for comments.

Moondancer - EE Moderator