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

In a page I have gridview with options of select and delete using hyperlink when I am selecting any one of then it has to open another page how can it?

0 Answers  

---

Give 2 examples for scenarios when routing is not applied?

0 Answers   NA,

---

What is a WebService and what is the underlying protocol used in it? Namespace?

1 Answers  

---

How do you design a website with multilingual support in ASP.NET ?

0 Answers   MCN Solutions,

---

Explain difference between friend and protected friend?

0 Answers  

---

How to authenticate users using web.config ?

1 Answers   Patni,

---

Explain how can we inherit a static member?

0 Answers  

---

Why is this service branded with windows livetm?

0 Answers  

---

How do you bind array to gridview? Will it works?

4 Answers   HP,

---

What is the difference between and ActiveX dll and control ?

1 Answers   Microsoft,

---

How to automatically get the latest version of all the asp.net solution items from source safe when opening the solution?

0 Answers  

---

Define data caching?

0 Answers  

---