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.

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 asp.net is a programming language?

0 Answers  

---

What is the most appropriate lifetime for a database connection/orm context in an asp.net mvc application? : Asp.Net MVC

0 Answers  

---

What is the difference between stored procedure vs function?

0 Answers  

---

What are the difference between ASP and ASP.Net?

4 Answers   Accenture, Mphasis,

---

What is the other method, other than GET and POST, in ASP.NET?

3 Answers  

---

---

How to implement caching?

2 Answers   Infosys, Microsoft,

---

What is the relationship between IIS and ASP.NET in the generation of dynamic Web sites?

1 Answers  

---

What the use of Form Authentication and windows Authentication?

1 Answers   NetCity, TCS,

---

Define satellite assemblies.

0 Answers  

---

What are the differences between primary foreign and unique keys?

0 Answers  

---

Explain how cookies work.

0 Answers  

---

Describe briefly what is the role of IIS on an ASP.NET application? What does it for the same application?

0 Answers   InfoAxon Technologies,

---