CN106919687A - A kind of general internal storage data table row turns the implementation method of row displaying - Google Patents
A kind of general internal storage data table row turns the implementation method of row displaying Download PDFInfo
- Publication number
- CN106919687A CN106919687A CN201710122025.2A CN201710122025A CN106919687A CN 106919687 A CN106919687 A CN 106919687A CN 201710122025 A CN201710122025 A CN 201710122025A CN 106919687 A CN106919687 A CN 106919687A
- Authority
- CN
- China
- Prior art keywords
- row
- data
- conversion
- displaying
- data table
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
- G06F16/211—Schema design and management
- G06F16/213—Schema design and management with details for schema evolution support
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/26—Visual data mining; Browsing structured data
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- User Interface Of Digital Computer (AREA)
Abstract
The invention discloses the implementation method that a kind of general internal storage data table row turns row displaying, belong to Computer Applied Technology field.The quick realization row of categorical data turn is arranged and the GridView using many gauge outfits is shown, implementation method is comprised the following steps：Ranks conversion requirements are set, are capable of the conversion requirements of self-defined row turn row, including row packet row, column split row and data display row；Enter every trade to tables of data according to conversion requirements and turn row operation；According to conversion requirements to creating many gauge outfit GridView；Realize change data binding and displaying.Internal storage data table quickly can be entered every trade and turn row operation, many gauge outfit GridView of Initialize installation by the present invention, and most data are shown according to agreement form at last.
Description
Technical field
The present invention relates to Computer Applied Technology field, specifically a kind of general internal storage data table row turns row displaying
Implementation method.
Background technology
Data display occupies an important position in software systems.How intuitively display data, allow system user of service
Quick traveling to data receives and makes comparative analysis, and then provides aid decision opinion, is the difficulty that software systems are frequently encountered
Topic.Data row turns row, is a problem being commonly encountered in data display, it is especially desirable to which the data of analysis are non-numeric type
When.Entering every trade turn row displaying currently for numeric data has had the control realization of maturation, but for the data of nonumeric type
Enter every trade and turn row displaying also without ripe control, cause categorical data row to turn when row show, it is necessary to the development process of complexity,
Development efficiency is low, increases many development amounts.
The content of the invention
Technical assignment of the invention is directed to above weak point, there is provided a kind of general internal storage data table row turns row displaying
Implementation method, internal storage data table quickly can be entered into every trade and turn row operation, many gauge outfit GridView of Initialize installation, and finally
Data are shown according to agreement form.
The technical solution adopted for the present invention to solve the technical problems is：
A kind of general internal storage data table row turns the implementation method of row displaying, and the quick realization row of categorical data is turned to arrange and utilize
The GridView of many gauge outfits is shown, and implementation method is comprised the following steps：
1）, set ranks conversion requirements, be capable of self-defined row turn row conversion requirements, including row packet row, column split row sum
Arranged according to displaying；
2）, enter according to conversion requirements every trade to tables of data and turn row operation, can be according to step 1）The conversion for requiring definition will
Ask, data are carried out into conversion operation；
3）, according to conversion requirements to creating many gauge outfit GridView, can be according to step 1）The conversion requirements for requiring definition,
Creating the GridView of many gauge outfits is used to show step 2）Described transformation result；
4）, realize change data binding with displaying, can be by step 2）The transformation result of the requirement, is tied to step 3）It is described
It is required that creating the GridView of many gauge outfits.
Further, ranks conversion requirements are, according to source data table and business need, to be respectively provided with the row point that conversion needs
Group row, column split row and data display are arranged.
Further, enter every trade to tables of data according to conversion requirements and turn row operation according to the conversion requirements for setting, create new
Tables of data, and source data table data are filled to new data table according to rule, complete ranks conversion.
Further, many gauge outfit GridView are created according to conversion requirements, according to the conversion requirements for setting, creates many gauge outfits
GridView, dynamic creation row packet row and column split row and data display row.
Further, data binding and displaying are realized, the new data table of conversion is tied to many gauge outfits of establishment
GridView, completes data display.
A kind of general internal storage data table row of the invention turn row displaying implementation method compared to the prior art, with
Lower beneficial effect：
Internal storage data table quickly can be entered into every trade and turn row operation, many gauge outfit GridView of Initialize installation, and most data at last
It is shown according to agreement form, reduces development amount, lifts development efficiency.
Specific embodiment
With reference to specific embodiment, the invention will be further described.
A kind of general internal storage data table row turns the implementation method of row displaying, and row are turned simultaneously to the quick realization row of categorical data
It is shown using the GridView of many gauge outfits, implementation method is comprised the following steps：
1）, set ranks conversion requirements, be capable of self-defined row turn row conversion requirements, including row packet row, column split row sum
Arranged according to displaying；
2）, enter according to conversion requirements every trade to tables of data and turn row operation, can be according to step 1）The conversion for requiring definition will
Ask, data are carried out into conversion operation；
3）, according to conversion requirements to creating many gauge outfit GridView, can be according to step 1）The conversion requirements for requiring definition,
Creating the GridView of many gauge outfits is used to show step 2）Described transformation result；
4）, realize change data binding with displaying, can be by step 2）The transformation result of the requirement, is tied to step 3）It is described
It is required that creating the GridView of many gauge outfits.
Ranks conversion requirements are, according to source data table and business need, to be respectively provided with the row packet row that conversion needs, row point
Group row and data display row；
Enter every trade to tables of data according to conversion requirements and turn row operation according to the conversion requirements for setting, create new tables of data, and press
Source data table data are filled to new data table according to rule, completes ranks conversion；
Many gauge outfit GridView are created according to conversion requirements, according to the conversion requirements for setting, many gauge outfit GridView, dynamic is created
Create row packet row and column split row and data display row；
Data binding and displaying are realized, the new data table of conversion is tied to many gauge outfit GridView of establishment, complete data exhibition
Show.
The inventive method is applied to the programming realization of C# programs, and implementation process is as follows：
1st, transformation rule is defined
/// <summary>
///source data table, for storing the tables of data for needing ranks to change
/// </summary>
public DataTable SourceTable
{
get;
set;
}
/// <summary>
///change data result
/// </summary>
public DataTable ResultTable
{
get;
set;
}
/// <summary>
///for setting row packet row
/// </summary>
public List<string> ListRowFields
{
get;
set;
}
/// <summary>
///for setting column split row
/// </summary>
public List<string> ListColumnFields
{
get;
set;
}
/// <summary>
///for setting data display row
/// </summary>
public List<string> ListDataFields
{
get;
set;
}
In this example, setting row packet is classified as square billet numbering, and setting column split is classified as test event and test condition, data display
Whether it is classified as and tests.
2nd, data table transmition is realized
/// <summary>
///data row turns row and realizes
/// </summary>
/// <returns></returns>
public void ConvertTable()
{
}
Statement method ConvertTable () is used to realize the ranks conversion of internal storage data table, and is stored in the change of step 1 statement
In amount ResultTable.Specific conversion is as follows：
1）, create tables of data（DataTable）ResultTable；
2）, according to step 1 set ListRowFields, create ResultTable row grouped data row；
3）, according to step 1 set ListColumnFields and ListDataFields, create ResultTable data
Displaying row；
4）, by the data of raw data table SourceTable according to rule filling to ResultTable tables.
3rd, many gauge outfit GridView are created, and binds displaying
/// <summary>
///create many gauge outfit view
/// </summary>
/// <param name="view"></param>
public void CreateShowView(ref AdvBandedGridView view)
{
}
/// <summary>
///binding data
/// </summary>
/// <param name="gridControl"></param>
public void BandViewSource(ref GridControl gridControl)
{
}
Statement method CreateShowView (ref AdvBandedGridView view) is used to realize creating many gauge outfit forms；
Statement method BandViewSource (ref GridControl gridControl) is used to tie up the result that ranks are changed
Surely many gauge outfit forms are arrived.
Create many gauge outfits and binding step is as follows：
1）, state many gauge outfits（AdvBandedGridView）Variable view is used to show converting result data；
2）, according to step 1 set ListRowFields, dynamic creation view row grouped data row；
3）, according to step 1 set ListColumnFields and ListDataFields, the data display of dynamic creation view
Row；
4）, call BandViewSource methods realize data binding displaying.
By specific embodiment above, the those skilled in the art can readily realize the present invention.But should
Work as understanding, the present invention is not limited to above-mentioned specific embodiment.On the basis of disclosed embodiment, the technical field
Technical staff can be combined different technical characteristics, so as to realize different technical schemes.
In addition to the technical characteristic described in specification, the known technology of those skilled in the art is.
Claims (5)
1. a kind of general internal storage data table row turns the implementation method of row displaying, it is characterised in that to the quick realization of categorical data
Row turns to arrange and the GridView using many gauge outfits is shown, and implementation method is comprised the following steps：
1）, set ranks conversion requirements, be capable of self-defined row turn row conversion requirements, including row packet row, column split row sum
Arranged according to displaying；
2）, enter according to conversion requirements every trade to tables of data and turn row operation, can be according to step 1）The conversion for requiring definition will
Ask, data are carried out into conversion operation；
3）, according to conversion requirements to creating many gauge outfit GridView, can be according to step 1）The conversion requirements for requiring definition,
Creating the GridView of many gauge outfits is used to show step 2）Described transformation result；
4）, realize change data binding with displaying, can be by step 2）The transformation result of the requirement, is tied to step 3）It is described
It is required that creating the GridView of many gauge outfits.
2. a kind of general internal storage data table row according to claim 1 turns the implementation method of row displaying, it is characterised in that
Ranks conversion requirements be according to source data table and business need, be respectively provided with conversion need row packet row, column split row and
Data display is arranged.
3. a kind of general internal storage data table row according to claim 1 turns the implementation method of row displaying, it is characterised in that
Enter every trade to tables of data according to conversion requirements and turn row operation according to the conversion requirements for setting, create new tables of data, and according to rule
Then source data table data are filled to new data table, ranks conversion is completed.
4. a kind of general internal storage data table row according to claim 1 turns the implementation method of row displaying, it is characterised in that
Many gauge outfit GridView are created according to conversion requirements, according to the conversion requirements for setting, many gauge outfit GridView, dynamic creation is created
Row packet row and column split row and data display row.
5. a kind of general internal storage data table row according to claim 1 turns the implementation method of row displaying, it is characterised in that
Data binding and displaying are realized, the new data table of conversion is tied to many gauge outfit GridView of establishment, complete data display.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710122025.2A CN106919687A (en) | 2017-03-03 | 2017-03-03 | A kind of general internal storage data table row turns the implementation method of row displaying |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710122025.2A CN106919687A (en) | 2017-03-03 | 2017-03-03 | A kind of general internal storage data table row turns the implementation method of row displaying |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN106919687A true CN106919687A (en) | 2017-07-04 |
Family
ID=59460271
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710122025.2A Pending CN106919687A (en) | 2017-03-03 | 2017-03-03 | A kind of general internal storage data table row turns the implementation method of row displaying |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106919687A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111352983A (en) * | 2018-12-24 | 2020-06-30 | 深圳市优必选科技有限公司 | Service attribute dynamic expansion method and device, computer equipment and storage medium |
| CN112506942A (en) * | 2020-10-29 | 2021-03-16 | 望海康信(北京)科技股份公司 | Data combination query method, system and corresponding equipment and storage medium |
-
2017
- 2017-03-03 CN CN201710122025.2A patent/CN106919687A/en active Pending
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111352983A (en) * | 2018-12-24 | 2020-06-30 | 深圳市优必选科技有限公司 | Service attribute dynamic expansion method and device, computer equipment and storage medium |
| WO2020132890A1 (en) * | 2018-12-24 | 2020-07-02 | 深圳市优必选科技有限公司 | Service attribute dynamic expansion method, apparatus, computer device, and storage medium |
| CN112506942A (en) * | 2020-10-29 | 2021-03-16 | 望海康信(北京)科技股份公司 | Data combination query method, system and corresponding equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106919687A (en) | A kind of general internal storage data table row turns the implementation method of row displaying | |
| CN105141998B (en) | A kind of intelligent television voice remote controller control method and system based on DLNA | |
| CN102790918A (en) | Smart television and method for receiving remote controller input by smart television | |
| CN102800048A (en) | Electronic map scaling display method | |
| CN112114726B (en) | Interaction method, device, equipment and medium based on vue drop-down box | |
| CN101539859A (en) | Development method of plug-in board for embedded Konqueor browser based on uCLinux | |
| CN106649889B (en) | Data display method and device | |
| CN104539725B (en) | A kind of method that APP applications to generation carry out cluster packing | |
| CN103177046B (en) | A kind of data processing method based on row storage data base and equipment | |
| CN109213776B (en) | Report form display method and device | |
| CN104461495A (en) | Method and system for separation of data persistence layers | |
| CN103870280B (en) | Webpage seamless combining processing method based on FLEX and JSP | |
| CN103559280A (en) | Method for flexibly storing and displaying icons | |
| WO2011070334A9 (en) | Accessing stored electronic resources | |
| CN104866404B (en) | A kind of general data monitoring method | |
| CN110297945A (en) | Data information processing method and system based on XBRL | |
| CN107045538A (en) | A kind of web terminal based on kettle exchanges management method | |
| CN104955026B (en) | A kind of amending method of the bluetooth of PDA and the MAC Address of WiFi | |
| CN103077028A (en) | Display method and system | |
| CN104735072A (en) | Method and device for logging in user account | |
| CN102799423A (en) | Method and device for implementing dynamic method in JSF (java service face) | |
| CN105184470A (en) | Message mode-based method for integrating task lists of multiple business systems | |
| CN108877806A (en) | System is verified in the test for testing instruction type speech control system | |
| CN103067770B (en) | Television network parameter setting and error correction method | |
| CN108763586B (en) | General data dictionary interface device based on SAP field search help |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| WD01 | Invention patent application deemed withdrawn after publication | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20170704 |