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.