Search Data From Database and Filter in Datagridview

Search Data From Database and Filter in Datagridview

Today in this article I will show you how to search record in the database and then filter it in to the datagridview.

Variables

In this program we will use these variables.

        SqlConnection sqlconnection;

        SqlCommand sqlcommand;

        string ConnectionString = @"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\Ehtesham Mehmood\Documents\Database1.mdf;Integrated Security=True;Connect Timeout=30";

        string Query;

        DataSet dataset;

        DataTable datatable;

        SqlDataAdapter sqladapter;

Diagram


Program

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

 

namespace FilterValuesDataGridviewThrougTextBox

{

    public partial class Form1 : Form

    {

        public Form1()

        {

            InitializeComponent();

        }

//global variables

        SqlConnection sqlconnection;

        SqlCommand sqlcommand;

        string ConnectionString = @"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\Ehtesham Mehmood\Documents\Database1.mdf;Integrated Security=True;Connect Timeout=30";

        string Query;

        DataSet dataset;

        DataTable datatable;

        SqlDataAdapter sqladapter;

    

 

 

//This is the form load event

    private void Form1_Load(object sender, EventArgs e)

        {

            //form load event here data will show in the data gridview

            sqlconnection=new SqlConnection(ConnectionString);

            Query = "select * from Student";

            sqlcommand=new SqlCommand(Query,sqlconnection);

            sqladapter=new SqlDataAdapter();

            datatable = new DataTable();

            sqladapter.SelectCommand=sqlcommand;

            sqladapter.Fill(datatable);

            dataGridView1.DataSource = datatable;

        }

 

 

//This is the textchanged event    

    private void textBox1_TextChanged(object sender, EventArgs e)

        {

           //textchanged event of texbox when user enter a word in the textbox then through this dataview object string format it will filter and attached the filter result in to the datagridview

            DataView DV = new DataView(datatable);

            DV.RowFilter = string.Format("Name LIKE '%{0}%'", textBox1.Text);

            dataGridView1.DataSource = DV;

        }

    }

}

I have also attached the source code so you people can download it.

X

Build smarter apps with Machine Learning, Bots, Cognitive Services - Start free.

Start Learning Now