The properties of the AxpDataGrid class are listed below. For a complete list of AxpDataGrid class members, see the AxpDataGrid Members topic.
Public Instance Properties
 AccessKey | |
| ApplyCellFormattingToExcel | Wheter data column formatting should be applied to the Excel export if GridFormatCellFunction is set for selected columns. |
| ApplyCellFormattingToForm | Wheter the GridFreeFormatCell and GridFormatCellFunction formatting should apply to Form view as well as Grid view. |
| ApplyColFormattingToForm | Whether the Column formatting set using SetGridColAttributes or GridColumns.CellHtmlAttributes should apply to Form view as well as Grid view. |
| Attributes (inherited from WebControl) | Gets the collection of arbitrary attributes (for rendering only) that do not correspond to properties on the control. |
| AxConnection | Database connection available after setting the connection string |
| BackColor | |
| BindingContainer (inherited from Control) | |
| BorderColor | |
| BorderStyle | |
| BorderWidth | |
| ClearState | Wheter the grid state as a result of user interaction should be cleared. |
| ClientID (inherited from Control) | Gets the server control identifier generated by ASP.NET. |
| CommandTimeout | Set command execution timeout in seconds. |
| ConnectionString | A standard OleDB database connection string. |
| Controls (inherited from Control) | Gets a ControlCollection object that represents the child controls for a specified server control in the UI hierarchy. |
| ControlStyle (inherited from WebControl) | Gets the style of the Web server control. This property is used primarily by control developers. |
| ControlStyleCreated (inherited from WebControl) | Gets a value indicating whether a Style object has been created for the ControlStyle property. This property is primarily used by control developers. |
| CopyFields | A string containing either '*" for all fields, the empty string to disable copying of data records or a comma separated list of field names. |
| CountRecords | Whether the grid should count and display the total number of records in the query. |
| CountSQL | Custom SQL SELECT query for counting records in the datasource. |
| CssClass | |
| CurrentDataRow | Gets the current data record as a .NET DataRow object |
| CurrentDataView | A .NET DataView that either contains all records (if the property DataSource is set) OR the data records on the current page in all other cases. |
| CurrentMode | Gets a value representing the current display mode. |
| DataExportEncoding | Gets or sets the character encoding for the Excel export. |
| DataMember | DataTable Name in DataSet if the property DataSource is set to a DataSet. |
| DataSource | A datasource for the Grid and Form View mode if SQL properties are not used. |
| DeleteSQL | SQL statement specifying how a record should be deleted in the database |
| DisableNavBarLastPageBtn | Whether the "Last page" button on the navigation bar should be disabled. |
| DisplayDebug | Whether Debug information should be displayed. |
| DisplayErrorMessage | Whether messages from exception handled by the grid should be displayed. |
| DisplayExcelIcon | Whether the Excel icon should be visible in the navigation bar. |
| DisplayHeader | Whether the Grid Column Headers and Form Captions should be visible. |
| DisplayNavBar | Gets or sets the placement of the Page Navigation Bar. |
| DisplayNavBarFirstLastBtn | Indicates if the "First Page" and "Last Page" button is visible on the Navigation Bar |
| DisplayNavBarTextOptions | Set the Navigation Bar display options. |
| DisplayRecordsPerPageSelect | Whether the Drop-down list for selecting the number of Records per Page should be visible. |
| DisplayType | Determine if AxpDataGrid should display as a grid, a form, or support both display modes. |
| EditConfirmDeleteString | If set, the user will get a confirmation prompt containing this string when the Delete button is clicked. |
| EditFieldsReadOnly | List of field names (or column numbers) that should be treated as read only in the edit form. |
| EditLookupAsString | Gets the look-up values as a string for a column |
| EditNewPKStatement | Control if primary keys are autoincremented or require a separate SQL statement (eg for Oracle Sequences) |
| EditOptions | Controls what type of data updates should be supported |
| EditPerformUpdates | Whether the grid should issue database Insert, Update and Delete commands or not. |
| EditPrimaryKeys | Gets or sets the Primary key names. |
| EditSQL | The SQL Select statement to use as a datasource for the Form Edit mode. |
| Enabled (inherited from WebControl) | Gets or sets a value indicating whether the Web server control is enabled. |
| EnableViewState | AxpDataGrid does not utilize ViewState (with a few exceptions) |
| ErrorMessage | Contains error messages from Exceptions handled by AxpDataGrid |
| ExcelFileName | The name given to the Excel file when exporting to Excel. Do not include any file extensions. |
| Font | |
| FooterText | Gets or sets the Html code and text displayed in the Grid Footer placed below the grid navigation bar. |
| ForeColor | |
| FormButtonBarPlacement | Determines the position of the Data Editing Button Bar when in Form mode. |
| FormCellWidths | The width of the two main columns (Caption and Value) used in the Form View and Form Edit. |
| FormDisplayFieldNames | User defined Column Captions used in Form View and Edit Mode. |
| FormFieldsHide | Hide columns in form mode |
| FormFieldsShow | Data fields to be displayed in the Form mode |
| FormSQL | The SQL statement that should be used in the Form display mode. |
| FormTableTag | Additional HTML attributes for the form TABLE tag |
| FormTDTag | Additional HTML attributes for the form TD tag |
| FormViewColumns | Gets the collection of DataColumn items available in Grid's Load Event |
| FromRow | Gets or sets the start row number for the current page. |
| GridButtonBarPlacement | Determines the position of the Data editing button bar when in Grid mode (the button bar will only contain the Add button) |
| GridCellsNoBr | Kept for backward compatibilty. Use GridColsNoWrap instead. |
| GridCellWidths | Control the width of columns in the datagrid |
| GridColAttributes | Normal html attributes including style and scripting for specified column number |
| GridColHeadAttributes | Normal html attributes including style and scripting for specified Grid Header column |
| GridColsNoSort | Indicates columns where User interface ordering should not be allowed |
| GridColsNoWrap | Specify grid columns where the text should not wrap. |
| GridColumns | Gets the collection of DataColumn items available in Grid's Load Event |
| GridDisplayFieldNames | Custom Column Header names |
| GridDisplayIndex | Display a sequential number in the first Grid Column for each record (1,2,3,4 etc). As default this column will be used as a hyperlink to the form page. |
| GridFieldsHide | Hide columns in Grid mode |
| GridFieldsShow | Specify which columns should be visible in the grid |
| GridFieldsSupressDup | Hide grid data values for columns where the data values repeats the previous value. |
| GridFormatCellFunction | Data value formatting and functions |
| GridFreeFormatCell | The GridFreeFormatCell and (Set)GridFreeFormatCellByCol allows combining the values of data columns with your own text or html code. |
| GridFreeFormatCellByCol | See SetGridFreeFormatCellByCol |
| GridFreeFormatCellColumnDelimiter | The string used to denote data column names in the property GridFreeFormatCell can be set manually. This is useful if a cell contains javascript functions calls with several parameters. The Default Delimiter is ',' (a comma). Alternatively (recommended), use the SetGridFreeFormatCellByCol method. |
| GridFreeFormatCellDataFieldDelimiter | Override the string used to denote data column names in GridFreeFormatCell functions |
| GridLinkIndex | Specify what grid column should be used as a hyperlink to the form mode. |
| GridLinkIndexWidth | The width of the Grid column containing record numbers (column 0) |
| GridTableTag | Additional HTML attributes for the Form and Grid TABLE tag. |
| GridTDEvenTag | Additional HTML attributes for the data cells (TD cells) of even numbered Grid rows |
| GridTDOddTag | Additional HTML attributes for the data cells (TD cells) of odd numbered Grid rows. |
| GridTDTag | HTML attributes for the data cells (TD cells) of Grid rows. |
| GridTREvenTag | HTML attributes for the even numbered Grid data rows (TR tag). |
| GridTROddTag | HTML attributes for the odd numbered Grid data rows (TR tag). |
| GridTRTag | HTML attributes for the Grid data rows (TR tag). |
| HeaderText | Gets or sets the Html code and text displayed in the Grid Header placed above the grid. |
| Height (inherited from WebControl) | Gets or sets the height of the Web server control. |
| ID (inherited from Control) | Gets or sets the programmatic identifier assigned to the server control. |
| ImageDir | The relative or full URL to the directory where the navigation bar gif files are stored. |
| IsPrimaryKeysUpdateable | Whether update of primary keys is allowed. |
| Language | Set user interface strings in local language. English, Norwegian and German is supported. For other languages, set the appropriate string properties. |
| LanguageBtnString | Configurable strings for Grid and Form buttons |
| LanguageString | Configurable language strings |
| LangUpdString | Configurable messages appearing when updating data |
| LookupDataSet | DataSet containing lookup values for Form Edit input fields. There should be one DataTable per lookup in this DataSet. See also AddEditLookup |
| MemoFieldLimit | Maximum number of characters to display in "memo" data columns. |
| NamingContainer (inherited from Control) | Gets a reference to the server control's naming container, which creates a unique namespace for differentiating between server controls with the same ID property value. |
| OracleDatePattern | Oracle Date Pattern to be used if primary field is an Oracle Date Field. |
| OrderByDesc | Whether the ordering specified in OrderByFields is descending. |
| OrderByFields | Initial data ordering. |
| Page (inherited from Control) | Gets a reference to the Page instance that contains the server control. |
| Parent (inherited from Control) | Gets a reference to the server control's parent control in the page control hierarchy. |
| RecordCount | Gets or sets the number of records (total number of rows) in the recordset. |
| RecordsMaxLimit | Limit the number of rows the grid should handle. |
| RecordsPerPage | The initial page size (number of records/rows per page) |
| RecordsPerPageOptions | Gets or sets the content of the Drop-down list for selecting Number of Records per page. |
| RecordsPerPageSelectPlacement | Determine where the Record Per Page drop down list should appear. |
| RequiredFieldIndicator | Text appearing after a required field. Html code is allowed. |
| RowClickAction | Action to take when user clicks a row. |
| RowRollOverEffect | Whether mouse row roll over effect in the grid should be enabled. |
| Scroll | Enable scrollable grid |
| ScrollBarWidth | Width of dummy filler column header at the very right used for scrolling grids. |
| ScrollHeight | The height of the scrollable area of the grid. |
| Site (inherited from Control) | Gets information about the Web site to which the server control belongs. |
| SQL | The main SQL SELECT statement for this grid and form. For stored procedures, just type in the Stored Procedure name. |
| StoredProcCommand | If a stored procedure name is set in the SQL property, the stored procedure parameters can be set through this object afterwards. |
| Style (inherited from WebControl) | Gets a collection of text attributes that will be rendered as a style attribute on the outer tag of the Web server control. |
| TabIndex | |
| TableTag | Additional HTML attributes for the form and grid Html TABLE tag. |
| Tag | The AxpDataGrid unique Tag. Unique values are set automatically from Version 2 of the grid |
| TDEvenTag | Additional HTML attributes for TD cells of even numbered rows. |
| TDOddTag | Additional HTML attributes for TD cells of odd numbered rows. |
| TDTag | Additional HTML attributes for the Data Cell (TD tag). |
| TemplateSourceDirectory (inherited from Control) | Gets the virtual directory of the Page or UserControl that contains the current server control. |
| THTag | Additional HTML attributes for the Column Header (TH tag). |
| ToolTip | |
| ToRow | Gets the row number of the last record on current page. |
| UniqueID (inherited from Control) | Gets the unique, hierarchically-qualified identifier for the server control. |
| UseDataBinding | Set to True to disable the automatic built in data binding of the AxpDataGrid control |
| Visible (inherited from Control) | Gets or sets a value that indicates whether a server control is rendered as UI on the page. |
| Width (inherited from WebControl) | Gets or sets the width of the Web server control. |
Protected Instance Properties
 ChildControlsCreated (inherited from Control) | Gets a value that indicates whether the server control's child controls have been created. |
| Context (inherited from Control) | Gets the HttpContext object associated with the server control for the current Web request. |
| Events (inherited from Control) | Gets a list of event handler delegates for the control. This property is read-only. |
| HasChildViewState (inherited from Control) | Gets a value indicating whether the current server control's child controls have any saved view-state settings. |
| IsTrackingViewState (inherited from Control) | Gets a value that indicates whether the server control is saving changes to its view state. |
| TagKey (inherited from WebControl) | Gets the HtmlTextWriterTag value that corresponds to this Web server control. This property is used primarily by control developers. |
| TagName (inherited from WebControl) | Gets the name of the control tag. This property is used primarily by control developers. |
| ViewState (inherited from Control) | Gets a dictionary of state information that allows you to save and restore the view state of a server control across multiple requests for the same page. |
| ViewStateIgnoresCase (inherited from Control) | Gets a value that indicates whether the StateBag object is case-insensitive. |
See Also
AxpDataGrid Class | Axezz.WebControls Namespace