I have been having trouble with SQL Express, getting it installed, etc. I
am trying to work on an application that will give a test to only one
student at a time. It will have 50 multiple choice questions that do not
change often. I want to capture the student's answers so we can see what
questions students are missing to see if we need to change our training.
Would it be better to store the questions, answers, results, etc. in an XML
file instead of trying to create tables in SQL Express and then have
problems installing everything on another computer when I am through
developing it?
I use one piece of software now that uses XML for all the data storage and
it seems to work quickly.
Any thoughts on data storage in XML?
Thanks,
Fred 7 1453
It is never better to use an XML file instead of a database to store data.
Some reasons:
as the computer goes down all the information is gone you were busy with
as there is a writting error at saving the XML file then you are
probably overwritting the original one and as you do not save the original
one in advance you have nothing anymore
you cannot work with more than one person concurrent on the questions
Cor
"Fred Blair" <pa******@thetravelintexans.comwrote in message
news:gd**********@aioe.org...
>I have been having trouble with SQL Express, getting it installed, etc. I am trying to work on an application that will give a test to only one student at a time. It will have 50 multiple choice questions that do not change often. I want to capture the student's answers so we can see what questions students are missing to see if we need to change our training.
Would it be better to store the questions, answers, results, etc. in an
XML file instead of trying to create tables in SQL Express and then have
problems installing everything on another computer when I am through
developing it?
I use one piece of software now that uses XML for all the data storage and
it seems to work quickly.
Any thoughts on data storage in XML?
Thanks,
Fred
To add something to my message.
As it is to sent data, then XML is a perfect solution.
Cor
"Cor Ligthert[MVP]" <No************@planet.nlschreef in bericht
news:OQ**************@TK2MSFTNGP04.phx.gbl...
It is never better to use an XML file instead of a database to store data.
Some reasons:
as the computer goes down all the information is gone you were busy
with
as there is a writting error at saving the XML file then you are
probably overwritting the original one and as you do not save the
original one in advance you have nothing anymore
you cannot work with more than one person concurrent on the questions
Cor
"Fred Blair" <pa******@thetravelintexans.comwrote in message
news:gd**********@aioe.org...
>>I have been having trouble with SQL Express, getting it installed, etc. I am trying to work on an application that will give a test to only one student at a time. It will have 50 multiple choice questions that do not change often. I want to capture the student's answers so we can see what questions students are missing to see if we need to change our training.
Would it be better to store the questions, answers, results, etc. in an XML file instead of trying to create tables in SQL Express and then have problems installing everything on another computer when I am through developing it?
I use one piece of software now that uses XML for all the data storage and it seems to work quickly.
Any thoughts on data storage in XML?
Thanks, Fred
On Oct 15, 2:12 pm, "Fred Blair" <passp...@thetravelintexans.com>
wrote:
I have been having trouble with SQL Express, getting it installed, etc. I
am trying to work on an application that will give a test to only one
student at a time. It will have 50 multiple choice questions that do not
change often. I want to capture the student's answers so we can see what
questions students are missing to see if we need to change our training.
Would it be better to store the questions, answers, results, etc. in an XML
file instead of trying to create tables in SQL Express and then have
problems installing everything on another computer when I am through
developing it?
I use one piece of software now that uses XML for all the data storage and
it seems to work quickly.
Any thoughts on data storage in XML?
Thanks,
Fred
If your data needs do not require the full muscle of Sql Server, you
might try Sqlite. It requires zero configuration and has many nice
features. http://www.sqlite.org/
Chris
On Oct 15, 2:12 pm, "Fred Blair" <passp...@thetravelintexans.com>
wrote:
I have been having trouble with SQL Express, getting it installed, etc. I
am trying to work on an application that will give a test to only one
student at a time. It will have 50 multiple choice questions that do not
change often. I want to capture the student's answers so we can see what
questions students are missing to see if we need to change our training.
Would it be better to store the questions, answers, results, etc. in an XML
file instead of trying to create tables in SQL Express and then have
problems installing everything on another computer when I am through
developing it?
I use one piece of software now that uses XML for all the data storage and
it seems to work quickly.
Any thoughts on data storage in XML?
Thanks,
Fred
And here is a CodeProject article that explains how it could be used
in .Net. It's in C#, but you should be able to make use of it. http://www.codeproject.com/KB/databa...tewrapper.aspx
Chris
On Oct 15, 2:12 pm, "Fred Blair" <passp...@thetravelintexans.com>
wrote:
I have been having trouble with SQL Express, getting it installed, etc. I
am trying to work on an application that will give a test to only one
student at a time. It will have 50 multiple choice questions that do not
change often. I want to capture the student's answers so we can see what
questions students are missing to see if we need to change our training.
Would it be better to store the questions, answers, results, etc. in an XML
file instead of trying to create tables in SQL Express and then have
problems installing everything on another computer when I am through
developing it?
I use one piece of software now that uses XML for all the data storage and
it seems to work quickly.
Any thoughts on data storage in XML?
Thanks,
Fred
Oh, and one more thing, you should be able to use Sqlite with
LinqToSql if you are using VB 2008: http://www.codeproject.com/KB/linq/linqToSql_7.aspx
Chri
On Oct 15, 2:12 pm, "Fred Blair" <passp...@thetravelintexans.com>
wrote:
I have been having trouble with SQL Express, getting it installed, etc. I
Sorry for yet another post, but here is another link: http://sqlite.phxsoftware.com/
Chris
Personally i would prefer SQL server annywhere edition aka SQL server
compact edtion
cause if he wants to scale out in a future release of his program this would
be a lot easier to acomplish http://www.microsoft.com/Sqlserver/2...s/compact.aspx
SQL server compact has a one dll runtime and is easily upgraded to a full
sql server for possible future needs
regards
Michel Posseth
"Chris Dunaway" <du******@gmail.comschreef in bericht
news:95**********************************@u75g2000 hsf.googlegroups.com...
On Oct 15, 2:12 pm, "Fred Blair" <passp...@thetravelintexans.com>
wrote:
>I have been having trouble with SQL Express, getting it installed, etc. I am trying to work on an application that will give a test to only one student at a time. It will have 50 multiple choice questions that do not change often. I want to capture the student's answers so we can see what questions students are missing to see if we need to change our training.
Would it be better to store the questions, answers, results, etc. in an XML file instead of trying to create tables in SQL Express and then have problems installing everything on another computer when I am through developing it?
I use one piece of software now that uses XML for all the data storage and it seems to work quickly.
Any thoughts on data storage in XML?
Thanks, Fred
If your data needs do not require the full muscle of Sql Server, you
might try Sqlite. It requires zero configuration and has many nice
features.
http://www.sqlite.org/
Chris
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Scott J. McCaughrin |
last post by:
The following program compiles fine but elicits this message from the
linker: "undefined reference to VarArray::funct" and thus fails.
It seems to behave as if the static data-member:...
|
by: smith4894 |
last post by:
Hello,
I have a question regarding storage locations for different data types.
For example, dynamically created objects (using "new") are created on
the heap. local objects ( foo() {int x;} )...
|
by: Ced |
last post by:
Hi,
i'm not an expert in C but i try to compile BTNG software under linux
kernel 2.4.2-2. I get these errors at the very first stage. Does
someone could have a rapid look on this and tell me...
|
by: kobu.selva |
last post by:
I was recently part of a little debate on the issue of whether
constants and string literals are considered "data objects" in C. I'm
more confused now than before.
I was always under the...
|
by: laimis |
last post by:
Hey guys,
I just recently got introduced to data mappers (DTO mapper). So now I
have a SqlHelper being used by DTOMapper and then business layer is
using DTOMapper when it needs to persist...
|
by: Art |
last post by:
Hi folks,
I'm writing a traditional desktop app using VB.NET and am stumbling
over what seems like a very basic question:
My app does not need to be connected to a server or another computer....
|
by: Holger Marzen |
last post by:
Hi all,
AFAIK it is possible for columns to be very large, up to about 2 GB. Are
there any hints or experiences about storing binary data (jpg-images,
pdf-documents) in PostgrreSQL with or...
|
by: Chris Springer |
last post by:
I'd like to get some feedback on the issue of storing data out to disk and
where to store it. I've never been in a production environment in
programming so you'll have to bear with me...
My...
|
by: Atropo |
last post by:
Hi, all.
As you can see I'm just begining on C. with the tutorial "Sams Teach
Yourself C in 24 Hours" as a starter. on aix 5.2 when compiling a
helloWorld the gcc throws some warnings the...
|
by: Jeffrey |
last post by:
My understanding is that if you write
class X {
int y;
static int z;
};
then you've defined (and declared) X and y, but you have only declared
(and not defined) z. If you'd like to...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
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: 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: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
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: 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...
| |