Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsFree MagazinesWhite PapersSubmit Content
Discussion GroupsASP.NETWindows FormsLanguages.NET FrameworkVisual Studio.NET
Articles.NET FrameworkASP.NETToolsWindows Forms
.NET DirectoryOpen Source ProjectsUser GroupsWeb Resources
Related Topics
Visual Basic 6SQL ServerMS AccessOther DB ProductsMS Server ProductsMore Topics ...

.NET Forum / .NET Framework / General / September 2005

Tip: Looking for answers? Try searching our database.

Dynamic Forms with SQL

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Alvaro MR - 14 Sep 2005 11:14 GMT
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) - 14 Sep 2005 12:16 GMT
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/using/data/default.aspx?pull=/library/en-us/dna
dvnet/html/vbnet05282002.asp


Greetings.

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.