In c#.Net Application For DataGridview binding which method is faster in below two case?Why..?
1)looping-Using For loop
2)Databinding direct using Dataset
Answers were Sorted based on User's Feedback
Answer / velmahesh
Answer is , Databinding direct using Dataset..
Reason for if we store database values to dataset. then
values are binding shortly..
but, if use the for loop, that statement will execute
upto limit. so, it will take some seconds..
| Is This Answer Correct ? | 9 Yes | 2 No |
Answer / shir
Using for loop is faster since the data will be populated as
soon as it is read using the data reader which is one way
read only process.
But when data set is used,
1. It internally makes use of the data reader in order to
populate the data set.
2. It takes huge amount of data enire amount of which might
not be required.
3. Later we will have to iterate throught DS to fill the
data grid
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / hardit
if we are using " reader " in data retrieving ,it will be faster as it will only read values required.
but in the case of dataset which is a very heavy object it will take more time corresponding to reader in for loop.
| Is This Answer Correct ? | 0 Yes | 4 No |
How to implement singleton design pattern in c#?
What are the benefits of using the aggregate method in linq?
Why do you need boxing in c#?
How to install or uninstall a windows service?
What are the different ways of method can be overloaded?
In .NET which is the smallest unit of execution?
Define encapsulation?
What is func delegate in c#?
What is architecture of your poroject? how i c an say?
2 Answers Eminosoft, HCL, Phoenix Technologies,
How do I join one form to another in c#?
In c#, what will happen if you do not explicitly provide a constructor for a class?
Explain get and set accessor properties?
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)