Data Containers for C#

[variaas]

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?

[kenobewan]

Welcome to TSDN. You may use the datareader to populate your datagrid instead of a dataset, which is heavier on resources. Unless your db is huge then I wouldn't expect a significant effect on ram. Maybe a looping or such problem in your code. I expect monitoring your ram during each process would sufficient to tell you where the problem is. HTH.