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