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

If you have an application with multiple security levels though secure login and my ASP.NET web appplication is spanned across three web-servers by using round-robbin load balancing. Explain which is the best approach to maintain login-in state for the users?

0 Answers   Siebel,


When maintaining session through sql server, what is the impact of read and write operation on session objects?

0 Answers  


Do you know caching feature?

0 Answers  


What is a web pool?

0 Answers  


what is code access security,role based security explain with example

1 Answers   Infosys,


Can you dynamically assign a Master Page?

0 Answers   MCN Solutions,


Where sessions are stored in asp.net?

0 Answers  


You need to be able to retrieve data from DataSet object that has four DataTable objects. There are currently UniqueConstraint and ForeignKeyConstraint Object on the DataTable objects to enforce the data rules. You find that you can retrieve the data from the individual DataTable objects, but you are not able to retrieve the data from the combination of DataTable objects in a Parent/Child manner. What should you do to able to retrieve the data in a Parent/Child manner? a) Set the EnforceParentChild parameter of the DataSet to True. b) Set the EnforceRelation parameter of the Relations collection to True. c) Add DataRelation objects to the Relations Collection to make the DataSet present the data in Parent/Child manner. d) Add a primary key and a foreign key to each of the DataTable objects that should present the data in a Parent/Child manner.

1 Answers   Syntax Softtech,


How many web.config a application can have ?

6 Answers   Keane India Ltd, Manhattan, Vertex,


What is the server of asp.net?

0 Answers  


Explain the differences between managed and unmanaged code?

0 Answers  


How many web.copnfig can exists in a web application & which will be used ?

3 Answers   MMTS,


Categories