1. Categories >> Software >> Microsoft Related >> ASP.NET
  2. Suggest New Category

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

Question Posted / rameshp

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

What property is used on the datatable to indicate a conflict after an update? a) HasConflict b) HasError c) HasCollision d) HasDataError

1 Answers   Syntax Softtech,

Where web.config file is used?

0 Answers   HCL,

1.can we add connection string in global.asax?????????? 2.what are the default files included when we create new web application????

7 Answers   Sparsh,

What does the following SQL statement return, assuming that all tables and column names are correct? SELECT FirstName, StreetAddress FROM Employees JOIN AddressBook ON Employees.EmpID = AddressBook.EmpID a) Nothing, the JOIN syntax is wrong. b) All the records form the Employees table, and only the matching ones form the StreetAddress table. c) All the records from the StreetAddress table and only the matching records form the Employees table. d) Only the matching records from the two tables.

4 Answers   Syntax Softtech,

what is the MSIL assembler do?

1 Answers  




With example & diagram explain AutoPostBack.

2 Answers  

How can we pass info between 2 asp.net pages?

0 Answers  

What is pre-init event in ASP.NET 2.0 page life cycle?

2 Answers   Fulcrum Logic,

Explain what is viewstate?

0 Answers  

What is the good practice to implement validations in aspx page?

0 Answers  

what is cross page posting

3 Answers  

Distinguish between Server-side and Client-side code with its functionality?

0 Answers   Siebel,

For more ASP.NET Interview Questions Click Here
Categories