How to develop database applications faster?

[Petar Djetlic]

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

[Paul E Collins]

"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.

[Cor Ligthert[MVP]]

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

[clintonG]

//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