Dynamic Forms with SQL

[Alvaro MR]

Hi to everyone.

I need some help about some questions.

I want to create dynamic forms using .NET (Windows Forms, no ASP.NET) in the
following way.

Imagine I have an application with a 3 option menu. These options are for
example (customers, books, projects)

If I do click on customers a new form of customers must be painted. What I
want to do is to paint this form accessing to a SQL Server Table and extract
the Fields. The table has 10 fields (for example, customerName,
CustomerAddress , CustomerPhone, etc.) but this fields with its content will
be loaded in a DataList Control.
Not all the fields (in this case 10 fields) will be loaded in the DataList,
for example only three. Only if I click on the buttons that also must be
created (New, Modify or Delete) a new window with all the fields (remember
that in this example are 10 fields) will be shown to manipulate the customer.
We have to take into count that is possible to have a table with multiple
relations with other tables, I mean, maybe we want to save a record with the
country of a customer. In this case a DropDownList will be created instead of
a TextBox.

I Know that this is really difficult but I need to know if this is possible.

Ok. If now I click on Books, the form will be different from Customers and
so on.
I am lost and I want to find the path... :)

Maybe I need to have some queries first in a Table of the Database that get
the fields and then write into an XML and a XSLT write the code. I DON'T KNOW
WHAT TO DO.

SORRY About my english because is no so good but I have tried it. THANKS A
LOT FOR YOUR ANSWERS

[Samuel (lets dot monroe at gmail dot com)]

What you are looking for is not "really difficult". And it is not only
"possible". It is extremely easy, standard coding. But from your
message I get it you're not exactly an expert in .NET (no offense
intended).

You better google for some tutorials. This one here may help you get
started.

http://msdn.microsoft.com/vbasic/usi...et05282002.asp

Greetings.