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.