Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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



I am using SQLServer 2005. I have one table called Drivers. Every day thousands of records will be..

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

I am using SQLServer 2005. I have one table called Drivers. Every day thousands of records will be..

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

I am using SQLServer 2005. I have one table called Drivers. Every day thousands of records will be..

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

I am using SQLServer 2005. I have one table called Drivers. Every day thousands of records will be..

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

I am using SQLServer 2005. I have one table called Drivers. Every day thousands of records will be..

Answer / sunny

use databse triggers

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More ASP.NET Interview Questions

How do you sign out from forms authentication?

0 Answers   MCN Solutions,


How many web.config a application can have ?

6 Answers   Keane India Ltd, Manhattan, Vertex,


What are type/key pairs in client script registration?

0 Answers  


AJAX - explain the concept and some controls like update panel, tabcontrol etc

2 Answers   Syntel,


Explain the differences between Server-side and Client-side code?

3 Answers  


How to add DateTime Control in normal DataGrid Server Control?

0 Answers  


What is asp.net caching?

0 Answers  


What Is ASPNET_WP.exe? What Is The Use Of It? In Which Place Inproc Session Stored ? Explain Session State ?

2 Answers   Phoenix Technologies,


What are different templates available in Repeater,DataList and Datagrid ?

1 Answers  


How to write unmanaged code and how to identify whether the code is managed / unmanaged ?

2 Answers   Accenture, BirlaSoft, Cogtest,


How do we get only edited/deleted/inserted records from a Dataset?

1 Answers   Syntax Softtech,


Asp pages that worked pefectly on windows 2000 server and iis 5.0 do not work on windows 2003 server with iis 6.0. Asp.net pages work fine. Why?

0 Answers  


Categories