[C# language] DataGridView sorting and filtering

In practical applications, the data in the data table needs to be sorted and filtered.

Method:

Sorts the contents of the System.Windows.Forms.DataGridView control in ascending or descending order based on the contents of the specified column.

public virtual void Sort(DataGridViewColumn dataGridViewColumn, ListSortDirection direction);

Initializes a new instance of the System.Data.DataView class with the specified System.Data.DataTable, System.Data.DataView.RowFilter, System.Data.DataView.Sort, and System.Data.DataViewRowState.

public DataView(DataTable table, string RowFilter, string Sort, DataViewRowState RowState);

using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;namespace Test_DataGridView{public partial class Form1 : Form{public Form1(){InitializeComponent();}// global variableint rowIndex;private void Form1_Load(object sender, EventArgs e){dataGridView1.DataSource = Source();}//Data table resourceprivate DataTable Source(){DataTable mydt = new DataTable();mydt.Columns.Add("Name");mydt.Columns.Add("Age");mydt.Columns.Add("Score");String[,] str = new String[,] { { "Zhang San", "21", "90" }, { "Li Si", "22", "93" }, { "Wang Wu", "23", "99" } };for (int i = 0; i < 3; i++){DataRow dr = mydt.NewRow();dr[0] = str[i, 0];dr[1] = str[i, 1];dr[2] = str[i, 2];mydt.Rows.Add(dr);}return mydt;}//get cell informationprivate void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e){//get cell coordinatesint col = dataGridView1.CurrentCellAddress.X + 1;int row = dataGridView1.CurrentCellAddress.Y + 1;//get cell contentString content = dataGridView1.CurrentCell.Value.ToString();MessageBox.Show("row: " + row.ToString() + " column: " + col.ToString() + " content: " + content);}// hide ageprivate void button1_Click(object sender, EventArgs e){String bts = button1.Text;if (bts == "hidden age"){dataGridView1.Columns[1].Visible = false;bts = "Show age";button1.Text = bts;}else{dataGridView1.Columns[1].Visible = true;bts = "Hide Age";button1.Text = bts;}}//Right click eventprivate void dataGridView1_CellMouseUp(object sender, DataGridViewCellMouseEventArgs e){if (e.Button == MouseButtons.Right){this.dataGridView1.Rows[e.RowIndex].Selected = true;this.dataGridView1.CurrentCell = this.dataGridView1.Rows[e.RowIndex].Cells[0];this.contextMenuStrip1.Show(this.dataGridView1, e.Location);contextMenuStrip1.Show(Cursor.Position);rowIndex = e.RowIndex;}}// delete the content of the row eventprivate void delete line ToolStripMenuItem_Click(object sender, EventArgs e){if (!this.dataGridView1.Rows[this.rowIndex].IsNewRow){this.dataGridView1.Rows.RemoveAt(rowIndex);}}//sort buttonprivate void button2_Click(object sender, EventArgs e){dataGridView1.Sort(dataGridView1.Columns[2], ListSortDirection.Descending);}// filter buttonprivate void button3_Click(object sender, EventArgs e){DataView dv = new DataView(Source(), "Name='Li Si'", "Age", DataViewRowState.CurrentRows);dataGridView1.DataSource = dv;}}}