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
TomPosted Feb 12, 2008, 10:14 AM
RenuPosted Feb 12, 2008, 10:10 AM
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 LyslePosted Feb 11, 2008, 10:02 PM