Dataset Question

In general, it's best to let garbage collection take care of cleaning up managed objects. The exception is objects which hold scarce resources (e.g., database connections, file handles, GDI objects, etc.); in that case, you should call Close or Dispose as soon as you're done with them. Datasets do not maintain a connection to the database, so it's fine to let .NET clean them up automatically.