I will be making a windows app that will run on user's local machines.
It will not be in a networked environment or anything like that which
rules out SQL Server for the database. I am trying to come up with the
best method to store data on the local user machine.
I was thinking of using XML files, but I am concerned about how
quickly the xml files will grow and should I have a seperate XML file
for each table?
Here's a run down of what this program will do :
Users will put a CD in their cd-rom drive, the app will read all the
folder/filenames off the cd and allow them to attach additional
keywords to each folder/filename, then they will give each CD a unique
name and label the CD with this name. Then when they want to search
for a program they will run the app and search for keywords and the
app will tell them which cd to look on.
Hope this is descriptive enough. I was thinking of using MSDE, but
this would require it be running on the user's machine at all times
which I don't like the idea of. That's why I came up with the solution
of XML files but the XML filesize can quickly grow... 100 files per cd
times about 200 cd's average, that's 20,000 records right there, not
too mention the extra keywords for each record that might be added.
Maybe a flatfile would work better?
Any advice/pointers would be appreciated.
Thank you! 7 3105
Hello
You can use Access or sqlite, or any file base database engine.
sqlite is available at http://www.sqlite.com
and the ADO.NET provider for sqlite is available at http://sourceforge.net/projects/adodotnetsqlite/
sqlite is open source and cross-platform. It can run on linux, windows, etc.
So in case you would like to migrate your application one day to other
operating systems, you should use a portable format for database.
Access wil do the job perfectly too, and the .NET framework supports it
without downloading any libraries.
Best regards,
Sherif
"DKode" <dk***@cfl.rr.com> wrote in message
news:b1*************************@posting.google.co m... I will be making a windows app that will run on user's local machines. It will not be in a networked environment or anything like that which rules out SQL Server for the database. I am trying to come up with the best method to store data on the local user machine.
I was thinking of using XML files, but I am concerned about how quickly the xml files will grow and should I have a seperate XML file for each table?
Here's a run down of what this program will do :
Users will put a CD in their cd-rom drive, the app will read all the folder/filenames off the cd and allow them to attach additional keywords to each folder/filename, then they will give each CD a unique name and label the CD with this name. Then when they want to search for a program they will run the app and search for keywords and the app will tell them which cd to look on.
Hope this is descriptive enough. I was thinking of using MSDE, but this would require it be running on the user's machine at all times which I don't like the idea of. That's why I came up with the solution of XML files but the XML filesize can quickly grow... 100 files per cd times about 200 cd's average, that's 20,000 records right there, not too mention the extra keywords for each record that might be added. Maybe a flatfile would work better?
Any advice/pointers would be appreciated.
Thank you!
You could also use MS SQL Desktop Edition. http://msdn.microsoft.com/SQL/MSDE/default.aspx
I would recommend reading this: http://msdn.microsoft.com/library/de...sderoadmap.asp
"Sherif ElMetainy" <el*************@wayout.net.NOSPAM> wrote in message
news:eX**************@tk2msftngp13.phx.gbl... Hello
You can use Access or sqlite, or any file base database engine.
sqlite is available at http://www.sqlite.com and the ADO.NET provider for sqlite is available at http://sourceforge.net/projects/adodotnetsqlite/ sqlite is open source and cross-platform. It can run on linux, windows,
etc. So in case you would like to migrate your application one day to other operating systems, you should use a portable format for database.
Access wil do the job perfectly too, and the .NET framework supports it without downloading any libraries.
Best regards, Sherif
"DKode" <dk***@cfl.rr.com> wrote in message news:b1*************************@posting.google.co m... I will be making a windows app that will run on user's local machines. It will not be in a networked environment or anything like that which rules out SQL Server for the database. I am trying to come up with the best method to store data on the local user machine.
I was thinking of using XML files, but I am concerned about how quickly the xml files will grow and should I have a seperate XML file for each table?
Here's a run down of what this program will do :
Users will put a CD in their cd-rom drive, the app will read all the folder/filenames off the cd and allow them to attach additional keywords to each folder/filename, then they will give each CD a unique name and label the CD with this name. Then when they want to search for a program they will run the app and search for keywords and the app will tell them which cd to look on.
Hope this is descriptive enough. I was thinking of using MSDE, but this would require it be running on the user's machine at all times which I don't like the idea of. That's why I came up with the solution of XML files but the XML filesize can quickly grow... 100 files per cd times about 200 cd's average, that's 20,000 records right there, not too mention the extra keywords for each record that might be added. Maybe a flatfile would work better?
Any advice/pointers would be appreciated.
Thank you!
Hello
You can use Access or sqlite, or any file base database engine.
sqlite is available at http://www.sqlite.com
and the ADO.NET provider for sqlite is available at http://sourceforge.net/projects/adodotnetsqlite/
sqlite is open source and cross-platform. It can run on linux, windows, etc.
So in case you would like to migrate your application one day to other
operating systems, you should use a portable format for database.
Access wil do the job perfectly too, and the .NET framework supports it
without downloading any libraries.
Best regards,
Sherif
"DKode" <dk***@cfl.rr.com> wrote in message
news:b1*************************@posting.google.co m... I will be making a windows app that will run on user's local machines. It will not be in a networked environment or anything like that which rules out SQL Server for the database. I am trying to come up with the best method to store data on the local user machine.
I was thinking of using XML files, but I am concerned about how quickly the xml files will grow and should I have a seperate XML file for each table?
Here's a run down of what this program will do :
Users will put a CD in their cd-rom drive, the app will read all the folder/filenames off the cd and allow them to attach additional keywords to each folder/filename, then they will give each CD a unique name and label the CD with this name. Then when they want to search for a program they will run the app and search for keywords and the app will tell them which cd to look on.
Hope this is descriptive enough. I was thinking of using MSDE, but this would require it be running on the user's machine at all times which I don't like the idea of. That's why I came up with the solution of XML files but the XML filesize can quickly grow... 100 files per cd times about 200 cd's average, that's 20,000 records right there, not too mention the extra keywords for each record that might be added. Maybe a flatfile would work better?
Any advice/pointers would be appreciated.
Thank you!
You could also use MS SQL Desktop Edition. http://msdn.microsoft.com/SQL/MSDE/default.aspx
I would recommend reading this: http://msdn.microsoft.com/library/de...sderoadmap.asp
"Sherif ElMetainy" <el*************@wayout.net.NOSPAM> wrote in message
news:eX**************@tk2msftngp13.phx.gbl... Hello
You can use Access or sqlite, or any file base database engine.
sqlite is available at http://www.sqlite.com and the ADO.NET provider for sqlite is available at http://sourceforge.net/projects/adodotnetsqlite/ sqlite is open source and cross-platform. It can run on linux, windows,
etc. So in case you would like to migrate your application one day to other operating systems, you should use a portable format for database.
Access wil do the job perfectly too, and the .NET framework supports it without downloading any libraries.
Best regards, Sherif
"DKode" <dk***@cfl.rr.com> wrote in message news:b1*************************@posting.google.co m... I will be making a windows app that will run on user's local machines. It will not be in a networked environment or anything like that which rules out SQL Server for the database. I am trying to come up with the best method to store data on the local user machine.
I was thinking of using XML files, but I am concerned about how quickly the xml files will grow and should I have a seperate XML file for each table?
Here's a run down of what this program will do :
Users will put a CD in their cd-rom drive, the app will read all the folder/filenames off the cd and allow them to attach additional keywords to each folder/filename, then they will give each CD a unique name and label the CD with this name. Then when they want to search for a program they will run the app and search for keywords and the app will tell them which cd to look on.
Hope this is descriptive enough. I was thinking of using MSDE, but this would require it be running on the user's machine at all times which I don't like the idea of. That's why I came up with the solution of XML files but the XML filesize can quickly grow... 100 files per cd times about 200 cd's average, that's 20,000 records right there, not too mention the extra keywords for each record that might be added. Maybe a flatfile would work better?
Any advice/pointers would be appreciated.
Thank you!
Thanks!
I have used access in the past before with some of my csharp
applications at a telemarketing firm and found it very easy to connect
to the db in a sql server type manner etc... I figured there would be
some new web service/xml cool method of going about doing this, but I
guess that stuff only applies to online applications/ applications
connected via a network...not stand alone apps. am i correct on this?
"Sherif ElMetainy" <el*************@wayout.net.NOSPAM> wrote in message news:<eX**************@tk2msftngp13.phx.gbl>... Hello
You can use Access or sqlite, or any file base database engine.
sqlite is available at http://www.sqlite.com and the ADO.NET provider for sqlite is available at http://sourceforge.net/projects/adodotnetsqlite/ sqlite is open source and cross-platform. It can run on linux, windows, etc. So in case you would like to migrate your application one day to other operating systems, you should use a portable format for database.
Access wil do the job perfectly too, and the .NET framework supports it without downloading any libraries.
Best regards, Sherif
"DKode" <dk***@cfl.rr.com> wrote in message news:b1*************************@posting.google.co m... I will be making a windows app that will run on user's local machines. It will not be in a networked environment or anything like that which rules out SQL Server for the database. I am trying to come up with the best method to store data on the local user machine.
I was thinking of using XML files, but I am concerned about how quickly the xml files will grow and should I have a seperate XML file for each table?
Here's a run down of what this program will do :
Users will put a CD in their cd-rom drive, the app will read all the folder/filenames off the cd and allow them to attach additional keywords to each folder/filename, then they will give each CD a unique name and label the CD with this name. Then when they want to search for a program they will run the app and search for keywords and the app will tell them which cd to look on.
Hope this is descriptive enough. I was thinking of using MSDE, but this would require it be running on the user's machine at all times which I don't like the idea of. That's why I came up with the solution of XML files but the XML filesize can quickly grow... 100 files per cd times about 200 cd's average, that's 20,000 records right there, not too mention the extra keywords for each record that might be added. Maybe a flatfile would work better?
Any advice/pointers would be appreciated.
Thank you!
Thanks!
I have used access in the past before with some of my csharp
applications at a telemarketing firm and found it very easy to connect
to the db in a sql server type manner etc... I figured there would be
some new web service/xml cool method of going about doing this, but I
guess that stuff only applies to online applications/ applications
connected via a network...not stand alone apps. am i correct on this?
"Sherif ElMetainy" <el*************@wayout.net.NOSPAM> wrote in message news:<eX**************@tk2msftngp13.phx.gbl>... Hello
You can use Access or sqlite, or any file base database engine.
sqlite is available at http://www.sqlite.com and the ADO.NET provider for sqlite is available at http://sourceforge.net/projects/adodotnetsqlite/ sqlite is open source and cross-platform. It can run on linux, windows, etc. So in case you would like to migrate your application one day to other operating systems, you should use a portable format for database.
Access wil do the job perfectly too, and the .NET framework supports it without downloading any libraries.
Best regards, Sherif
"DKode" <dk***@cfl.rr.com> wrote in message news:b1*************************@posting.google.co m... I will be making a windows app that will run on user's local machines. It will not be in a networked environment or anything like that which rules out SQL Server for the database. I am trying to come up with the best method to store data on the local user machine.
I was thinking of using XML files, but I am concerned about how quickly the xml files will grow and should I have a seperate XML file for each table?
Here's a run down of what this program will do :
Users will put a CD in their cd-rom drive, the app will read all the folder/filenames off the cd and allow them to attach additional keywords to each folder/filename, then they will give each CD a unique name and label the CD with this name. Then when they want to search for a program they will run the app and search for keywords and the app will tell them which cd to look on.
Hope this is descriptive enough. I was thinking of using MSDE, but this would require it be running on the user's machine at all times which I don't like the idea of. That's why I came up with the solution of XML files but the XML filesize can quickly grow... 100 files per cd times about 200 cd's average, that's 20,000 records right there, not too mention the extra keywords for each record that might be added. Maybe a flatfile would work better?
Any advice/pointers would be appreciated.
Thank you!
Hello
Yes, web services are not usefull in stand alone applications (if you use
them, the application will no longer be stand alone).
As for storing data as xml file, you will lose many features that database
engines provide, such as indexes, inner joins, a strong query parsing
engine, etc.
So I suggest use access, sqlite, MSDE ( as the other posters suggested) or
any other database engines. Of course MSDE is the much more powerfull than
access and sqlite. But will take more memory.
Best regards,
Sherif
"DKode" <dk***@cfl.rr.com> wrote in message
news:b1**************************@posting.google.c om... Thanks!
I have used access in the past before with some of my csharp applications at a telemarketing firm and found it very easy to connect to the db in a sql server type manner etc... I figured there would be some new web service/xml cool method of going about doing this, but I guess that stuff only applies to online applications/ applications connected via a network...not stand alone apps. am i correct on this?
"Sherif ElMetainy" <el*************@wayout.net.NOSPAM> wrote in message
news:<eX**************@tk2msftngp13.phx.gbl>... Hello
You can use Access or sqlite, or any file base database engine.
sqlite is available at http://www.sqlite.com and the ADO.NET provider for sqlite is available at http://sourceforge.net/projects/adodotnetsqlite/ sqlite is open source and cross-platform. It can run on linux, windows,
etc. So in case you would like to migrate your application one day to other operating systems, you should use a portable format for database.
Access wil do the job perfectly too, and the .NET framework supports it without downloading any libraries.
Best regards, Sherif
"DKode" <dk***@cfl.rr.com> wrote in message news:b1*************************@posting.google.co m... I will be making a windows app that will run on user's local machines. It will not be in a networked environment or anything like that which rules out SQL Server for the database. I am trying to come up with the best method to store data on the local user machine.
I was thinking of using XML files, but I am concerned about how quickly the xml files will grow and should I have a seperate XML file for each table?
Here's a run down of what this program will do :
Users will put a CD in their cd-rom drive, the app will read all the folder/filenames off the cd and allow them to attach additional keywords to each folder/filename, then they will give each CD a unique name and label the CD with this name. Then when they want to search for a program they will run the app and search for keywords and the app will tell them which cd to look on.
Hope this is descriptive enough. I was thinking of using MSDE, but this would require it be running on the user's machine at all times which I don't like the idea of. That's why I came up with the solution of XML files but the XML filesize can quickly grow... 100 files per cd times about 200 cd's average, that's 20,000 records right there, not too mention the extra keywords for each record that might be added. Maybe a flatfile would work better?
Any advice/pointers would be appreciated.
Thank you! This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: DKode |
last post by:
I will be making a windows app that will run on user's local machines.
It will not be in a networked environment or anything like that which
rules out SQL Server for the database. I am trying to...
|
by: richardshen |
last post by:
My DB2 V8 SP5 WSE crash on Windows 2003 with the following msg in db2diag.log.
Any idea?
Looks like I need set stackreserver, what is the suggested value for that?
2004-03-05-12.20.46.299000 ...
|
by: Twan Kennis |
last post by:
Hello!
I do have the following problem:
I've developed a Windows application which communicates with a
DB2-database on the iSeries platform using an ODBC-connection string.
This...
|
by: DKode |
last post by:
I will be making a windows app that will run on user's local machines.
It will not be in a networked environment or anything like that which
rules out SQL Server for the database. I am trying to...
|
by: Chris Paul |
last post by:
I'm having trouble with PHP & PostgreSQL/OpenLDAP/Apache on Windows.
I've set this up countless times on BSD (piece of cake) but I'm trying
to do this on Windows now so that my developer can work...
|
by: reachsamdurai |
last post by:
Hello,
Can you please let me know the procedure to reach db2 command prompt
from a cygwin window (hence without using Start-> Run -> db2cmd
method). I'm planning to write shell scripts which...
|
by: Kofa |
last post by:
Hi,
I cannot create/drop databases from the command line, only from the
GUI. Below is a detailed description of my installation and
configuration attempts (sorry about the long post).
I'm...
|
by: auratius |
last post by:
http://www.auratius.co.za/CSharpCodingStandards.html
Complete CSharp Coding Standards
1. Naming Conventions and Styles
2. Coding Practices
3. Project Settings and Project Structure
4....
|
by: Matt Lowrance |
last post by:
I'm hoping someone can give me a little guidance. I have written a
simple Windows Service that goes out and scrapes a few web pages and
updates some data in an access database. The service works...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |