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 applicationmust 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?