ASP.NET DataReader vs. DataSet

home
asp.net
view story

1 Kicks

ASP.NET DataReader vs. DataSet(weblogs.asp.net)

submitted by wisemx(8074) 4 years ago

I've recently renewed my effort to "use the right tool for the job" when developing xhtml and CSS, which got me to thinking. If using a <ul> rather than a <div> is better in a certain application, are there better ASP.NET tools for other jobs? With that mindset I came across a task that required connecting to one of our databases. Rather than building a DAL (and no, I'm not LINQified yet) I decided to just grab the data though a SqlConnection and go from there. So far so good. I then was faced with how to "deal" with the stuff returned from the SqlCommand. Here ASP.NET has a couple controls that do can read the data from your SqlCommand: DataReader and DataSet. But which to use?

add a comment |category: ASP.NET |Views: 9
Tweet