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 / sanjeev

you can use sql server based cache bu this whenever a record
is entered in the database, the cache expires and new reult
will be displayed

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain how can we access static variable?

657


By default, Web API sends HTTP response with which of the following status code for all uncaught exception?

1112


Explain different types of validators in asp.net?

621


When cookie will expire?

687


To display data in the combo box, prior to setting the Data Source, what kind of property on a Combo Box do you set with a column name?

697






Describe Segmentation With Paging?

713


5. What three Specific Job Positions do you target from Swatz Oils GROUP U.K?

1885


How does asp net store session ids by default?

611


In which event are the controls fully loaded?

658


Explain server-side scripting and client-side scripting.

599


Explain repository pattern in asp.net mvc? : asp.net mvc

607


How do you open a page in a new window?

632


What is difference between View State and Hidden Field in ASP.NET?

740


Explain about the Class view window?

686


What is mvc in asp.net interview question? : Asp.Net MVC

585