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 |
Where do you store the information about the user?s locale?
define silverlight and advantages ?
hi i have a problem regarding to datagrid in aspdotnet.i have a datagrid in my application.i have to place add,edit,delete buttons or links what ever it may be. now the problem is if i click on add button then the page has to redirected to another form called "xyz.aspx" and if i click on edit button the page has to redirected to another form called "abc.aspx".i am phasing the problem that if where ever i click on the datagrid the cursor goes to gv1_SelectedIndexChanged event.please tell me the solution about the code.
Distinguish between Server-side and Client-side code?
what is differences between bind and eval?
How do you secure your configuration files to be accessed remotely by unauthorized users?
How can you get public key information?
web user and custom conrols
witch is the best insistute in sharpoint course.what abt future of share point course.
What?s the difference between Codebehind="MyCode.aspx.cs" and Src="MyCode.aspx.cs"?
1 Answers Getit, Siebel, Visual Soft,
What is Partial in ASP.NET 2.0?
Explain the main function of razor in asp.net? : asp.net mvc
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)