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.
| Author |
Topic |
|
token
Posting Yak Master
133 Posts |
 Posted - 2006-01-31 : 17:51:14
|
| Hi all,I hope this is the correct place to post my question. If not, please accept my apologies.I thought it was easy to set-up an online business, but I have found it difficult to administer once I actually got into making the databases to hold information on products I want to sell.I just wanted to know if I have finally found the "correct" way of working. After one has created an SQL database, are they then expected to create a front-end in Visual Basic in order to enter and retreive data easily? I know you can enter and retreive data with SQL statements, but that is a time consuming task which normal daily users cannot work with.The other option is to create the front-end as a webpage, and use a scripting language to perform the SQL statements needed to add/delete/modify records.Which way is the correct way to proceed? I am assuming that poeple like Amazon and other businesses use a Visual Basic developed front-end and then upload their databases to the web server?Thanks for your help in advance! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-01-31 : 18:01:17
|
| A database is used to store data, plain and simple. The tools that come with it are not intended for end-users, which would be your customers. Those tools are intended for DBAs, developers, etc...For your end-users, you will need to write a front-end application. This front-end can be Visual Basic, ASP.NET, C#, ... It just depends what language you are comfortable with and also what meets your requirements.Tara Kizeraka tduggan |
 |
|
|
token
Posting Yak Master
133 Posts |
Posted - 2006-01-31 : 18:06:47
|
| Well there are two types of users:1) Staff who will update data on the database. They are not DBAs. So they need a GUI to enter/retrieve product data.2) End-users who interact with the website. This area has been dealt with.So my problem is how to create the GUI for the staff. Is the default way to use Visual Basic or is there some other way that is better? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-01-31 : 18:10:01
|
| Visual Basic is just one such programming language that can be used to create a front-end application. Pick whatever language you are comfortable with. A lot of people prefer C#. I prefer VB.NET.Tara Kizeraka tduggan |
|
|
|
token
Posting Yak Master
133 Posts |
Posted - 2006-01-31 : 19:18:30
|
| I am not familiar with C# or VB.NET but I was under the impression they are scripting languages like ASP and PHP?Can you create a stand-alone application with those languages? I was also wondering if I could make a stand-alone application in Macromedia Flash? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-01-31 : 19:24:44
|
| They are not scripting languages. Yes you can create stand-alone applications with these. I seriously doubt Macromedia Flash would work.Tara Kizeraka tduggan |
|
|
|
|
|
|
|
|
making an application with SQL Server