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 |
What is asp net objects?
Explain < @OutputCache% > and the usage of VaryByParam, VaryByHeader ?
What is the answer for "Which configuration Tool your using means" ? we have to tell about IIS or .Net Framework or VSS? Give me in brief ?
What is personalization? What are the properties available in personalization?
Can we change the session timeout in ASP.NET, if yes then how and from where?
Define reflection in .net?
What is ashx file in asp.net?
What is the file through which you can customize your asp.net application?
in database table is thier . in that table fields are photoid , photoname,photo... i want display image in the gridview
What is the difference between file-based dependency and key-based dependency?
What is synchronous and Asynchronous post back ?
About Windows/Forms Authentication