en_lang.jpg, 1 kB sk_lang.jpg, 1 kB
English Slovak

      Px Framework - ASP.NET components for rapid development of database applications


Menu:



Components of Px Framework:


PxSuperGrid - component for the direct display of data in the table



PxSuperGrid component serves for the direct display of data in the table by means of the PxWebQuery components. Using the PxSuperGrid components it can operate data as follows: You can insert new rows, edit or delete already existing rows. Further, the component enables automatic sorting and paging.

The following example shows how to use the PxSuperGrid. First, load data from the to the PxWebQuery component, which is opened by the "Open()" command and then bind this component, connect it to the PxSuperGrid component.

protected void Page_Load(object sender, EventArgs e)
{
  if ((!IsPostBack)&&(wquAdresar.Active==false))
  {
    wquAdresar.ConnectString = "User Id=adr;Password=aa;Data Source=xe;";
    wquAdresar.SQLSelect = "select idadresar , name, address, create_date from Adresar";

    wquAdresar.Open();
  }
  grdAdresar.PxDataSource = wquAdresar;
  grdAdresar.DataBind();
}


adresar.aspx file:

<Prx:PxWebQuery ID="wquAdresar" runat="server" Value="wquAdresar"/>

<Prx:PxSuperGrid ID="grdAdresar" runat="server"
  PageSize="4"
  PxVisibleButtons="SIDEO">
</Prx:PxSuperGrid>

To change the caption in the PxSuperGrid(Title) table, write the following code in the *. aspx.cs file, assigned to the PxWebQuery component, property Caption.

wquAdresar.Columns["NAME"].Caption = "Name";

To change the display of buttons in the PxSuperGrid (make them visible or hide them), use the PxVisibleButtons property of the PxSuperGridu component.

grdAdresar.PxVisibleButtons="SIDEO";

The further example describes the legend according to which the individual buttons are displayed. If there is any letter there, the relevant button is displayed in the PxSuperGrid.

S - select, row selection
I - insert or enter a new row
E - editing an existing row
D - deleting an existing row
O - open information form


Description of the PxSuperGrid buttons:
Button edit - this button is used to edit an existing row (E)
Button delete - this button is used to delete an existing row (D)
Button select - this button is used for selection, row selection (S)
Button info - this button is used to open the information form, it is mainly used to view details of the row (O)
Button insert - this button is used to add a new row (I)


Image of PxSuperGrid components:
Image components PxSuperGrid


Image PxSuperGrid components, in state editing:
Image components PxSuperGrid-edit


Image PxSuperGrid components in the state of editing, when the PxWebQuery component is applied method AddParamKey:
Image components PxSuperGrid-edit




The PxSuperGrid component supports the view of the number of lines in the lower right corner. This display can be activated through the VisibleRecordCount property when it is set to "true". Text can be changed through the property CaptionRecordCount.

grdAdresar.VisibleRecordCount = true;
grdAdresar.CaptionRecordCount = "Number of Records:";


The display of the number of rows in the PxSuperGrid component you can see in the picture below:

Image components PxSuperGrid-Record Count


If we want to enter the title of the PxSuperGrid component column (ToolTip), we can do this through the property Header.ToolTip. If we want to change the column name, we can do this through the property Header.Text. If we want to disable sorting for that column, we can use the Header.NoSort property and set it to "true". Similarly, through the Header.ReadOnly property, we can disable editing the column in the PxSuperGrid component. Assignment of these properties must be done before the PxWebQuery component is assigned to the PxDataSource property.

grdAdresar.Header["name"].ToolTip = "Zadajte právnu formu !!!";
grdAdresar.Header["name"].NoSort = true;
grdAdresar.Header["name"].Text = "Právna Forma";
grdAdresar.Header["ID"].ReadOnly = true;


This picture shows an example of the assignment of the above mentioned properties.

Image components PxSuperGrid-ToolTip


The PxSuperGrid component contains the DateFormat property, by which we can control the date display in columns of the DateTime type in the PxSuperGrid component. If we want to show also the time next to the date in the grid, we use the mask "d.M.yyyy H:mm:ss", which we enter into the DataFormat property.

grdTyp_Uloziska.DateFormat = "d.M.yyyy H:mm:ss";


If we want to display only date, we use the mask "dd.MM.yyyy". If we want to edit the date in the grid, we better use the mask "dd.MM.yyyy", because the automatic validation would stop data storing if we did not enter the correct date also with zeros. The example of data entering is shown below.

An example of the mask and then the input value in order to save the value correctly and avoid stopping the storing process through automatic validation.

"d.M.yyyy H:mm:ss"   -> 1.1.2011 0:00:00
"dd.MM.yyyy H:mm:ss" -> 01.01.2011 0:00:00
"dd.MM.yyyy"         -> 1.1.2011


The PxSuperGrid component (as well as PxEdit, PxComboBox, PxFlyComboBox, PxJSDatePicker, etc.) contains and supports automatic and complementary validation.
If the table column linked to the PxSuperGrid component is of the string type, validation of the string length is automatically carried out, if it is of the int type, validation operation to check whether the integer has been entered is carried out, in case of the date type, validation operation to check whether the valid date has been entered is carried out, etc. For more information about the automatic validation, see the Part II of this reference manual.

The picture below shows an example where we have entered a string which length exceeded the length of string defined in the database. Then we have entered an invalid date.

Image components PxSuperGrid-Validation


When move the cursor on the mouse over the icon with an exclamation mark, a tooltip displays an error message of the error that stopped deposition. In this case a correct date has not been entered.



Here is a functional example of the PxSuperGrid component, even with source code. This functional example on this site runs on MySQL 5.0 database.

No. Example Name Source Codes SQL Script
1.1. Adresar.aspx
Adresar.aspx.cs
SQLScript_MySQL.5.1
SQLScript_MySQL.5.0



Others articles of Px Framework:



It doesn't the intention of this part website, describe in detail the work with PxFramework components, a detailed description of the component available in manual, which can be downloaded here: Download manual of Px Framework