Which is best dataset or datatable

The Read function of the DataReader reads one row at a time in memory and if a row is read then the function returns True else False. DataReader requires an open connection in order to execute the SQL statement. ConnectionStrings[ "constr" ]. Open ;. ExecuteReader ;. ToString ;. Close ;. ConnectionStrings "constr". Using con As New SqlConnection constring. While dr. End While.

End Using. DataAdapter manages the connection internally and does not require to open or close connections explicitly and this feature is termed as Disconnected Architecture. NET Core application. This view shows DataSet name and iterates through tables collection calling DataTable view for every table. As it re-uses shared DataTable view it is small. Here it is. Here is the controller action that calls GetActiveCustomersReport shown method above and uses DataSet view to show results. Be warned!

It can be tempting to use this solution as a base for more advanced reporting and after first steps you are probably impressed how much it is possible to do with those common views. If we need to show simple dynamic reports in ASP. I have used this approach successfully in practice from ASP.

Gunnar Peipman is ASP. Posted Nov am Kschuler. Add your solution here. OK Paste as. Treat my content as plain text, not as HTML. Existing Members Sign in to your account. This email is in use. Do you need your password? Submit your solution! When answering a question please: Read the question carefully. Understand that English isn't everyone's first language so be lenient of bad spelling and grammar. If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem.

Insults are not welcome. Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid. Related Questions. Collectives on Stack Overflow. Learn more. Datatable vs Dataset Ask Question. Asked 13 years, 3 months ago. Active 10 months ago. Viewed k times. I currently use a DataTable to get results from a database which I can use in my code. Improve this question. Hossein Narimani Rad GateKiller GateKiller If you're working with web apps, you may want to consider using a DataReader: aspnet.

You should not bake them your primary data metaphor these days. MarcGravell What would you suggest as a primary data metaphor these days? Add a comment. Active Oldest Votes.