I'm relatively new to C# and am learning about the various data containers out there in .Net 2.0. In my program I access a read only database and display the data to the user. I'm currently using a dataset since I need to hold the data, and from my knowledge a datareader is only good for one iteration.
I'm finding that my application is consuming a lot of RAM. What tools are there to determine what's consuming this RAM (e.g., the number of controls, the sql query, poor ui design)? Also, does anyone recommend anything other than a dataset?