Need a Winform code generator from database structure

Hi,

I've been searching for a code generator that can take a table in SQL Server
and generate a WinForm for that table. This form will be used to gather data
from the user in order to add and update all the fields in the table. I have
over 100 tables so a code generator would sure be helpful.

BTW I'm using the excellent LLBLGen (ver 1.2) from Frans Bouma
(http://www.sd.nl/software/default.asp) to generate the stored procedures
and DAL classes for these tables.

Since LLBLGen is open source I'd prefer code over product recommendations.

Thanks,

Brent....

Brent,

Did you see the data form wizard? Add a windows form to your
project and select dataform wizard.

Ken
-------------
"Brent" <beldstromNoSPAM123@pobox.com> wrote in message
news:e$W2401ODHA.3020@TK2MSFTNGP10.phx.gbl...
> Hi,
>
> I've been searching for a code generator that can take a table in SQL
Server
> and generate a WinForm for that table. This form will be used to gather
data
> from the user in order to add and update all the fields in the table. I
have
> over 100 tables so a code generator would sure be helpful.
>
> BTW I'm using the excellent LLBLGen (ver 1.2) from Frans Bouma
> (http://www.sd.nl/software/default.asp) to generate the stored procedures
> and DAL classes for these tables.
>
> Since LLBLGen is open source I'd prefer code over product recommendations.
>
> Thanks,
>
> Brent....
>
>
>

Hi Ken,

I totally missed that but when I gave it a try it didn't create what I had
hoped. It puts a DatGrid on the form with a column for each field in the
table. I want individual controls such as CheckBoxes, ListBoxes, TextBoxes,
etc. aligned vertically.

Thanks anyway.

Brent...



"Ken Tucker" <vb2ae@bellsouth.net> wrote in message
news:OdoH992ODHA.3880@tk2msftngp13.phx.gbl...
> Brent,
>
> Did you see the data form wizard? Add a windows form to your
> project and select dataform wizard.
>
> Ken
> -------------
> "Brent" <beldstromNoSPAM123@pobox.com> wrote in message
> news:e$W2401ODHA.3020@TK2MSFTNGP10.phx.gbl...
> > Hi,
> >
> > I've been searching for a code generator that can take a table in SQL
> Server
> > and generate a WinForm for that table. This form will be used to gather
> data
> > from the user in order to add and update all the fields in the table. I
> have
> > over 100 tables so a code generator would sure be helpful.
> >
> > BTW I'm using the excellent LLBLGen (ver 1.2) from Frans Bouma
> > (http://www.sd.nl/software/default.asp) to generate the stored
procedures
> > and DAL classes for these tables.
> >
> > Since LLBLGen is open source I'd prefer code over product
recommendations.
> >
> > Thanks,
> >
> > Brent....
> >
> >
> >
>
>

I don't know of code to do this, but this article shows how to write
customizable GUI using XML, which is just a few steps away from what you
need...

a.. The Application Automation Layer - Using XML To Dynamically Generate GUI
Elements--Forms And Controls
Exploring the issues of runtime form and control generation as specified by
XML files.

--
Regards,

Roy Osherove
http://www.iserializable.com
---------------------------------------------

"Brent" <beldstromNoSPAM123@pobox.com> wrote in message
news:e$W2401ODHA.3020@TK2MSFTNGP10.phx.gbl...
> Hi,
>
> I've been searching for a code generator that can take a table in SQL
Server
> and generate a WinForm for that table. This form will be used to gather
data
> from the user in order to add and update all the fields in the table. I
have
> over 100 tables so a code generator would sure be helpful.
>
> BTW I'm using the excellent LLBLGen (ver 1.2) from Frans Bouma
> (http://www.sd.nl/software/default.asp) to generate the stored procedures
> and DAL classes for these tables.
>
> Since LLBLGen is open source I'd prefer code over product recommendations.
>
> Thanks,
>
> Brent....
>
>
>