What is the best data structure / data type for my task?

Question

I'm about to create an application in C# which will need to read data from a SQL database. Once the application has retrieved the data it will need to search according to an ID field (integer) and then check different fields against that key, e.g. "find LDESC and STATUS where ID = 42". I will also want to add an extra column (bit) so that I can mark against each record a True or False according to some condition. There would be no need to update the database from where the data came.

What would be the best data structure for this? Should I use a DataTable or a DataReader? Or would it be better to take the data and put it into a Hashtable or other array style data type?

Thanks, Tom

Tom · Answer

It was helpful thanks very much to both of you Tom

Renu · Answer

I guess you can even use a Data table. A datatable has a select method where in you can specify your filter and this will return a array of rows. I hope this was help ful. Thanks

Scott Lysle · Answer

A datareader would not do for what you have described; you might want to take a look at the dataset.