Getting Started

In these examples the aspx page is placed in the application root and the css and gfx files of the grid are placed in sub directories directly below the root. There should be a link to the stylesheet in the Html Head section of the page. You might need to set the ImageDir property if the default value does not suite the directory structure of your ASP.NET application. See Using the Skin files for detailed information.

Example 1. Simple database query

When using a database query as the data source for the grid, the two properties ConnectionString and one or more of the SQL Commands must be set.

<%@ Page Language="vb" AutoEventWireup="false"%>
<%@ Register TagPrefix="axp" Namespace="Axezz.WebControls" Assembly="AxpDBNet" %>
<html>
<head>
  <link href="css/AxpStyleWindowsGrid.css" rel="stylesheet" >
</head>
<body>
  <form id="Form1" method="post" runat="server">
   <axp:axpdatagrid Runat="Server" ID="AxpDataGrid1"
     ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Access\NWind.mdb"
     SQL="Select * From Products"
     ImageDir="gfx/"></axp:axpdatagrid>
  </form>
</body>
</html>

Example 2. Enable database table editing

To enable database table editing, a few required properties must be set.

The EditOptions property controls what type of editing should be allowed. The editing options are:
- ADD Add new records allowed.
- UPDATE Update existing records allowed.
- DELETE Delete records allowed.
- NOVIEW The Form View mode will not be used.
The options can be combined, f.ex. EditOptions="ADD UPDATE NOVIEW". EditOptions can be set to "ALL" to enable all editing types. If the Form View mode is not required, set EditOptions="ALL NOVIEW"
EditPrimaryKeys must be set to the primary key column name.

If a combined primary key is in use, set EditPrimaryKeys to a comma separated list containing the column names. The order of which the column names is specified in the EditPrimaryKeys property must correspond to the Physical Order or to the order they are selected in the SQL (or EditSQL) query.

The database table must in all cases have a Primary Key.
If the primary key is an autogenerated value, the property EditNewPKStatement must be set.
Autogenerated column values in Sql Server is typically an IDENTITY value, in Access it is called "autoincrement" and for Oracle, this is normally a SEQUENCE.

For Sql Server IDENTITY and Access autoincremented primary keys, set EditNewPKStatement="autoincrement"

For Oracle SEQUENCES, a SQL command must be set. F.ex. if the SEQUENCE is named SEQ_TEST, then set AxpDataGrid1.EditNewPKStatement = "SELECT SEQ_TEST.NextVal FROM DUAL"
If database record delete is enabled, the property DeleteSQL must be set. The DeleteSQL command must be set to a simple sql command like "DELETE FROM Products". It should NOT contain a Where clause.

Set the EditConfirmDeleteString="Are you sure you want to delete this record?" or similar to let the user get a javascript confirmation message before deleting a record.

In the sample below, a few other non-required properties are set. RowClickAction="openform" enables the user to click anywhere in a Grid row to go to the Form, RowRolloverEffect=True adds a rollover effect when the user moves the mouse across the rows, and DisplayNavBar="both" ensures that the Record navigation bar is displayed at the top and bottom of the grid.

<axp:axpdatagrid Runat="Server" ID="AxpDataGrid1"
  ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Access\NWind.mdb"
  EditOptions="ALL"
  SQL="Select * From Products"
  DeleteSQL="Delete From Products"
  EditNewPKStatement="autoincrement"
  EditPrimaryKeys="ProductId"
  DisplayNavBar="both"
  ImageDir="gfx/"
  RowClickAction="openform"
  RowRollOverEffect="True"></axp:axpdatagrid>

Other useful settings when Editing is enabled

GridDisplayIndex="False" hides the sequentially numbered hyperlink in the leftmost column of the grid.
CopyFields="*" enables record copying
IsPrimaryKeysUpdateable="True" enables updating of Primary Keys
EditFieldsReadOnly="ProductId,ProductName" makes the input fields for the columns ProductId and ProductName readonly.
EditSQL="SELECT columnlist or * FROM table" if the main SQL command can not be used for table editing.
FormFieldsHide="1,2" or FormFieldsHide="ProductId,ProductName" Hides the first two columns when in editing mode
FormFieldsShow="3,4,5,6" Displays the third to sixth columns when in editing mode
FormCellWidths="100,400" sets the width of the Caption to 100 and the width of the cell holding input fields to 400. The width of the Input fields can not be controlled using FormCellWidths! To set the width of Input fields, see the SetEditField method.
DisplayDebug="True". SQL Select statements, table schema information and current AxpDataGrid version number is displayed

More about input fields in the Edit Form

The AxpDataGrid.AddEditLookup method adds lookup fields (dropdowns) retrieved from a database table or view to an input field.
AxpDataGrid.LookupDataSet can be used to add lookup fields that are hard coded or taken from another datasource than from a database.
The AxpDataGrid.SetEditField method is used to set more advanced features for an input field, including ReadOnly, Required, Visibility, Multiline and password fields, enabling the RichTextEdit Html-editor and more

Getting Started

Example 1. Simple database query

Example 2. Enable database table editing

Other useful settings when Editing is enabled

More about input fields in the Edit Form

Remarks

See Also