How to Search Data Using DateTimePicker in C#

Submitted by janobe on Thursday, September 12, 2019 - 08:39.

One of the biggest problems in programming is how to deal with the dates. So, In this tutorial, I will teach you how to search for data using DateTimePicker in C#. This project has the ability to search the data in the database by the dates you choose in the DateTimePicker. The data will automatically display into the datagridview when the date you choose is equal to the transaction date in the database.

Creating a Database

Go to http://localhost/phpmyadmin/ and create a new database named it "salesdb". Execute the following codes for creating a table.

CREATE TABLE `tblsales` (
  `SalesId` int(11) NOT NULL,
  `TRANSDATE` date NOT NULL,
  `Product` varchar(90) NOT NULL,
  `TotalSales` double NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Execute the following codes for inserting data in the table.

INSERT INTO `tblsales` (`SalesId`, `TRANSDATE`, `Product`, `TotalSales`) VALUES
(1, '2018-01-30', 'Cellphone', 1400),
(2, '2018-02-28', 'Laptop', 800),
(3, '2018-03-31', 'Desktop', 5052),
(4, '2019-04-30', 'Ipod', 8030),
(5, '2019-05-31', 'Tablet', 10000);

Creating Application

Step 1

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

Step 2

Do the form just like shown below.

Step 3

Add MySQL.Data.dll

Step 4

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

 
using MySql.Data.MySqlClient;

Step 5

Establish a connection between C# and MySQL database. After that, declare all the classes that are needed.

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

Step 6

Create a method for retrieving data in the database.

 
        private void retrieveData(string sql, DataGridView dtg)
        {
            try
            {
                con.Open();
 
                cmd = new MySqlCommand();
                da = new MySqlDataAdapter();
                dt = new DataTable();
 
                cmd.Connection = con;
                cmd.CommandText = sql;
                da.SelectCommand = cmd;
                da.Fill(dt);
 
                dtg.DataSource = dt;
                
 
            }
            catch(Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                con.Close();
                da.Dispose();
            }
        }

Step 7

Write the following code to display the data into the DataGridView in the first load of the form.

 
        private void Form1_Load(object sender, EventArgs e)
        {
 
            sql = "SELECT * FROM `tblsales`";
            retrieveData(sql, dataGridView1);
        }

Step 8

Write the following code for searching data in the DataGridView using the DateTimePicker when the button is clicked

 
        private void button1_Click(object sender, EventArgs e)
        {
 
            DateTime dateToday = dateTimePicker1.Value; 
 
            string strDate = dateToday.ToString("yyyy-MM-dd");
             
            sql = "SELECT * FROM `tblsales` WHERE Date(`TRANSDATE`) = '" + strDate + "'";
            retrieveData(sql, dataGridView1);
        }

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.