Advantage of data Reader?
Answers were Sorted based on User's Feedback
Answer / o p yadav
To highlight the advantages of using a DataReader over the
DataSet, here’s an example of using a DataSet. The following
fills a DataSet with the results from a table, and outputs
the first field in each row:
Code=
SqlConnection conn = new SqlConnection(connectionString);
SqlDataAdapter a = new SqlDataAdapter
("select * from mytable;",conn);
DataSet s = new DataSet();
a.Fill(s);
foreach (DataRow dr in s.Tables[0].Rows)
{
Console.WriteLine(dr[0].ToString());
}
As you can see, we don’t actually start the actual
inspection of data (the foreach loop), until the whole
DataSet has been filled. There may be occasions where we may
not use all our results, or we might execute other code
while inspecting (a progress bar’s progress is a trivial
example). Using a DataSet, this can only take place after
the complete results are fetched and passed into the various
collections within the DataSet.
| Is This Answer Correct ? | 3 Yes | 2 No |
Answer / athira
The datareader object allows users to read and output each
column of a multi-column asci file (up to 64 columns)
through a separate outlet. Each line can be output
sequentially, forward or backward, or by indicating a
specific line number. The object also includes simple
interpolation and smoothing between lines
| Is This Answer Correct ? | 0 Yes | 1 No |
List of interview questions collections at www.dpoint.weebly.com
Are xaml file compiled or built on runtime?
What is caching? What are different ways of caching in asp.net?
Define session in asp.net.
What are sql joins?
What is the Web.config file used for? a) To store the global information and variable definition for the application. b) Configures the time that the server-side codebehind module is called c) To Configure the Web Server. d) To Configure the Web browser.
8 Answers HCL, IBM, Syntax Softtech, Vypin, WideVision Technologies,
How can we Validate a Controls in ASP.NET page using JavaScript?
What are the advantages of the code-behind feature?
What is the use of worker process in asp.net?
How can you debug your.net application?
How much data (Max K) can go into a QueryString?
can i use two web.config files of ConnectionString in One Default.aspx page
6 Answers Satyam, Verinon Technology Solutions, Wipro,
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)