priyabalaji
asked on
Data grid
how to refresh a data grid instantly at run time?
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.
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.
ASKER
i have used a data environment connected to the data grid
Use datagrid.refresh
this will solve your problem.
this will solve your problem.
ASKER
i have tried but it does not work.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
hello priyabalaji garu
i am giving code, may be it will usefull to u
public sub DBGRDRefresh()
If DataEnvironment1.rsCommand 1.State = adStateOpen then
DataEnvironment1.rsCommand 1.Close
DataEnvironment1.rsCommand 1.Open "Select * from Products"
Set DataGrid1.DataSource = DataEnvironment1
end sub
Jagadeesh
i am giving code, may be it will usefull to u
public sub DBGRDRefresh()
If DataEnvironment1.rsCommand
DataEnvironment1.rsCommand
DataEnvironment1.rsCommand
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.
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
I have finalized this question, and will monitor it for comments.
Moondancer - EE Moderator
Adodc1.Refresh
And in that way you refresh the content of the datagrid.