I am wondering if I can accomplish all and/or any of the following parts using C#.net 2008 or C#.net 2010 and/or sql server reporting service 2008 R2:
Take various company notes and directives and put them into a database table then be
able to search the data for keywords. The sql and/or ssrs 2008 r2 and/or the C#.net application
must be able to do the following:
a. Put all this data in one sql server 2008 r2 table,
b. Have a method to input new rows of data,
c. Have a method to search the existing data based on keywords.
Thus can you tell me the following:
a. For the search,
1. Are there any new lookup methods I can use in sql server 2008 r2, and/or
2. Would I a 'like' statemnt in t-sql, and/or
3. Can I accomplish this in some way using ssrs 2008 r2 standard edition, and/or
4. Would I need a .net application?
For the items listed above, can you point me to a url to accomplish this tasks?
b. For the whole process, can you tell me what would be the best way to accomplish this process?