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 is the purpose of asp.net?

0 Answers  

can we store textbox and com components in viewstate?

4 Answers   Microsoft,

How does VB.NET/C# achieve polymorphism?

6 Answers   Siebel Systems,

What is preprocessor in .net? Where it use?

0 Answers  

What object is used to encapsulate a rowset? a) DataSet b) DataAdapter c) DataRowSet d) DataTable

2 Answers   Syntax Softtech,




How can we use Web API with ASP.NET Web Form?

0 Answers  

What does postback mean?

0 Answers  

what is differences between bind and eval?

2 Answers  

You are planning the deployment of an ASP.NET application. The application uses a Visual Studio .NET component named DataAccess that will be shared with other applications on your Web server. You are using Visual Studio .NET to create a Windows Installer package. You need to deploy DataAccess and the ASP.NET application so that they can be uninstalled later of necessary. What should you do? A . Create a setup project for DataAccess. Add the ASP.NET application in a custom action. B . Create a setup project for the ASP.NET application. Create another setup project for DataAccess. C . Create a Web setup project for the ASP.NET application. Add a project output for DataAccess. D . Create a Web setup project for the ASP.NET application. Add a merge module for DataAccess.

3 Answers   Syntax Softtech,

What is the full meaning of asp.net?

0 Answers  

Whats an assembly?

6 Answers   Siebel Systems,

How do sessions work?

0 Answers  

For more ASP.NET Interview Questions Click Here
Categories