C# Gridview Sorting - c# - c# tutorial - c# net



What is Datagridview Sorting?

  • In general, the DataGridView control provides automatic sorting, so that user can manually sort any column in the control.
  • Here we can control whether a column can be sorted by setting the SortMode property of the DataGridViewColumn.
  • We can also programmatically sort a column.
 DataGridview Sorting

DataGridview Sorting

How to sort Datagridview

  • In C#, the DataGridView control provides an automatic sorting, so that we can automatically sort any column in the datagridview control.
  • We can sort the data in ascending or descending order based on the contents of the specified column.
  • Also we can see the DataGridView sorting, when a user clicks on the column header.

Syntax

dataGridView1.Sort(dataGridView1.Columns[1], ListSortDirection.Ascending);
 c-sharp sorting
  1. Here Fetch Data button will display the data values from the SQL and displays it by clicking it.
  2. Go to tool box and click on the DataGridview option the form will be open.
  3. Go to tool box and click on the button option and put the name as Sort in the button.
  4. Here thetext field is specifying to enter the text in text field.

C# Sample Code - C# Examples

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;
using System.Data.SqlClient;

namespace WikiTechy_Csharp_Windows_Application
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }
         
        private void button1_Click(object sender, EventArgs e)
        {
            string connectionString =
                @"Data Source=VENKAT\KAASHIV;Initial Catalog=wikitechy;user id = venkat;password=venkat";

            string sql = "SELECT * FROM login_table";

SqlConnection connection = new SqlConnection(connectionString);
SqlDataAdapter dataadapter = new SqlDataAdapter(sql, connection);

            DataSet ds = new DataSet();

            connection.Open();
                        dataadapter.Fill(ds);
            connection.Close();

            dataGridView1.DataSource = ds.Tables[0];  

        }

        private void button2_Click(object sender, EventArgs e)
        {
            dataGridView1.Sort(dataGridView1.Columns[1], ListSortDirection.Ascending);
        }
    }
}

Code Explanation:

 c-sharp sorting code
  1. Here private void button2_Click(object sender, EventArgs e) click event handler for button2 specifies, which is a normal Button control in Windows Forms. The two parameters, "object sender" and "EventArgs e" parameters of function of event of a button such as private void button2_Click(object sender, EventArgs e). Here dataGridView1.Sort(dataGridView1.Columns[1], ListSortDirection.Ascending); specifies to Sorts the contents of the DataGridView control in ascending order based on the contents of the specified column.

Sample Output

 c-sharp sorting code output
  1. Here in this output the Fetch Data button will display the data values from the SQL and displays it by clicking it.
  2. Here in this output table displays the Id "1,2,3" and name "venkat, jln, arun".
 c-sharp sorting code output1
  1. Here in this output the Fetch Data button will display the data values from the SQL and displays it by clicking it.
  2. Here in this output table displays the Id "3,2,1" and name "arun, jln, venkat".
  3. Here in this output we display Sort, which specifies click on Sort button then the table id’s and names are converted into ascending order (A to Z).

Related Searches to C# Gridview Sorting