This article revolves around being plain lazy. When it comes to creating Form code based on some database table, I hate it! This code sample goes along way into speeding this process up to me. There still is some manual parts to finish up the form code but this takes care of remembering, what columns are in the DAT Abase table. In future releases, we'll provide more functionality to further automate this but this is the big I-I opinion! The following four steps listed below can be followed and this'll generate the ASP.net code. A big to Dave W. Webmaster's for saving me on many things!!
Define What database you want to connect to the Config.web. This is stored in the connection string
<configuration>
<appsettings>
<add key= "DSN" value= "server=localhost;uid=sa;pwd=;d atabase=aspfree"/>
</appsettings>
</configuration>
Load the ASPX page in your browser, select the table to create the Form code from
Select the Checkboxs of which fields to is on the form
Copy and paste into your code.
This is a screen shot of the File after following the above steps.
This is the code:
<%@ Page language= "VB" enablesessionstate= "false" enableviewstate= "true" Trace= "false" debug= "false" strict= "True" %>
<%@ Import namespace= "System.Text"%>
