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 long the items in ViewState exists?

0 Answers   SwanSoft Technologies,


Differentiate strong typing and weak typing

0 Answers  


What is difference between web api and web services?

0 Answers  


What is view state and how this can be done and was this there in asp ?

3 Answers   Accenture, BirlaSoft, CTS, Mphasis,


I have a datagrid of 10 rows and I am updating the fifth row using template column edit. How wil u know that the row is updated, so that it can be send to database for updating the respective table?

3 Answers  


Can we use MSSql as backend in asp.net...if yes then How.?

0 Answers   MCN Solutions,


Describe a Windows Service and its lifecycle ?

0 Answers   Siebel,


What is viewstate? What does the “enableviewstate” property do?

0 Answers  


Which of the following .NET framework supports Web API?

0 Answers  


How can you ensure a permanent cookie?

0 Answers  


What is DTS package?

2 Answers   Accenture, TCS,


Explain Features in ASP.NET

0 Answers   Microsoft,


Categories