May 6, 2009 at 6:24 am
Hello,
I have been using SQL Server for a few years. I have used SQL 2000, 2005, and now 2008. I am not a DBA or a serious programmer. I do create lots of tables, view, queries, and stored procedures in SQL. Right now my end users are using a Microsoft Access database that is linked to SQL Server. Through Access they open views, input data, and run stored procedures.
I'm looking for a better way to build a user interface. Ideally I'd prefer a web based interface. My company is willing to send me to a few training classes for this as well. I had done some searching already on this forum. I came up with some posts that were a few years old which recommended Macromedia Dreamweaver. I was wondering if that is still the recommended tool? What other programs or software suites can do this? My users would need to be able to input data, not just view it. They also need to be able to click a button that would call a stored procedure on the server.
thank you
May 6, 2009 at 7:45 am
If your users just need to read data then maybe all you need are some reports written through SQL Server Reporting Services. These can be fed through the web and you can provide select lists for parameters and several other types of behavior, all without extensive programming.
However, if you really need to build user interfaces, personally I'd recommend getting into .NET or possibly SilverLight, both Microsoft products. However, both have a reasonably steep learning curve.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 6, 2009 at 7:54 am
I agree with Grant and I would recommend Microsoft Visual Studio. I would pick VB over C#. You probably would find that a bit easier to learn, but there's nothing wrong with C#. Some people would pick C# before VB.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
May 6, 2009 at 8:24 am
Alvin Ramard (5/6/2009)
I agree with Grant and I would recommend Microsoft Visual Studio. I would pick VB over C#. You probably would find that a bit easier to learn, but there's nothing wrong with C#. Some people would pick C# before VB.
I agree with Alvin regarding Visual Studio, but I like C# over VB.
Tastes Great... Less Filling...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 6, 2009 at 8:31 am
Grant Fritchey (5/6/2009)
Alvin Ramard (5/6/2009)
I agree with Grant and I would recommend Microsoft Visual Studio. I would pick VB over C#. You probably would find that a bit easier to learn, but there's nothing wrong with C#. Some people would pick C# before VB.I agree with Alvin regarding Visual Studio, but I like C# over VB.
Tastes Great... Less Filling...
Maybe I wasn't 100% honest. One of my reasons for picking VB is that it's what I know. I was thinking of learning C# but I get paid for working with SQL Server, not .NET development, so there's not a big incentive for learning C#.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
May 6, 2009 at 9:13 am
If you know some VB, VB.NET is easier, but it's still a paradigm change.
I'd go take a couple short online classes for VB.NET and C#. Invest a few hours, see which one makes you more comfortable.
SSRS can call stored procedures, and take some basic input. ASP.NET would let you build some easy pages to do simple things as wekk.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply