Where to store huge number of strings

Question

Hi,


I want to store some thousand (1000+) strings to use them in my program. I dont want to use database. What are the options available for me?
1. Resource files
2. Array
3. Hash tables
4. XML file
5. Any other
Plase let me know.

Answer 1

If you are using sql server, all you have to do is, have a table variable with rows with all the required dates in that table.

The select from that table and left outer join (or cross join) with attendance table, you get the all the dates and null next to dates where there is no data.

Answer 2

Hi,<br><br> Please find the relative solution in sql-<br> http://marlonribunal.com/finding-gaps-in-or-missing-dates-using-tsql/<br><br> Also have a look at below threads for something similar done with linq-<br> http://stackoverflow.com/questions/1468637/filling-in-missing-dates-using-a-linq-group-by-date-query<br> http://stackoverflow.com/questions/35062144/find-missing-date-in-listdatetime-and-insert-that-date-on-the-right-index