Geekzone: technology news, blogs, forums
Guest
Welcome Guest.
You haven't logged in yet. If you don't have an account you can register now.



86 posts

Master Geek
+1 received by user: 2


Topic # 25482 22-Aug-2008 16:22 Send private message


Hi Guys

I've decided to throw myself in the deep end and build a database system for family members who own kennels business. I had a access database for them that has been overhauled and converted to SQL now. Anyway the tables and links I think are alright.

I installed asp.net 3.5 SP1 and sql 2008 and managed to follow some basic instructions to get the tables showing in a web page that could edit, delete entries etc by using LINQ connections. So far basic.... Now stuck and the serious leaning kicks in (I have limited programming, sql knowledge).

I'm after advice on whether this is the easiest route to take? I am very keen to get into web developing hence why thought asp.net could be the way to go with a web application as that will give me some good knowledge.

I initially looked at access forms but is not really good enough and once the initial setup is done with customers, pets database want to branch out to include bookings (ie this customer booked this kennel for these days).

Any advice resources etc would be much appreciated.

Cheers

Create new topic
94 posts

Master Geek


  Reply # 162333 5-Sep-2008 00:08 Send private message

install and learn PHP. it's relatively quick and easy to pick up, and you'll find lots of tutorials, examples and help on the net.

here's a nice beginners tutorial: PHP Tutorial the mySQL tutorial on the same site will cover how PHP can be used in conjunction with a mySQL database.

Infrastructure Geek
3505 posts

Uber Geek
+1 received by user: 52

Trusted
Microsoft NZ
Subscriber

  Reply # 162336 5-Sep-2008 01:23 Send private message

Maybe you should take a look at a CRM, or open-source CRM system.  You can build an application to do the sort of things you want a lot easier and faster on top of an existing crm system.  Then there are also web and mobile client add-ons you can use with them too.  The bookings aspect, for example, could possibly work out-of-teh-box in the MS CRM product using the 'service calendar'.

There is also the option of using hosted CRM so it can paid for per-user, per-month and you dont have to worry about the infrastructure (servers, backups etc).




Infrastructure Technical Evangelist
Microsoft NZ
about.me/nzregs
twitter.com/nzregs




86 posts

Master Geek
+1 received by user: 2


  Reply # 162357 5-Sep-2008 08:29 Send private message


Thanks guys.

Both those options may be viable I'm a fair way down the track of building the system but if one of these options is going to save a lot of time down the track I'd seriously look at changing tact.

Know what the price is off hand for MS CRM?

Cheers

917 posts

Ultimate Geek
+1 received by user: 30


  Reply # 162402 5-Sep-2008 10:38 Send private message

KShips:
Thanks guys.

Both those options may be viable I'm a fair way down the track of building the system but if one of these options is going to save a lot of time down the track I'd seriously look at changing tact.

Know what the price is off hand for MS CRM?

Cheers

 

I would be looking at the PHP/MYSQL option - if you wanted to get straight into testing it download WAMP (free of course) its a programme that installs the stuff straight onto your computer.

PHP support is much easier to find the ASP due to being opensource..  As well as hosting being much more affordable on linux based servers where ASP support is not required!


Create new topic








Twitter »
Follow us to receive Twitter updates when new discussions are posted in our forums:



Follow us to receive Twitter updates when news items and blogs are posted in our frontpage:



Follow us to receive Twitter updates when new jobs are posted to our jobs board:



Follow us to receive Twitter updates when tech item prices are listed in our price comparison site:




News »

Trending now »
Hot discussions in our forums right now:

Forms of government for New Zealand
Created by charsleysa, last reply by sir1963 on 19-Apr-2014 20:52 (108 replies)
Pages... 6 7 8


MH370 - Call for Search & Rescue Help
Created by DS248, last reply by Sideface on 17-Apr-2014 17:28 (735 replies)
Pages... 47 48 49


galaxy s4 now on 4.4.2
Created by nzrock, last reply by Yabanize on 19-Apr-2014 21:59 (56 replies)
Pages... 2 3 4


why does the tax payer have to pay for the prince and princess' 6 star holiday?
Created by joker97, last reply by Geektastic on 17-Apr-2014 15:49 (67 replies)
Pages... 3 4 5


Paywave unauthorised transaction
Created by Ford, last reply by NonprayingMantis on 19-Apr-2014 22:06 (15 replies)

Whats the best wife friendly media centre?
Created by amorpeth, last reply by jonolynn on 19-Apr-2014 20:20 (14 replies)

Snap suffering Trans-Tasman congestion 18/04?
Created by Lias, last reply by NonprayingMantis on 19-Apr-2014 00:05 (26 replies)
Pages... 2


Help ! Home business connection and VDSL dead. yikes.
Created by Scotsman, last reply by Scotsman on 17-Apr-2014 21:10 (26 replies)
Pages... 2



Geekzone Live »
Try automatic live updates from Geekzone directly in your browser, without refreshing the page, with Geekzone Live now.

Are you subscribed to our RSS feed? You can download the latest headlines and summaries from our stories directly to your computer or smartphone by using a feed reader.

Alternatively, you can receive a daily email with Geekzone updates.