C#.net updating sql server

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.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Sam Hobbs15y ago
It is best to define requirements first before designing a solution. I get the impresson that the requirements are not adequately defined. With inadequate requirements definitions, it would be easier to suggest an unproductive solution than a productive one. So I am concerned that if someone suggests something based on the information provided so far, you might in the future need to re-do a lot of what you do initially.