Components of Px Framework:

Row search in the PxWebQuery component according to the value entered and the name of the column where the search shall be carried out

If you need to search in the table of the PxWebQuery component, you can do it via the Find command, see the example below:

    
               if(wquAdresar.Find("%ško%","name")!=-1)

                  lblAdresar3.Text = wquAdresar.Fields["name"].ToString();

Definition of the Find command:

    
                public Int32 Find(string SearchValue,string sFieldName);

Description of the Find command parameters:

The return value of Find command is ItemIndex (row index, which corresponds to the selection criteria) of the PxWebQuery component, if no row is found, the return value then is -1.

SearchValue - value, according to which the search is, in the column specified in the parameters sFieldName. SearchValue value, we can arrange for example. percent "%" functionality is similar to the SQL command "Like"
sFieldName - column name, which is the search string

Then, the PxWebQuery component enables search according to the primary key, please refer to the example below:

    
                 if (wquAdresar.FindByIdPK(6)!=-1)

                    lblAdresar4.Text = wquAdresar.Fields["name"].ToString();

The return value of the FindByIdPK command is ItemIndex (row index, which corresponds to the selection criteria) of PxWebQuery component, if no row is found, the return value then is -1. The valid value of the primary key is entered as a search parameter.

Setting of the cursor position in the row in the PxWebQuery and PxSuperGrid components

Setting of the cursor position in the PxSuperGrid component can be carried out by assigning the 0..RecordCount-1 value to the ItemIndex property of the PxWebQuery component to which the PxSuperGrid component is linked.

    
                  if (wquAdresar.FindByIdPK(6) != -1)

                     wquAdresar.ItemIndex = wquAdresar.FindByIdPK(6);

Selection of several rows that match the selection criteria

The PxWebQuery component allows also to select more than one row, if it is possible due to the selection criteria .
The wquAdresar.DataSource () command returns the DataTable object. The DataTable object supports selection, row selection. For more information please refer to the example below:

    
                  //Statement IDs lines that match selection criteria

             DataRow[] dr = null;

             dr = wquAdresar.DataSource().Select("name like '%a%'", "name");

             ArrayList aList = new ArrayList();

             Int32 iOrdValue = 0;

             for (Int32 iCykl = 0; iCykl < dr.Length; iCykl++)

             {

                //Here are performed DISTINCT

                if (!aList.Contains(dr[iCykl].ItemArray.GetValue(iOrdValue).ToString()))

                {

                   aList.Add(dr[iCykl].ItemArray.GetValue(iOrdValue).ToString());

                }

             }

             string s = String.Empty;

             for (Int32 iCykl2 = 0; iCykl2 < aList.Count; iCykl2++)

             {

                s = s + ", " + aList[iCykl2].ToString();

             }

             lblAdresar5.Text = s;

This routine shall bring us the list of all IDs of the rows, which match the selection criteria, in this case, these are the rows, which contain the letter "a" in the text of "name" column.

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

No.	Example Name	Source Codes	SQL Script
3.1.1 -10.	PxWebQuery - component for database handling, detailed description of work with the PxWebQuery component	Adresar.aspx Adresar.aspx.cs	SQLScript_MySQL.5.1 SQLScript_MySQL.5.0

Others articles of Px Framework:

PxWebQuery - component for working with databases

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

PxEdit - component for data editing, similar to the TextBox component

PxComboBox - component for selecting data from a list, similar to the DropDownList component

PxCheckBox - component for checking the value (Check / UnCheck value)

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

PxGreatRepeater - component for entering data with repeating structure, maximum number of values is limited

PxJSDatePicker - component for the date entry, based on the JavaScript

PxDbNavigator - the component for the work with the PxWebQuery components, row cursor movement, etc.

PxLabel - component for data display

PxCheckBoxList - component to view and select values from the list

PxRadioButtonList - component for view and selection of a value from the list

PxChart - the component for displaying and working with charts

PxFilterView - visual component for filtering the table data contents in the PxWebQuery component

PxUploader - component for uploading binary and text files to the server

PxLogin - component for authorization and logging into the application

Data loading from the Oracle, MSSQL, MySQL, FireBird, Interbase database by means of the PxWebQuery components

Program inserting, editing or deleting of row into the database by means of the PxWebQuery component

Loading values from the PxWebQuery component via the while cycle

Row search in the PxWebQuery component according to the value entered and the name of the column where the search shall be carried out

The "ReOpen" procedure of the PxWebQuery component and data re-load into the PxWebQuery component

Validation, checking of the entered values by means of the PxWebQuery component and other visual components (PxEdit, PxComboBox, etc.)

Events of the PxWebQuery component

A special function GetValueFromStructKey of the PxWebQuery component

Setting the language mutation of the Px Framework

Finding the current version of the 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

Home Px Framework Download FAQ Contact Forum
Home Px Framework Download FAQ Contact Forum	English	Slovak

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

Menu:

Row search in the PxWebQuery component according to the value entered and the name of the column where the search shall be carried out

Setting of the cursor position in the row in the PxWebQuery and PxSuperGrid components

Selection of several rows that match the selection criteria