Home   Px Framework   Download   FAQ   Contact   Forum
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:


PxFlyComboBox - set of the consecutively linked comboboxes, suitable for the work with structured data (for example: selection of category and subcategory)



The PxFlyComboBox component serves for value selection in case of structured lists, it is mostly used when an object is integrated into a category and subcategory. The PxFlyComboBox component may consist of several mutually related comboboxes (DropDownList components). There can be an optional number of such comboboxes - from 2 to n. See the picture below:

Picture komponent of PxFlyComboBox


The picture shows selection of the name of the municipality. Since there are nearly 3000 municipalities in Slovakia, it would have been difficult to choose from such list. The PxFlyComboBox component shall save the labour here. When the particular region is selected, only districts filtered for the given region shall be displayed in the combobox "district". When the certain district is chosen, only municipalities filtered for the given district shall be displayed in the combobox.
However it is quite difficult to program such thin, but the PxFramework provides quick and cheap solution.

For the correct functioning of the PxFlyComboBox component, it is necessary to apply the AddParamFlyComboBox parameter to the given PxWebQuery component, which shall display or work with such structured data. The definition of the AddParamFlyComboBox parameter is as follows:

wquAdresar.AddParamFlyComboBox("miesto", "idkraj;idokres;idobec",
            "idkraj;idokres;idobec", "kraj;okres;obec",
            "Obec;Okres", "wquObec", "mvStandard");

Description of the parameters of the AddParamFlyComboBox method:
C# syntax:

public void AddParamFlyComboBox(string aFieldName, string aKeyFields,
            string aKeyDetailFields, string aValueFields,
            string aFieldToView, string aPxWebQueryName,
            string aModeToView)


Description of the parameters:

aFieldName - Name of the column, which is created as a new column in the table and to which the AddParamFlyComboBox method is applied and which is then liked to the PxFlyComboBox component (this column name must be unique, no other table column with such name shall exist).
aKeyFields - String value to which keys of the main table columns are defined , to which during editing via the PxFlyComboBox the IDs are entered, in our case these are the IdKraj, IdOkres and IdObec. These columns are entered consequently in the way they are to be displayed in the PxFlyComboBox component. Individual columns are separated by a semicolon.
aKeyDetailFields - String value to which keys of the classifier table columns are defined, from which during editing via the PxFlyComboBox component the IDs are loaded and entered to the main table. In our case these are the IdKraj,IdOkres and IdObec columns. These columns are entered consequently in the way they are to be displayed in the PxFlyComboBox component. Individual columns are separated by a semicolon.
aValueFields - String value to which values of the classifier table columns are defined, which are displayed in the PxFlyComboBox component during editing via this component. In our case these are the IdKraj,IdOkres and IdObec columns. These columns are entered consequently in the way they are to be displayed in the PxFlyComboBox component. Individual columns are separated by a semicolon.
aFieldToView - String value, which defines the names of the columns that are displayed in PxSuperGrid component, under the aFieldName column. Summary or listing of these columns may not be complete. These columns are entered consequently in the way they are to be displayed in the PxSuperGrid component. Individual columns are separated by a semicolon.
aPxWebQueryName - Name of the PxWebQuery component, where the classifier of Region (Kraj), District(Okres) and Minicipality(Obec) is loaded. The classifier is formed by merging of three classifiers, in our case they are as follows: Ckraj, Cokres, CObec.
aModeToView - This string defines data display in the PxSuperGrid component, in our case of the column defined in the aFieldName entry. The existing display modes are as follows: mvValueBR, mvNameAndBR a mvNormal.

If the "Obec;Okres" string is entered to the FieldToView entry and the mvNormal, display mode is selected, the display in the PxSuperGrid component shall look like this:

Obrázok zobrazenia PxSupergridu pri aplikovaný parametru AddParamFlyCombobox


If the "Obec;Okres" string is entered to the FieldToView entry and the mvValueBR, display mode is selected, the display in the PxSuperGrid component shall look like this:

Obrázok zobrazenia PxSupergridu pri aplikovaný parametru AddParamFlyCombobox


If the "Obec;Okres" string is entered to the FieldToView entry and the mvNameAndBR, display mode is selected, the display in the PxSuperGrid component shall look like this:

Obrázok zobrazenia PxSupergridu pri aplikovaný parametru AddParamFlyCombobox


If the "Obec;Okres;Kraj" string is entered to the FieldToView entry and the mvNameAndBR, display mode is selected, the display in the PxSuperGrid component shall look like this:

Obrázok zobrazenia PxSupergridu pri aplikovaný parametru AddParamFlyCombobox


Total PxSuperGrid component display shall be as follows:

Obrázok zobrazenia PxSupergridu Full pri aplikovaný parametru AddParamFlyCombobox


But let us return to a particular programming with the PxFlyComboBox component, our example of Databank Names and Companies.

To apply the AddParamFlyComboBox parameter to the wquAdresar component, it is necessary to create new PxWebQuery component, which shall be called wquObec.

Add this new component to the Adresar.aspx file and the definition shall look like this:

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

Don't forget to define the Obec component before the wquAdresar component.

Then in the Adreasar.aspx.cs file load data to the wquObec component, and then link this component to the wquAdresar component via the AddParamFlyComboBox parameter. During definition of the wquObec component, create a special SQL select, which shall combine the following three tables: Ckraj, Cokres, CObec.
This SQL command shall be as follows:

select
  COBEC.ID_OBEC as IDOBEC, COBEC.NAZOV_OBEC as OBEC,
  COBEC.ID_OKRES as IDOKRES, COKRES.NAZOV_OKRES as OKRES,
  COBEC.ID_KRAJ as IDKRAJ,CKRAJ.NAZOV_KRAJ as KRAJ
from
  COBEC,COKRES,CKRAJ
where
  COBEC.ID_OKRES=COKRES.ID_OKRES and
  COBEC.ID_KRAJ=CKRAJ.ID_KRAJ

The table resulting from this SQL command shall look like the one in the picture below:

Tabulka - sumár tabuliek CObec, COkres, CKraj


The PxFlyComboBox component can work with such table fairly well. The next image contains listing of the Adresar.aspx.cs file source code for filling data of the wquObec component and its liking to the wquAdresar component via the AddParamFlyComboBox parameter.

protected void Page_Load(object sender, EventArgs e)
{
  if ((!IsPostBack) && (wquObec.Active == false))
  {
    wquObec.ConnectString = "User Id=tiger;Password=aa;Data Source=xe;";
    wquObec.SQLSelect = @"select COBEC.ID_OBEC as IDOBEC, COBEC.NAZOV_OBEC as OBEC,
      COBEC.ID_OKRES as IDOKRES, COKRES.NAZOV_OKRES as OKRES,
      COBEC.ID_KRAJ as IDKRAJ,CKRAJ.NAZOV_KRAJ as KRAJ
    from
      COBEC,COKRES,CKRAJ
    where COBEC.ID_OKRES=COKRES.ID_OKRES and
      COBEC.ID_KRAJ=CKRAJ.ID_KRAJ";
    wquObec.Open();
    wquObec.Columns["IDOBEC"].Caption = "Id Municipality";
    wquObec.Columns["OBEC"].Caption = "Municipality";
    wquObec.Columns["IDOKRES"].Caption = "Id District";
    wquObec.Columns["OKRES"].Caption = "District";
    wquObec.Columns["IDKRAJ"].Caption = "Id Region";
    wquObec.Columns["KRAJ"].Caption = "Region";
  }
  if ((!IsPostBack)&&(wquAdresar.Active==false))
  {
    string sSQLText1 = "select IDPravForm as Key, Name as Value from PravForm Order By Value";
    wquAdresar.ConnectString = "User Id=skodapeter;Password=aa;Data Source=xe;";
    wquAdresar.SQLSelect = @"select idadresar , name, address, idpravnaforma,
      create_date, invalid_adress, idkraj,
      idokres, idobec from Adresar03";

    wquAdresar.AddParamKey("idpravnaforma", "Key", "Value", "Value", "Key", sSQLText1);
    wquAdresar.AddParamCheck("invalid_adress", "A", "N", false);
    wquAdresar.AddParamFlyComboBox("miesto", "idkraj;idokres;idobec",
      "idkraj;idokres;idobec", "kraj;okres;obec",
      "Obec;Okres;Kraj", "wquObec", "mvNameAndBR");

    wquAdresar.Open();
    wquAdresar.Columns["idadresar"].Caption = "ID";
    wquAdresar.Columns["name"].Caption = "Persons Name";
    wquAdresar.Columns["idpravnaforma"].Caption = "Juridical form";
    wquAdresar.Columns["address"].Caption = "Street";
    wquAdresar.Columns["create_date"].Caption = "Date of Establishment";
    wquAdresar.Columns["invalid_adress"].Caption = "Invalid address";
    wquAdresar.Columns["miesto"].Caption = "Municipality, District";
  }
  else
  {
  }
  grdAdresar.PxDataSource = wquAdresar;
  grdAdresar.DataBind();
}

If you want to use the PxFlyComboBox component for editing in the AddAdresar.aspx form, it shall be defined in this file as follows:

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

<Prx:PxEdit ID="edtIDADRESAR" runat="server" AddTableRow="True" TableBegin="True" ></Prx:PxEdit>
<Prx:PxEdit ID="edtName" runat="server" AddTableRow="True" ></Prx:PxEdit>
<Prx:PxComboBox ID="cmbPravnaForma" runat="server" AddTableRow="True" ></Prx:PxComboBox>
<Prx:PxJSDatePicker ID="edtCREATE_DATE" runat="server" AddTableRow="True" ></Prx:PxJSDatePicker>
<Prx:PxCheckBox ID="chkInvalid_Adress" runat="server" AddTableRow="True" ></Prx:PxCheckBox>
<Prx:PxEdit ID="edtADDRESS" runat="server" AddTableRow="True" TableEnd="True"></Prx:PxEdit>
<Prx:PxFlyComboBox ID="fcmbMiesto" runat="server"></Prx:PxFlyComboBox>

Link the PxFlyComboBox component to the wquAdresar component in the AddAdresar.aspx.cs file as follows:

fcmbMiesto.PxDataSource = wquAdresar; fcmbMiesto.FieldName = "miesto";

The PxFlyComboBox component does not support alignments and AddTableRow, TableBegin TableEnd properties, which are supported by other components like PxEdit, etc.

During the definition in the AddAdresar.aspx file do not forget to define besides the PxFlyComboBox component line, the wquObec component, because in other case, the PxFlyComboBox component shall not be displayed in the AddAdresar.aspx form.

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

If everything is set up correctly, the resulting AddAdresar.aspx form shall look like this:

Obrázok zobrazenia PxFlyCombobox formulár


Titles in the Grid and captions in the PxFlyComboBox component, can be defined centrally during the definition of the wquObec component:

wquObec.Columns["IDOBEC"].Caption = "Id Municipality";
wquObec.Columns["OBEC"].Caption = "Municipality";
wquObec.Columns["IDOKRES"].Caption = "Id District";
wquObec.Columns["OKRES"].Caption = "District";
wquObec.Columns["IDKRAJ"].Caption = "Id Region";
wquObec.Columns["KRAJ"].Caption = "Region";


The PxFlyComboBox component contains a function through which we can find the set value of individual comboboxes. This method is called GetValue function.

Description of the parameters of the GetValue function:
C# syntax:

public string GetValue(string aFieldName);


Description of the parameters:

FieldName - name of the column which belongs to a given combobox in the PxFlyComboBox component. Usually these are the names of the columns that were specified in the AddParamFlyComboBox parameter, namely those which have been entered into the expression aKeyFields, aKeyDetailFields or aValueFields.

Example of use of the GetValue function:

string sGetVal = fcmbMiesto.GetValue("IdOkres");


In this example the GetValue function returns the value of the set district, which is set in the combobox, which is selected from a list of the districts.



Here is a functional example of the PxFlyComboBox 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.7.
PxFlyComboBox - series-connected combo boxes, suitable for work with structural data (for example, category and subcategory selection)
 Adresar.aspx
Adresar.aspx.cs
AddAdresar.aspx
AddAdresar.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



All rights reserved PROXIMA SOFT 2003-2011.
counter