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?
Mahesh ChandPosted May 6, 2011, 1:34 PM
So, you can either use Windows Forms or WPF to build the user interface (front-end application). You need SQL Server (standard is fine) for the back-end to store the data.
So, there are three parts to the learning process.
1. WPF or Windows Forms app
2. ADO.NET to connect to database
3. SQL Server - Create tables, stored procedures etc
Simplest way would be, first create your database and then use ADO.NET Entity Framework (search the site) that will build your application in no time.
This website has section on each of these technologies. Check out left side bar of the home page.
Good luck!
dcPosted May 7, 2011, 12:49 AM
ADO.NET Entity Framework or nHibernate. Whicbh one would you pick and how would yo9u use it?