web.config settings

Simply managing the capabilities of Smart Table Editor

 

Smart Table Editor configuration is very simple, once you have downloaded the files, they should be enabled within IIS and after you need to amend the web.config file. Below are listed all the main parameters in the web.config and what they mean.

Web.config settings

Database connection parameters:


Smart Table Editor supports connection to Access (a) and SQL Server (b). Here's how to properly set the connection in both cases.

a)  <!--MICROSOFT ACCESS CONNECTION VALUES SAMPLE-->


<add key="ConnType" value="ACCESS"/>

<add key="DBPath" value="mdb-database/data.mdb"/>

 

b)  <!--MICROSOFT SQL SERVER CONNECTION VALUES SAMPLE-->


<add key="ConnType" value="SQL" />

<add key="ServerName" value=".\SERVERNAME" />

<add key="DBUser" value="sa" />

<add key="DBPass" value="lb3#12@lab" />

<add key="DBName" value="DataSQL" />

 

 

Other Parameters

 

Table and fields filter

<add key="TabMenuVoices" value="Tables,Customers,Employees,Products,Shippers,Suppliers,Categories/Orders,Orders,Order Details"/><!--Insert values separated by ",". First value is the tab title, others values are the tables names until the "/". Use # character after tab voice name to open custom link in a blank page. If TabMenuVoices value is "" shows all the tables of database in one tab.-->

<add key="HideMenuVoice" value=""/><!-- Insert table names separated by ",". Only works if TabMenuVoices is null. Insert -->

<add key="HideTableField" value=""/> <!—Insert Fields Name separated by “,”. Hide all table fields with the names stated. Do not insert fields stated in InsertTabRelation-->

 

Relation between field tables

 

<add key="InsertTabRelation" value="Orders,CustomerID,Customers,CustomerID,CompanyName/Orders,EmployeeID,Employees,EmployeeID,LastName/Products,SupplierID,Suppliers,SupplierID,CompanyName/Products,CategoryID,Categories,CategoryID,CategoryName"/><!--Connect a table field with values from anothes table for input. Use Separator "/" for multiple assignments. Values must be stated in this sequence: Table,IdTable,TabChild,IdChild,DescChild.-->

 

Login

<add key="LoginTable" value="0"/><!--Values 0 or 1. If set 1 exist table named Login with fields: id, counter - username,text,40 - password, text,40. 0 needed if no login required. -->

<add key="user" value="admin"/><!--Leave "" if no login required (LoginTable value must be 0)-->

<add key="password" value="admin"/><!--Leave "" if no login required (LoginTable value must be 0)-->

 

Language setting


<add key="Language" value="en-US"/><!--.NET Custom localization culture. Use your own to view customized fields format-->

<add key="tinymce-language" value="en"/><!-- Changes the TyniMCE and Date Picker calendar language. Available only 'en' and 'it' in this installation. Download other languages files if needed-->

 

Other Language and Labels settings


<add key="HomeBtnCaption" value="Home"/>

<add key="PrevButtonCaption" value="Prev"/>

<add key="NextButtonCaption" value="Next"/>

<add key="EditCaption" value="Edit"/>

<add key="DelCaption" value="Delete"/>

<add key="InsCaption" value="Insert"/>

<add key="RowsPerPageCaption" value="Rows per page"/>

<add key="RowsCaption" value="Rows"/>

<add key="OfCaption" value="of"/>

<add key="SearchCaption" value="Search"/>

<add key="ShowAllCaption" value="Show all"/>

<add key="AddNewCaption" value="Add New"/>

<add key="SaveBtnCaption" value="Save data"/>

<add key="CancBtnCaption" value="Cancel"/>

<add key="DelBtnCaption" value="Delete data"/>