Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Front End - Best Tools For Creating?

Author  Topic 

Parantaja
Starting Member

2 Posts

Posted - 2008-05-21 : 14:00:25
Clearly, I'm very new to this.

Does anyone have a favorite tool/system for creating a SQLServer front end?

I've been looking into this myself and seeing everything from Visual Basic to Access to ASP, from Web to Windows.

Here's my situation. I need to create a few simple tools for our office folks to use. For example, a tool that creates an invoice using data from two tables (Customers, Items).

I'd like to make it as simple as possible for them (ex. setting up an autocomplete for the customer name, etc.).

Please understand, I'm not looking for anyone to write code for me. I just want some feedback on what tools to use.

I would just use Access (since I am familiar with it), but we don't have it here. Sigh.

Any thoughts? Personal Preferences?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-05-21 : 15:05:55
I'd recommend VB.NET or C#. I would not recommend any of the older programming languages such as Visual Basic. Use what's current as you'll get more features, faster programming experience, easier deployment, ...

What is your current skill set in programming?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Database maintenance routines:
http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx
Go to Top of Page

Parantaja
Starting Member

2 Posts

Posted - 2008-05-21 : 15:35:46
Unfortunately, my current programming skillset is nearly nonexistant.

Pretty much all my experience is an Access, so unless you count an understanding of SQL. . .

I believe I have the capacity to learn, though, and appreciate your input.

I will check into your recommendations and see if I think I can adapt.

In the interim, I'll definitely remain open to additional input, opinions.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-05-21 : 15:42:45
The .NET languages are pretty easy to learn, especially VB.NET. I am not a programmer and was able to easily learn enough to write a monitoring application. There are plenty of resources on the Internet for the .NET languages that you wouldn't even need to purchase a book to learn.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Database maintenance routines:
http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx
Go to Top of Page
   

- Advertisement -