473,320 Members | 1,865 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Storing Values for application

gv
Hi all,

I need to store values in a client application then later when done send
them to SQL 2000.

I know there is several ways to do this but, looking for the fastest , and
most effient way to
do this? Would a global array be the best way to this and could I use this
with mulitple values for each question? There might be over 50 different
questions.
I would need to Save, Edit before I send. And one more tricky thing. Some of
the question
go with other questions. I would just also need a way to track the
relationship between those questions?

Example: Need to store the following

Q1 = A
Q1 = C
Q1= G

Q2 = rr
Q2 = 4598
Q2 = SSS

If a Global Array or Array list is good can someone please show example.

thanks for any help
Gerry
Jul 21 '05 #1
6 1361
I'd love to know why you want the most efficient mechanism... because I'd
turn around and ask: efficient under what conditions?

a) is the SQL Server a desktop edition (or CE) or is it shared by many folks
on a server?
b) is your application a web app or does it have a rich client (windows
form) interface?
c) are your users always connected to the network that contains the SQL
Server, or can they use your app in a disconnected state?
d) how many users will use your app at the same time? Will that number
grow? What's the maximum foreseeable number of users that you want to pay
for right now? (The larger the number, the more expensive the solution, so
don't say "unlimited." Even eBay has a limit.)

These things matter. Depending on your answers, you will get some pretty
different advice.

--
--- Nick Malik [Microsoft]
MCSD, CFPS, Certified Scrummaster
http://blogs.msdn.com/nickmalik

Disclaimer: Opinions expressed in this forum are my own, and not
representative of my employer.
I do not answer questions on behalf of my employer. I'm just a
programmer helping programmers.
--
"gv" <vi*****@musc.edu> wrote in message
news:O3**************@TK2MSFTNGP09.phx.gbl...
Hi all,

I need to store values in a client application then later when done send
them to SQL 2000.

I know there is several ways to do this but, looking for the fastest , and
most effient way to
do this? Would a global array be the best way to this and could I use this
with mulitple values for each question? There might be over 50 different
questions.
I would need to Save, Edit before I send. And one more tricky thing. Some
of the question
go with other questions. I would just also need a way to track the
relationship between those questions?

Example: Need to store the following

Q1 = A
Q1 = C
Q1= G

Q2 = rr
Q2 = 4598
Q2 = SSS

If a Global Array or Array list is good can someone please show example.

thanks for any help
Gerry

Jul 21 '05 #2
gv
SQL 2000 is on a Server.
Rich client Interface
Only connect to log in and, to save or get data.
about 20 people total

thanks
gv

"Nick Malik [Microsoft]" <ni*******@hotmail.nospam.com> wrote in message
news:wI********************@comcast.com...
I'd love to know why you want the most efficient mechanism... because I'd
turn around and ask: efficient under what conditions?

a) is the SQL Server a desktop edition (or CE) or is it shared by many
folks on a server?
b) is your application a web app or does it have a rich client (windows
form) interface?
c) are your users always connected to the network that contains the SQL
Server, or can they use your app in a disconnected state?
d) how many users will use your app at the same time? Will that number
grow? What's the maximum foreseeable number of users that you want to pay
for right now? (The larger the number, the more expensive the solution,
so don't say "unlimited." Even eBay has a limit.)

These things matter. Depending on your answers, you will get some pretty
different advice.

--
--- Nick Malik [Microsoft]
MCSD, CFPS, Certified Scrummaster
http://blogs.msdn.com/nickmalik

Disclaimer: Opinions expressed in this forum are my own, and not
representative of my employer.
I do not answer questions on behalf of my employer. I'm just a
programmer helping programmers.
--
"gv" <vi*****@musc.edu> wrote in message
news:O3**************@TK2MSFTNGP09.phx.gbl...
Hi all,

I need to store values in a client application then later when done send
them to SQL 2000.

I know there is several ways to do this but, looking for the fastest ,
and most effient way to
do this? Would a global array be the best way to this and could I use
this
with mulitple values for each question? There might be over 50 different
questions.
I would need to Save, Edit before I send. And one more tricky thing. Some
of the question
go with other questions. I would just also need a way to track the
relationship between those questions?

Example: Need to store the following

Q1 = A
Q1 = C
Q1= G

Q2 = rr
Q2 = 4598
Q2 = SSS

If a Global Array or Array list is good can someone please show example.

thanks for any help
Gerry


Jul 21 '05 #3
Nick,

This question sounds as doing enquete work.

You have to cross etc.

Not the stuff I like, maybe a challenge for you.

:-)

Cor
Jul 21 '05 #4
What the heck did any of that mean? Apples are good.

--
William Stacey, MVP
http://mvp.support.microsoft.com

"Cor Ligthert" <no************@planet.nl> wrote in message
news:u9**************@TK2MSFTNGP12.phx.gbl...
Nick,

This question sounds as doing enquete work.

You have to cross etc.

Not the stuff I like, maybe a challenge for you.

:-)

Cor


Jul 21 '05 #5
> What the heck did any of that mean? Apples are good.


I see that I don't or know or get it in my head the English word. An
inquiry, like in an exit poll is what I mean.

Crossing (I hope it is the English meaning too for this) is taking only the
answers from by instance row n when row m = 2 and so on.

What have all men from older 20 said about woman.
What have all men younger than 21 said about women.

Cor
Jul 21 '05 #6
Traditional client-server system, then. High uptime but low resource
utilization. Row Concurrency could become an issue if you don't tend to it.
Scalability is not much of a concern at 20 users. Are we on the same page?

I'd suggest that you would be best off stored procedures for Insert, Update,
and Delete of the information you want in row format, and then use data
adapters to retrieve and return the information to the database. (You can
create the data adapter using the wizard and enter in the names of the
stored procs there).

Architecturally, make each client communicate directly with SQL Server. At
the end of the day, if you attempt to pass tables to remote objects running
on the server and then use SQL INSERT from there, you will add more
complexity than you will save in throughput. (I'd wager that throughput
could drop, but is unlikely to increase... so there's little reason to do
this).

As for the relationships between questions: provide data fields in database
to declare the relationships, return them in the dataset, and interpret the
relationships, in terms of GUI behavior, at the front-end. This can be a
simple foreign key field.

I hope that this helps to answer your question. If not, please let me know
where I'm off track and I'll try again.

--
--- Nick Malik [Microsoft]
MCSD, CFPS, Certified Scrummaster
http://blogs.msdn.com/nickmalik

Disclaimer: Opinions expressed in this forum are my own, and not
representative of my employer.
I do not answer questions on behalf of my employer. I'm just a
programmer helping programmers.
--
"gv" <vi*****@musc.edu> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...
SQL 2000 is on a Server.
Rich client Interface
Only connect to log in and, to save or get data.
about 20 people total

thanks
gv

"Nick Malik [Microsoft]" <ni*******@hotmail.nospam.com> wrote in message
news:wI********************@comcast.com...
I'd love to know why you want the most efficient mechanism... because I'd
turn around and ask: efficient under what conditions?

a) is the SQL Server a desktop edition (or CE) or is it shared by many
folks on a server?
b) is your application a web app or does it have a rich client (windows
form) interface?
c) are your users always connected to the network that contains the SQL
Server, or can they use your app in a disconnected state?
d) how many users will use your app at the same time? Will that number
grow? What's the maximum foreseeable number of users that you want to
pay for right now? (The larger the number, the more expensive the
solution, so don't say "unlimited." Even eBay has a limit.)

These things matter. Depending on your answers, you will get some pretty
different advice.

--
--- Nick Malik [Microsoft]
MCSD, CFPS, Certified Scrummaster
http://blogs.msdn.com/nickmalik

Disclaimer: Opinions expressed in this forum are my own, and not
representative of my employer.
I do not answer questions on behalf of my employer. I'm just a
programmer helping programmers.
--
"gv" <vi*****@musc.edu> wrote in message
news:O3**************@TK2MSFTNGP09.phx.gbl...
Hi all,

I need to store values in a client application then later when done send
them to SQL 2000.

I know there is several ways to do this but, looking for the fastest ,
and most effient way to
do this? Would a global array be the best way to this and could I use
this
with mulitple values for each question? There might be over 50 different
questions.
I would need to Save, Edit before I send. And one more tricky thing.
Some of the question
go with other questions. I would just also need a way to track the
relationship between those questions?

Example: Need to store the following

Q1 = A
Q1 = C
Q1= G

Q2 = rr
Q2 = 4598
Q2 = SSS

If a Global Array or Array list is good can someone please show example.

thanks for any help
Gerry



Jul 21 '05 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Sean | last post by:
HI, I have a shopping cart in which I am trying to use breadcrumb style navgiation. I need to be able to display the categroy heading relating to the section of the site a visitor is using i.e...
2
by: Jax | last post by:
Say for example a user of my website makes a selection on the site and I want to store that value for use on a later page what is the best way to do that? My only method at the moment that I know...
4
by: Hazzard | last post by:
What is the best way to do this? Binary with 0 representing off and 1 on? Int16 with 1 representing first button, 2 the second, 3 ... varchar with a character values at certain positions in the...
4
by: kanones | last post by:
I have some data that is been retrieved from a call to sql server stored procedure that I want to store for a period of time in a web farm architecture. I want to minimize the calls to sql server...
6
by: gv | last post by:
Hi all, I need to store values in a client application then later when done send them to SQL 2000. I know there is several ways to do this but, looking for the fastest , and most effient way...
6
by: Steve | last post by:
Hi, I've developed a testing application that stores formatted results in a database. Recently it was requested that I add the ability to generate graphs from the raw, un formatted test results...
6
by: (PeteCresswell) | last post by:
User wants to go this route instead of storing pointers in the DB and the documents outside. Only time I tried it was with only MS Word docs - and that was a loooong time ago - and it seemed to...
0
by: Claire | last post by:
In project settings.default you can store "application" readonly settings and "user" read/write settings. Is there anyway to write application read/write settings rather than using the registry...
11
by: =?Utf-8?B?bWljaGFlbCBzb3JlbnM=?= | last post by:
I have worked with application settings in VS2005 and C# for awhile, but usually with standard types. I have been trying to store a custom container/class/type in an application setting and I have...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.