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
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / subhash saini
u have to use cache for that, which automaically refresh
the page by calling delegate.
| Is This Answer Correct ? | 6 Yes | 2 No |
Answer / 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 |
Answer / deepak
u can do one thing whenever u r inserting record in database just bind grid at the same time again it will show all new with old record..may be it will be useful for u
| Is This Answer Correct ? | 0 Yes | 1 No |
what is difference between User Control,Custom Contro1,Web server control and template controls
what is NET Framework ?
What are Http handler ?
6 Answers Accenture, BirlaSoft, Satyam, Syntel,
Is object a value type or referenced type?
Hi please tell me what is ISNOTPOSTBACK,POSTBACK,AUTOPOSTBACK and also the extensions of aspx,asmx,ascx its urgent plz reply me soon....
what is the jit? what is the type of jit and purpose of it>
What is application variable?
How can we prevent an aspx page get refreshed when any information fetch from the database ?
What are the different ways you would consider sending data across pages in ASP (i.e between 1.asp to 2.asp)?
Is oauth for authentication or authorization?
can we place the same DLL in debug folder two times? (without using strong name )
What is the difference between a thread and a process?
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)