Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


Advantage of data Reader?

Answers were Sorted based on User's Feedback



Advantage of data Reader?..

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

Advantage of data Reader?..

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

Post New Answer

More ASP.NET Interview Questions

What is cookie less session? How it works?

2 Answers   TCS,


How can u deifne the benefits and limitation of using Viewstate for state management?

0 Answers   QuestPond,


Differentiate between Server.Transfer and Response.Redirect with functionality? Why we can choose one over the other?

0 Answers   Siebel,


How can you ensure a permanent cookie?

0 Answers  


What is _viewstart?

0 Answers  


Explain what are the advantages of asp.net mvc framework? : asp.net mvc

0 Answers  


What tags do you need to add within the asp:datagrid tags to bind columns manually? Give an example.

0 Answers  


What is the main differences between asp and asp.net?

0 Answers  


what exception is thrown when you do a response.redirect

2 Answers   IBM,


Tell about WebService in Asp.Net?

5 Answers   Accenture, CTS,


how we can solve machine key error in asp.net?

3 Answers  


5. What three Specific Job Positions do you target from Swatz Oils GROUP U.K?

0 Answers   Swatz Oils,


Categories