1. I need to develop an application that updates data and searches for data about customer requests. This will be an internal application for my company. Here are what my options are so far:
1. I can use sql server reporting service 2008 r2 to display and search for the data. I also need to be able to insert rows in tables and update the data. In Sql server report 2008 r2, you can use the 'parameter' to call stored procedures to update the data in sql server 2008 r2 standard edition. (I think this method would be 'hard' for a new person to understand for maintenance reasons)
2. I can use sql server reporting service 2008 r2 to display and update the data. I could then include the sql server reporting service 2008 r2 feature in a C#.net application in a viewwer control. I could then update the data in sql server 2008 r2 using linq or some other part of the C#.net 2010 professional version of visual studio. (I think this method would be better to maintenance reasons.)
(I am askinng this question since I am part of a data analysis team and we can write C#.net code if there is a good reason for it)
Which way is better according to the best practices of Microsoft and can you tell me why it is better?
If you have other options than what I just mentioned, please let me know what those options are.