Use DataSet over DataTable

  • Thread starter Thread starter Michael
  • Start date Start date
M

Michael

Is there ever any reason to use a DataSet over a DataTable, if I will only
be working with one sql server table throughout my system?

Thanks,
--Michael
 
It really depends on your needs...but the first thing that comes to mind is
a request a month from now that involves another table. Then you'd have to
create a dataset, change your logic etc. Either way you'd have some coding
to do, but things tend to grow...

Another thing is that Datasets allow you to write them to XML with their
respective diffgram in place...so if your connection fails and you can't
update a record (or anything else that stops you from updating) you could
write things to XML and pull them back in at a later time.

However, if you are definitely only ever going to work with one table, and
you don't need any failover support, AFAIK, you shouldn't have any issues.
 
Back
Top