473,320 Members | 1,953 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.

Best way to develop a database program

HDI
Hi,

I'm looking for the most user friendly way to develop a database
program.
Maybe some of you have got some nice experience and ideas that I can
use.

I always worked with sql statements te get and put data in the
database. For small applications it will work well to make add, change
and a delete buttons but when a user has got a lot of data on his
screen it feels wrong. The user has to put in all the data and when
he's done he has to press on the save (change) button. I don't think
that last step is user friendy. If something happens or there is a
data concurreny or ... he has to insert all the data again.

So I was thinking of working like MS Access does. When data changes
write it to the database. The disadvantage is that there will be more
traffic.

How do you work?

I'm working with vb2005 express and sql server.
Nov 21 '08 #1
1 2218
"HDI" <hd***@hotmail.comwrote in message
news:e5**********************************@l39g2000 yqn.googlegroups.com...
Hi,

I'm looking for the most user friendly way to develop a database
program.
Maybe some of you have got some nice experience and ideas that I can
use.

I always worked with sql statements te get and put data in the
database. For small applications it will work well to make add, change
and a delete buttons but when a user has got a lot of data on his
screen it feels wrong. The user has to put in all the data and when
he's done he has to press on the save (change) button. I don't think
that last step is user friendy. If something happens or there is a
data concurreny or ... he has to insert all the data again.

So I was thinking of working like MS Access does. When data changes
write it to the database.

How do you work?
Either way is appropriate depending on the situation. In some cases writing
the data as you go is not good for the user as they don't get to play around
and then not save their changes. But in some cases they don't need to play
around.
The disadvantage is that there will be more
traffic.
And this can lead to a slower app for the user. With a large number of users
you might find moving between rows to be slow (I presume you'll save when
they leave the row)

Basically there is no right or wrong answer.

Michael
Nov 22 '08 #2

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

Similar topics

2
by: Hugh McLaughlin | last post by:
Hello Everyone and thanks for your help in advance. I have read a great deal about code reuse and the development of the three-tier application, but am somewhat confused on some issues and am...
5
by: RichG | last post by:
We are building a new developement system specifically for .NET developement. We will bw using VB. and C#. What will be the best OS to install on the new system. What will be the best concidering...
11
by: DrUg13 | last post by:
In java, this seems so easy. You need a new object Object test = new Object() gives me exactly what I want. could someone please help me understand the different ways to do the same thing in...
136
by: Matt Kruse | last post by:
http://www.JavascriptToolbox.com/bestpractices/ I started writing this up as a guide for some people who were looking for general tips on how to do things the 'right way' with Javascript. Their...
5
by: Andrew S. Giles | last post by:
I thought I would post here, as I am sure someone, somewhere has run into this problem, and might have a good solution for me. I am writing an applicaiton in C# that will accept data and then put...
12
by: neodem | last post by:
PHP, and to a lesser degree JSF has become very popular ways to build web applications. What I don't understand, and what I would like you all to comment on, is how these methods are the best way...
55
by: Steve | last post by:
I have to develop several large and complex C++ hardware test programs that should work under DOS, most likely with 32-bit DOS extender. Development workstation OS would be Microsoft XP. Quite some...
0
by: pedaammulu | last post by:
Hi All, New title for Mastering Web Application Development. All secrets of developing an Accounting Software for the web revealed. Title: "Develop your own Web Accounting Application...
2
by: sabbadin12 | last post by:
Hi, I'm going to work on an application that uses a postgreSQL database so that it can uses SQLServer 2005. I think I solved most problems on the programming side, but I still have some doubts...
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
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: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
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)...
1
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...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
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.