472,959 Members | 1,690 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

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

How to develop database applications faster?

I started developing in C#. Is there any elegant solution for automatic
generating of forms based on the structure of the tables in (MSSQL) database
(database schema), and after that only making minor changes in generated
code for specific things.

Take for example some simple desktop (windows) database app with 30-50
tables. Most forms for entering data are similar and have some form of
DataGridView with buttons for Insert/Update/Delete/Sort/Filter/Print/...
Forms for Insert/Update have many fields and some buttons like OK and
Cancel.

Generating every new form from zero with form designer and drag and drop is
very hard. Even the old xBase tools had frameworks for automatic generating
of code for all forms (even the complex ones) with the need for only small
changes after. What I want to say is that using the form designer at all is
the step back.

How you people do this, make every new form from zero or have some kind of
automatism.

Petar
Jun 27 '08 #1
3 1663
"Petar Djetlic" <pe***********@gmail.comwrote:
I started developing in C#. Is there any elegant solution for
automatic generating of forms based on the structure of the tables in
(MSSQL) database (database schema), and after that only making minor
changes in generated code for specific things. [...] Most forms for
entering data are similar and have some form of DataGridView with
buttons for Insert/Update/Delete/Sort/Filter/Print/...
Why not have *one* form with a DataGridView, and create new copies of it
bound to different tables?

Eq.
Jun 27 '08 #2
Petar,

You have at least two options, user controls and inherited forms.

http://msdn.microsoft.com/en-us/libr...ercontrol.aspx

Sorry I could not find a link to inherited form on MSDN, however it is in
the items from the project when you right click on that.

Cor
"Petar Djetlic" <pe***********@gmail.comschreef in bericht
news:g0**********@ss408.t-com.hr...
>I started developing in C#. Is there any elegant solution for automatic
generating of forms based on the structure of the tables in (MSSQL)
database (database schema), and after that only making minor changes in
generated code for specific things.

Take for example some simple desktop (windows) database app with 30-50
tables. Most forms for entering data are similar and have some form of
DataGridView with buttons for Insert/Update/Delete/Sort/Filter/Print/...
Forms for Insert/Update have many fields and some buttons like OK and
Cancel.

Generating every new form from zero with form designer and drag and drop
is very hard. Even the old xBase tools had frameworks for automatic
generating of code for all forms (even the complex ones) with the need for
only small changes after. What I want to say is that using the form
designer at all is the step back.

How you people do this, make every new form from zero or have some kind of
automatism.

Petar

Jun 27 '08 #3
//The site: filter ALWAYS works for me :-)
inherited form site:msdn2.microsoft.com
"Cor Ligthert[MVP]" <no************@planet.nlwrote in message
news:A1**********************************@microsof t.com...
Petar,

You have at least two options, user controls and inherited forms.

http://msdn.microsoft.com/en-us/libr...ercontrol.aspx

Sorry I could not find a link to inherited form on MSDN, however it is in
the items from the project when you right click on that.

Cor
"Petar Djetlic" <pe***********@gmail.comschreef in bericht
news:g0**********@ss408.t-com.hr...
>>I started developing in C#. Is there any elegant solution for automatic
generating of forms based on the structure of the tables in (MSSQL)
database (database schema), and after that only making minor changes in
generated code for specific things.

Take for example some simple desktop (windows) database app with 30-50
tables. Most forms for entering data are similar and have some form of
DataGridView with buttons for Insert/Update/Delete/Sort/Filter/Print/...
Forms for Insert/Update have many fields and some buttons like OK and
Cancel.

Generating every new form from zero with form designer and drag and drop
is very hard. Even the old xBase tools had frameworks for automatic
generating of code for all forms (even the complex ones) with the need
for only small changes after. What I want to say is that using the form
designer at all is the step back.

How you people do this, make every new form from zero or have some kind
of automatism.

Petar

Jun 27 '08 #4

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

Similar topics

14
by: Ruby Tuesdays | last post by:
Perhaps you database guru able to suggest what would be a good choice for opensource database platform to use to develop projects. At the moment the project is small/medium, but it will grow in...
4
by: Jonathan Li | last post by:
I have posted the question before but nobody have given me a solution. I would like to rephrase my requirement and want to hear your advice. We are developing application packages for logistics...
10
by: Rada Chirkova | last post by:
Hi, at NC State University, my students and I are working on a project called "self-organizing databases," please see description below. I would like to use an open-source database system for...
11
by: Raghavendra Mudugal | last post by:
Hello Everybody, We are creating a new project on Virtual Private Networking (VPN), and it is decided to use VC++. I actually want to know that is can be achived by VC#.NET or not. You all know...
43
by: Rob R. Ainscough | last post by:
I realize I'm learning web development and there is a STEEP learning curve, but so far I've had to learn: HTML XML JavaScript ASP.NET using VB.NET ..NET Framework ADO.NET SSL
8
by: Inspector | last post by:
I'm hoping I might be able to pick someone's brain out there. Our company is currently running an inhouse application in which data is being stored in SQL. Included in this data are thousands...
0
by: vayalumkan | last post by:
Hi Sir, Can any body help me to develop a CMS (Content Management System) ? Using ASP.NET technology and C#. Database SQL Server 2005 It should enable me to easily publish, manage and...
0
by: vayalumkan | last post by:
Hi Sir, I want some technical help on how to develop(Implement) a Content Management System using ASP.NET and C#? Can any body help me to develop a CMS (Content Management System) ? ...
1
by: HDI | last post by:
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...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
0
tracyyun
by: tracyyun | last post by:
Hello everyone, I have a question and would like some advice on network connectivity. I have one computer connected to my router via WiFi, but I have two other computers that I want to be able to...
2
by: giovanniandrean | last post by:
The energy model is structured as follows and uses excel sheets to give input data: 1-Utility.py contains all the functions needed to calculate the variables and other minor things (mentions...
4
NeoPa
by: NeoPa | last post by:
Hello everyone. I find myself stuck trying to find the VBA way to get Access to create a PDF of the currently-selected (and open) object (Form or Report). I know it can be done by selecting :...
1
by: Teri B | last post by:
Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course. 0ne-to-many. One course many roles. Then I created a report based on the Course form and...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM) Please note that the UK and Europe revert to winter time on...
3
by: nia12 | last post by:
Hi there, I am very new to Access so apologies if any of this is obvious/not clear. I am creating a data collection tool for health care employees to complete. It consists of a number of...
0
isladogs
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
2
by: GKJR | last post by:
Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other...

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.