If a table contains 20000 records . In a page at each time 100 records to be displayed what are the steps you will take to improve performance? Will you use dataset or datareader?
No Answer is Posted For this Question
Be the First to Post Answer
What is the default Timeout for SqlCommand.CommandTimeout property?
If a table contains 20000 records . In a page at each time 100 records to be displayed. What are the steps u will take to improve performance? will you use dataset or datareader?
Explain the difference between data reader and data set?
Explain all the classes those are used for database connections between sql server and asp.net?
What is ado in agriculture?
Which property is used to check whether a DataReader is closed or opened?
Explain the DataAdapter.Update() and DataSetAcceptChanges() methods.
Explain how to bind the controls(best practice) comboboxes to the data in the dataset?
How to generate XML from a dataset and vice versa?
What is the difference between SqlCommand and SqlCommandBuilder?
Why edit is not possible in repeater?
What is ado.net connection?
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)