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 |
|
smwcollins
Starting Member
3 Posts |
 Posted - 2008-10-14 : 01:30:03
|
| Hello there!!I need some advise, im a complete novice to SQL and am needing to create a fairly simple database with 3 main parameters (i.e. first column type of account, second column reason for cancellation) with a third column giving the outcome (i.e. how to cancel based on the two previously defined reasons) The first parameter will have 6 types of account and the reasons will be over 30 and the outcome say 7 different. i realize when creating the database for each type of account i will need to define a reason and an outcome for each specific reason. I also will make a simple UI so the user will select an account, thus giving the only reasons to that type of account and the outcome based on the previous reason. Please could you give anyadvise on 1) best way to create such a database 2) how to create a UI that would allow the type of account selected to filter the relevant reasons/outcome specific to the type of account 3) any resources/ learning info relating to this question. If you have any questions regarding my enquiry let me know, i appricite the terms used etc. may leave a lot to be desired :))) Many many thanks for your anticipated reply, as a complete amature the resources that are available through forum's like this are a credit to those who run them! You legends!! Tony |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-14 : 01:35:32
|
| the UI needs to be done using some application languages like C#,VB,.. while the databse can be made in SQL Server. |
 |
|
|
smwcollins
Starting Member
3 Posts |
Posted - 2008-10-14 : 01:59:21
|
| Cheers for reply!!OK so create the DB using SQL then would the specific requests from the DB be 'woven' into the script for the UI OR when the user would select an account, for example, would SQL automatically request the data for the reason and when reason selected the outcome also? Im thinking of having two tabs for the selectors then a text box for displaying the outcome.Thanks Tony |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-14 : 02:07:32
|
quote:
Originally posted by smwcollins
Cheers for reply!!OK so create the DB using SQL then would the specific requests from the DB be 'woven' into the script for the UI OR when the user would select an account, for example, would SQL automatically request the data for the reason and when reason selected the outcome also? Im thinking of having two tabs for the selectors then a text box for displaying the outcome.Thanks Tony
yup. create db. then create webfrms usng VB ASP or ASP.NET. then pass from form selected value of account to db as a parameter and write a procedure in sql which receives parameter and returns the data from tables which will be displayed in your front end . |
|
|
|
smwcollins
Starting Member
3 Posts |
Posted - 2008-10-14 : 02:21:02
|
| Again thanks for the prompt reply!!i think i know where to start now, best of luck and success with everything you do :)))Tony |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-14 : 02:28:58
|
quote:
Originally posted by smwcollins
Again thanks for the prompt reply!!i think i know where to start now, best of luck and success with everything you do :)))Tony
Thanks and you're always welcome :)Let us know if you've any more doubts |
|
|
|
osirisa
Constraint Violating Yak Guru
289 Posts |
Posted - 2008-10-15 : 11:50:38
|
| Dim GUID GUID = System.Guid.NewGuid().ToString() |
|
|
|
|
|
|
|
|
How to create a simple database with UI?