471,350 Members | 1,767 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,350 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 1618
"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 discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

14 posts views Thread by Ruby Tuesdays | last post: by
4 posts views Thread by Jonathan Li | last post: by
11 posts views Thread by Raghavendra Mudugal | last post: by
43 posts views Thread by Rob R. Ainscough | last post: by
8 posts views Thread by Inspector | last post: by
reply views Thread by XIAOLAOHU | last post: by

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.