Home → Index ← Admin ← Rss

CYQ.Data components

CYQ.Data support multi-database application [Txt,Xml,Access, MSSQL, Oracle,SQLite,MySql], help easily and quickly to develop your project

CYQ.Data Components Getting Started Guide [Part 2]-[MAction Data Query- Fill And Select]

Guide | | | pubdate :2011/7/2 17:11:28#TopicOwner  

In this section: [with * content for the new version of the performance function, the old version might not have this feature]

Benpian continue on a content, this section describes the use of all relevant queries.
 
 Main Summary:
 
 1: Fill one-line data manipulation operations and GetCount, Exists (*) operation.
 
 2: Select multiple lines of data manipulation operations
 
 3: list-bound controls operate with the paging controls
 
 4: multi-table query and bind the view and custom SQL
 

Single data operation

I：Fill - a single query

Method Prototype：public bool Fill(object where)

Example 1: Direct ID

using(MAction action = new MAction(TableNames.Users))
{
        if (action.Fill(888))//Query ID = 888 one-way data
        {
                action.SetTo(lblUserName);
        }
}

Example 2: where conditions for transmission

using(MAction action = new MAction(TableNames.Users))
{
        if (action.Fill("id=888 or UserName='cyqdata"))//Query  ID=888 or UserName is "cyqdata" one-way data
        {
                action.SetTo(lblUserName);
        }
}

Example 3: where conditions are attached order by

using(MAction action = new MAction(TableNames.Users))
{
        if (action.Fill("id>888 order by id desc"))//Query  ID>888' result，ID to take the results of the largest single data
        {
                action.SetTo(lblUserName);
        }
}

Example 4: MDataRow line data transfer entity

using(MAction action = new MAction(TableNames.Users))
{
        if (action.Fill("888"))
        {
                 UserInfo info=action.Data.ToEntity<UserInfo>();//UserInfo transfer entity。 
        }
}

II：GetCount -Take the total number of statistics

Method Prototype：public int GetCount(string where)

Example ：

using(MAction action = new MAction(TableNames.Users))
{
        int count=action.GetCount("id>10");
}

III：Exists - The existence of the conditions specified data (*)

Method Prototype：public int Exists(string where)

Example ：

using(MAction action = new MAction(TableNames.Users))
{
        bool userExists=action.Exists("UserName='cyqdata'");
}

 

Multi-line data manipulation

Ⅳ：Select - Multiple Data Query

Method Prototype：
1：public MDataTable Select()
2：public MDataTable Select(string where)（*）
3：public MDataTable Select(int PageIndex, int PageSize, string Where, out int RowCount)

Example 1：

using(MAction action = new MAction(TableNames.Users))
{
       MDataTable tabme = action.Select();//Select All Data
}

Example 2：

using(MAction action = new MAction(TableNames.Users))
{
       MDataTable tabme = action.Select("id>10 order by id desc");//Select data by where
}

Example 3：

int count;// return record count
using(MAction action = new MAction(TableNames.Users))
{
       MDataTable tabme = action.Select(1，10，"id>10 order by id desc"，out count);
       //Select Data by where and with pager
}

 

List of bind operation

Ⅴ：Bind To GridView/DataList/Repeater

Example 1： Select All And Bind To List Control

using(MAction action = new MAction(TableNames.Users))
{
        action.Select().Bind(gvUsers);
}

Example 2：Bind with paging controls

[Down Paging Control：http://www.cyqdata.cn/download/article-detail-28683]

public void BindData()
{
        int count;
        using(MAction action = new MAction(TableNames.Users))
        {
                action.Select(Pager1.PageIndex，Pager1.PageSize，"id>10 order by id desc"，out count).Bind(gvUsers);
        }
         Pager1.Count = count;//Set Record Count
         Pager1.BindName = "BindData";//Bind Method Name，Symbols need to modify Public
}

 

Multi-table query and bind

Ⅵ：View Way

Example 1：And operation of the same table, the only difference is the name of the table name into view

using(MAction action = new MAction(ViewNames.V_Users))
{
       MDataTable tabme = action.Select();//Select All View Data
}

 

Ⅶ：Multi-table query: Customize multi-table SQL statement construct

Example 1：

public void BindData()
{
        string customTable = "(select u.*,m.Body from Users u left join Message m on u.ID=m.UserID) v";

        int count;
        using(MAction action = new MAction(customTable))
        {
                action.Select(Pager1.PageIndex，Pager1.PageSize，"id>10 order by id desc"，out count).Bind(gvUsers);
        }
         Pager1.Count = count;
         Pager1.BindName = "BindData";
}

Description:

In the specific use, in order to facilitate the management, directly in a custom SQL statement is not written directly in the interface so, you can build a new item unified project management custom SQL.

Chinese version of the link：http://www.cyqdata.cn/cyqdata/article-detail-412

More tutorials：

1：CYQ.Data Components Getting Started Guide [Part 1]

2：CYQ.Data Components Getting Started Guide [Part 2]-[MAction Data Query- Fill And Select]

3：CYQ.Data Components Getting Started Guide [Part 3]-[MAction Get And Set Value]

4：CYQ.Data Components Getting Started Guide [Part 4]-[MAction Insert Delete Update]

5：CYQ.Data Components Getting Started Guide [Part 5]-[MProc Execute Stored Procedures or SQL]



Anderson[176.31.68.*]2012/6/6 11:01:34#1
altazar / Проверил сейчас. Прежний HUD возвращается, если удалить файлы мода.Steam/steamapps/common/skyrim/Data/Interface. Оттуда удали папку exported и файл faemtirvsoenu

Post Comment

:Register

Bulletin

    数据框架 CYQ.Data QQ群：6033006
    使用本框架进行开发，入门简单，开发效率高，性能优越，更有详尽的API文档，有相关的使用帮助文章、示例文章、更甚有相关的视频教程及辅助工具。 关键还是免费与开源，实在是居家旅行、项目开发、学习研究的必备良品!!!!!!

    在线帮助：欢迎联系

Article Search