Click here to Skip to main content
12,953,230 members (86,591 online)
Rate this:
Please Sign up or sign in to vote.
See more:

I am developing a Desktop Application,
It is a shop management system.

I want to know which new Item i need to store data of that application.
I mean i don't want to install SQL in my customer PC. this is my first live project for my first customer i just want to give him a application Setup to install the application in his system so how can i use database in this case.

Thank You
Posted 11-Nov-12 4:28am
Nelek 11-Nov-12 10:32am
Do you know how much data volumen will be involve in that application? There could be alternative ways with serialization and exporting/importing to archive files that you generate from the application. But if the data volumen is big, then it is not a good idea 11-Nov-12 10:39am
i want to do this because i want to but this on sell too that y it is good idea

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

If you are only looking at single user systems, then have a look at SqlCE or SqLite - they are both SQL compliant database (with some restrictions) which are designed for a single user environment and do not require SQL Server. You could also look at an Access based solution.

If you are looking at stock management and so on, then a database solution is better than serialization or XML files, as the whole file does not have to be re-written to insert or remove an item.

If you are looking at multiple users, then I would strongly suggest that an MsSql or MySql solution is the best way to go despite the installation problems - they make working with all the major pitfalls of simultaneous updates very, very easy (as they handle all that for you). Multi user working with your own files is a real PITA!

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

    Print Answers RSS
Top Experts
Last 24hrsThis month
OriginalGriff 6,429
CHill60 3,490
Maciej Los 3,103
Jochen Arndt 1,975
ppolymorphe 1,920

Advertise | Privacy | Mobile
Web01 | 2.8.170525.1 | Last Updated 11 Nov 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100