Search Data From Database and Filter in Datagridview

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.