Quick Help

A.    Login Page

 

1. Enter the URL in the browser to open the Login page.

2. Enter your database server name or IP address in database server textbox.

3. Choose either Windows or SQL authentication option.   

• To enable SQL authentication, enter your SQL server user name and password.
•  If you choose windows authentication, then the browser detects your windows credentials.

4. Select the Secure connection checkbox, only if SQL Server supports SSL.

5.  Click on the “Connect” button.

6.  Once you are authenticated, you will be taken to the main page.

 

B.    Main Page

1. By default, the main page opens the default database that is mapped to you in the SQL server. 

2. Using the database dropdown at top left side panel, you can switch between different databases.

3.  Tables and Views are listed in left side panel. By default, the tables and views are in collapsed mode. Click on the tables or views to expand. 

4. By default, the right side panel will be empty. After selecting a table from left panel, the records will be displayed on the right side panel.

5. To refresh the entire page, click on .

6.  To expand the tables list, click on .

7. To collapse the tables list, click on

8. To expand the view list, click on

9. To collapse the view list, click on

10. To collapse Database view, click on

11.  To expand Database view, click on on the left side top panel

12. Select a table from the table list to view the data

 

A. View Record

1. To view a record, click on. The selected record is shown in the detail panel.

2. Click on Edit   to edit the record.

3. Click on Delete   to delete the record.

4. Click on New   to create a new record.

 

B. Edit a Record

1. To edit a record, click on  from the table data panel or select “Edit” from the view mode . The selected row will be highlighted in the grid.

2. The data for the corresponding record is shown in the detail (bottom) panel.

.

3. To collapse the table data panel, click on

4. To expand the table panel, click on

5. To collapse the detail panel, click on

6. To expand the detail panel, click on

7. If there are any read-only columns, then they are shown as non-editable fields.

8. After you are done with the changes in the detail panel click on the update button to retain the changes or cancel to revert to the original data

 

C. Sorting the Columns

 

1. Click on the column name to sort. For the first click on the column gets sorted in ascending order and for the second click on the same column gets sorted in descending order.

       First Click                                   Second Click

 

D. Deleting a Record

1. To delete a record, click on from the table data panel or select “Delete” from the view mode

2. The confirmation message for deletion is displayed.

3. Select Ok to confirm deleting the record or select cancel to retain the record.

 

E. Insert a Record

1. To create a new record, click onor select “New” from the view mode

or

2. Detail view will be displayed with all the columns for entering the data

3. Enter the details for all the fields/columns and select insert button to add the new record

4. If you select insert without entering the data for the required fields or entering the improper data for the fields, then the fields are validated at the client side and shows the error message.

 

F. Other Helpful Options

1. To Refresh the table data, click on

2. You can configure the number records per page by selecting from the drop down.

3.  Toolbar shows the total number of records in right corner.

4. On top right corner of the screen shows “Server name”, “user name” and options for “logout” and “help”. To exit application, click on “Logout”.

5. Null value will be shown as Null in both grid and detail panel

6. Based on the data type and not null fields, the web data editor automatically validates the values while insert or update operations.