Integration with sever side technology & database 

---

How sigma grid work with backend technology 

• Writen in pure javascript, sigma grid can work with any server side technology, such as PHP, JSP, classic ASP, .NET, even PERL.
• Grid: Call SigmaGrid constructor in onload event for the web page.

Samples download

Manipulate database through PHP (select, update, insert, delete records)

This sample has passed test with Apache1.3.39 (Unix) / PHP4.4.7 / MySQL5.0.27-standard. Please follow the steps.

1. Download the php sample (160KB mysql script included) and unzip to a directory.
2. Copy the whole directory to apache php directory.
3. Run CreatTable.sql in a new database or existing database.
4. Modify parameters of mysql_connect in ConnectionManager.php.
5. Open index.html through browser.

Manipulate database through JSP (select, update, insert, delete records)

This sample has passed test with Apache1.3.39 (Unix)/ JDK1.31 /MySQL5.0.27-standard. Please follow the steps.

1. Download the jsp sample (160KB mysql script included) and unzip to a directory.
2. Copy the whole directory to apache jsp directory.
3. Run CreatTable.sql in a new database or existing database.
4. Modify database address/loginname/password of getConnection in Control.jsp.
5. Open index.html through browser.

Manipulate database through classic ASP (select, update, insert, delete records)

This sample has passed test with IIS6.0 (Windows xp professional) . Please follow the steps.

1. Download the classic asp sample (180KB Access data file included) and unzip to a directory.
2. Copy the whole directory to IIS directory.
3. Make sure sigma_grid_crud_asp/db/ is writable.
4. Open index.html through browser.

Manipulate database through ASP.NET (select, update, insert, delete records)

This sample has passed test with IIS6.0 (Windows xp professional) / Visual studio 2005 / SQL server 2005. Please follow the steps.

1. Download the c sharp sample (430KB SQL server data file included) and unzip to a directory.
2. Make sure connection string in /App_Code/Employee.cs/EmployeeHelper is pointed to the right place.
3. Open solution file within Visual Studio and set index.html as start up page.
4. Start debuging / runing.