I am using SQLServer 2005. I have one table called Drivers.
Every day thousands of records will be added in this table.
I have to show all these records in my GridView with out
applying ajax timer beacause we don't know
the time limit when the new record come to the table.
Sometimes it will add for 10 seconds some times 20 seconds.
There by Please try without using timer or any other
soultion apply for the table in sqlserver.
But, i want to see all records immediately when new record
comes in table. How?

Thanks in advance...
Ramesh

Answer Posted / karthik

Set sqlexpiration policy...under cache call back event,
write whatever you want to perform...

Thanks
Karthik.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How we implement web farm and web garden concept in asp.net?

537


Do I need to have the latest version of windows media player installed?

511


How can you ensure a permanent cookie?

549


What is asp.net web pages?

526


Which protocol is used to call a web service?

559






What is data caching?

547


How to sign out from forms authentication?

538


Explain the disadvantages of viewstate?

567


How can you handle errors in Web API?

589


What is a SESSION and APPLICATION object?

574


Explain the different types of assemblies?

522


1.What r collections? 2.What is .pdb file? 3.Is it possible to provide access to users in master page? 4.What is dirty n Phantom Read(SQL)? 5.What r different isolation levels(SQL)? 6.How to set authentication mode in web.config file?

1778


How does u get record no from 5 to 15 from a dataset of 100 records?

507


What is asp.net caching?

576


What is the Intermittent crashing of application in production?

557