Detailed introduction to 'ASP.NET' data binding - GridView-C#.Net Tutorial-php.cn

Detailed introduction to 'ASP.NET' data binding - GridView

黄舟

Release： 2017-03-08 13:05:46

Original

1853 people have browsed it

GirdView Introduction:

Name: Network View.

Source: GridView is the successor control of DataGrid. In .net framework 2, although DataGrid still exists, GridView has come to the forefront of history, and the trend of replacing DataGrid is inevitable. Don't block.

Function: Its function is to display the data in the data source in the web page. GridView and DataGrid have similar functions. They both display data from the data source on the web page, and display a row of data in the data source, that is, a record, as a row in the output table on the web page.

I will not elaborate on the detailed properties and events of GirdView here. Below I will just briefly introduce how GirdView displays the data searched from the background database, that is, how GirdView binds and displays the data source.

1. The front-end interface is as follows

## 2. Back-end Writing: Use VS to build ASP.NET form applications. Here, I only write the query function. The background code is as follows

1. Establish a database connection

       public static SqlConnection createConnection()
        {
            SqlConnection con = new SqlConnection("server=.;database=dropDownTest;uid=sa;pwd=123456");
            con.Open();
            return con;
        }

Copy after login

2. Write an operation class, which includes ordinary query methods, query methods by conditions, and add methods (omitted)

        public static DataTable SelectAll()
        {
            SqlConnection con = createConnection();
            DataTable dt = new DataTable();
            SqlCommand cmd = new SqlCommand("select * from person", con);
            SqlDataReader sdr = cmd.ExecuteReader();
            dt.Load(sdr);
            return dt;
        }

Copy after login

3. Write the query button Click event

        protected void Button4_Click(object sender, EventArgs e)
        {
            string c = "";    //定义空字符串，用来条件查询
            
             //设置复选框1的查询条件
            if (this.CheckBox1.Checked)
            {
                c = "pID=" + this.txtID.Text;   //精确匹配查询条件
            }
            else
            {
                c = "pID like&#39;%&#39; ";        //模糊匹配查询条件
            }
            if (this.CheckBox2.Checked)
            {
                c += " and personName like &#39;%" + this.txtName.Text + "%&#39;";
            }
            if (this.CheckBox3.Checked)
            {
                if (RadioButton1.Checked)
                {
                    c += "and personSex=&#39;男&#39;";
                }

                else
                {
                    c += "and personSex=&#39;女&#39;";
                }
            }

            DataView dv = new DataView(PerosonOperate.SelectAll()); //调用查询方法
            dv.RowFilter = c;                                       //设置过滤器（按条件查找）
            dv.Sort = "pID Desc";                                   //使结果按照pID字段降序排列
            GridView1.DataSource = dv;                              //设定数据源
            GridView1.DataBind();                                   //绑定数据源
            //设置列名，如果不设置，将会以数据库中对应的字段名称代替
            GridView1.HeaderRow.Cells[0].Text = "编号";
            GridView1.HeaderRow.Cells[1].Text = "姓名";
            GridView1.HeaderRow.Cells[2].Text = "性别";

Copy after login

The three query renderings are as follows, namely direct click query, query by gender, query by number and Query name and gender together.

## The background code written above It is only written on the basis that the functions can be realized. There are some bugs in it. I hope everyone can modify it by themselves.

From the filtering of background bound data to the presentation of data in the foreground, the general process of using GridView to display data on the browser is like this. The only thing that is a bit awkward here is the conditional In the query, the spelling of the string is difficult. This is nothing more than using the filtering effect of GirdView, which is this code

dv.RowFilter = c; I hope everyone will be more careful in code writing.

The above is the detailed content of Detailed introduction to 'ASP.NET' data binding - GridView. For more information, please follow other related articles on the PHP Chinese website!