C# And MySQL - Search Using TextChanged Event

C# - How To Use TextChanged To Search And Display Data In DatagridView

                                                                                                                                         

In This C# Tutorial We Will See How To Search Data In MySQL On The TextChanged Event And Show This Data On Datagridview Using CSharp Programming Language And MySQL Database.
-

Source Code :

using MySql.Data.MySqlClient;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace Csharp_And_MySQL
{
    public partial class TextChanged_Search : Form
    {
        public TextChanged_Search()
        {
            InitializeComponent();
        }

        MySqlConnection connection = new MySqlConnection("datasource=localhost;port=3306;Initial Catalog='test_db';username=root;password=");

        private void TextChanged_Search_Load(object sender, EventArgs e)
        {
            searchData("");
        }

        public void searchData(string valueToFind)
        {

            string searchQuery = "SELECT * FROM users WHERE CONCAT(fname,lname) LIKE '%"+valueToFind+"%'";
            MySqlDataAdapter adapter = new MySqlDataAdapter(searchQuery, connection);
            DataTable table = new DataTable();
            adapter.Fill(table);
            dataGridView_Data.DataSource = table;

        }

        private void textBox1_Search_TextChanged(object sender, EventArgs e)
        {
            searchData(textBox1_Search.Text);
        }
     
    }
}

=> OutPut :

---

More C#

➜ C# Courses

➜ C# Projects

C# And MySQL - How To Search Data In MySQL And Display It On DataGridView Using C#

C# Code - How To Filter Data In MySQL And Show It On DataGridView Using C#

__________________________________________________________________________

In This C# Tutorial We Will Learn How To  Find Data In MySQL Database With A 
Specific  Value From TextBox And Display The Result In DataGridView Using CSharp
Programming Language .

Source Code :

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Windows.Forms;

using MySql.Data.MySqlClient;

namespace Csharp_And_MySQL

{

    public partial class Csharp_MySQL_Datagridview_Search : Form

    {

        MySqlConnection connection = new MySqlConnection("datasource = localhost;port = 3306; Initial Catalog = 'test_db'; username = root; password=");

        MySqlCommand command;

        MySqlDataAdapter adapter;

        DataTable table;

        public Csharp_MySQL_Datagridview_Search()

        {

            InitializeComponent();

        }

        private void Csharp_MySQL_Datagridview_Search_Load(object sender, EventArgs e)

        {

            searchData("");

        }

        public void searchData(string valueToSearch)

        {

            string query = "SELECT * FROM users WHERE CONCAT(`id`, `fname`, `lname`, `age`) like '%"+valueToSearch+"%'";

            command = new MySqlCommand(query, connection);

            adapter = new MySqlDataAdapter(command);

            table = new DataTable();

            adapter.Fill(table);

            dataGridView1.DataSource = table;

        }

        private void BTN_SEARCH_Click(object sender, EventArgs e)

        {

            string valueToSearch = textBoxValueToSearch.Text.ToString();

            searchData(valueToSearch);

        }

    }

}

=> OUTPUT:

---

Download Projects Source Code

▶ Get Java Projects

▶ Get C# Projects

▶ Get VB.Net Projects

▶ Get Java + C# + VB.Net + Python Projects