How to Sort Records in a ListView in Descending Order Using C#.

Submitted by janobe on Monday, September 2, 2019 - 18:19.

If you want to display the latest transaction on the top of the ListView, this tutorial is just right for you. So, in this tutorial, I will teach you how to sort records in a ListView in descending order using C#. This method has the ability to retrieve the data in the database and display it into the ListView that will automatically sort the latest date in which the transaction had been made. In this way, you don’t have to scroll down the records in the ListView because it will place the latest record on the top of the ListView when the transaction is made.

Creating a Database

Create a database in the “PHPMyAdmin” and named it “dbtransaction”. After that, execute the following query to create a table in the database that you have created.

 
CEATE TABLE `tbltransaction` (
  `TRANSID` int(11) NOT NULL,
  `ORNO` int(30) NOT NULL,
  `TRANSDATE` date NOT NULL,
  `AMOUNTSALE` double NOT NULL,
  `CASHIER` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Insert the data in the table.

 
INSERT INTO `tbltransaction` (`TRANSID`, `ORNO`, `TRANSDATE`, `AMOUNTSALE`, `CASHIER`) VALUES
(1, 70004, '2019-02-21', 385, 'Janno Palacios'),
(2, 70005, '2019-02-21', 385, 'Janno Palacios'),
(3, 70002, '2019-02-17', 385, 'Janno Palacios'),
(4, 70001, '2019-02-18', 385, 'Janno Palacios'),
(5, 70006, '2019-02-19', 69, 'Janno Palacios'),
(6, 70007, '2019-02-21', 69, 'Janno Palacios'),
(7, 70003, '2019-02-07', 138, 'Janno Palacios');

Creating Application

Step 1

Open Microsoft Visual Studio 2015 and create a new windows form application in c#.

Step 2

Add a ListView in the form. After that do the form just like shown below.

Step 3

Add MySQL.Data.dll as references.

Step 4

Press F7 to open the code editor. In the code editor, add a namespace to access MySQL libraries.

 
using MySql.Data.MySqlClient;

Step 5

Create a connection between c# and MySQL database and declare all the classes that are needed.

 
          MySqlConnection con = new MySqlConnection("server=localhost;user id=root;password=;database=dbtransaction;sslMode=none");
        MySqlCommand cmd = new MySqlCommand();
        MySqlDataAdapter da = new MySqlDataAdapter();
        DataTable dt = new DataTable();
        string sql; 

Step 6

Create a method for retrieving data in the database and display it in the ListView in descending order.

   
        private void RetrieveDescending()
        {
            try
            {
                con.Open();
                cmd = new MySqlCommand();
                da = new MySqlDataAdapter();
                dt = new DataTable();
 
                sql = "SELECT * FROM `tbltransaction` ORDER BY TRANSDATE DESC";
 
                cmd.Connection = con;
                cmd.CommandText = sql;
 
                da.SelectCommand = cmd;
                da.Fill(dt);
 
                listView1.Items.Clear();
 
                foreach (DataRow r in dt.Rows)
                {
                    ListViewItem list = listView1.Items.Add(r.Field<int>(1).ToString());
                    list.SubItems.Add(r.Field<DateTime>(2).ToString());
                    list.SubItems.Add(r.Field<Double>(3).ToString());
                    list.SubItems.Add(r.Field<string>(4));
                }
 
 
 
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                con.Close();
                da.Dispose();
            }
        }

Step 7

Write the following codes to display the data in the ListView in the first load of the form.

  
        private void Form1_Load(object sender, EventArgs e)
        {
            RetrieveDescending();
        }

The complete source code is included. You can download it and run it on your computer. For any questions about this article. You can contact me @ Email – [email protected] Mobile No. – 09305235027 – TNT Or feel free to comment below.

Add new comment

671 views