IWE (Inline Web Entry)
for Microsoft SQL Server 1.0
IWE is a framework 2.0 web application
that provides automatic web data entry for tables in a Microsoft SQL Server
database. Just config the database connection string in the web.config
configuration file of the web site and that’s all, start editing your tables.
REQUIREMENTS
1. Internet Information Services
2. Framework 2.0
INSTALLATION
1. Unzip the file IWE.zip into a new folder.
2. Point a Virtual Directory of your Internet Information Server to the newly
created directory. Configure the write permission for the virtual directory.
3. Configure the Virtual Directory created for framework 2.0 use.
BASIC CONFIGURATION
1. Open the web.config file in the Virtual Directory created.
2. Edit the connectionStrings section to match your Database settings
<connectionStrings>
<add name="CS" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=DataBaseName;Persist
Security Info=True;User ID=user;Password=password"
providerName="System.Data.SqlClient" />
</connectionStrings>
Note: Do not change de name of the connectionString (CS).
USE
Just pick up the default.aspx of the virtual directory created in your web
browser and you should start seeing the table list of your database. Click on
the hyperlinks of the table to start editing them. A default configuration file
(/config/<tableID>.ini) is created for each table as soon as it is requested in
the page in the /config directory of the virtual directory. You can change the
table configuration file once created to best match your needs.
ADVANCED CONFIGURATION
You can configure the default table configuration file once they are created.
The table configuration file name corresponds to the Microsoft SQL Server
TableID. ie: 117575457.ini. For each field in the table should exist a section
with its name. i.e.: [fieldname]. Each section should contain 3 values:
1. Title: Contains the title of the column. i.e.: Title=My Column
2. Size: Size in pixels of the column. i.e.: Size=100
3. Type: Type of the field. Valid type are: Password, TextBox, ComboBox and
CheckBox. For ComboBox type fields And addition parameter is available, Array.
Array could contain a string with constant values (i.e.: Array=1,Option1|2,Option2|3,Option3|9,Option4)
or an SQL statement for looking for the data in another table of the database
(i.e.: Array=SELECT code, description FROM tablename).
There is an addition section called SQL where advanced users can modify the SQL
statements to even better suit their requirements.