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()

        private void Csharp_MySQL_Datagridview_Search_Load(object sender, EventArgs e)

        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();
            dataGridView1.DataSource = table;

        private void BTN_SEARCH_Click(object sender, EventArgs e)
            string valueToSearch = textBoxValueToSearch.Text.ToString();



c# datagridview filter

Share this

Related Posts

Next Post »