Search and highlight rows in gridview using C#

See more:

C#

Hi, I have a gridview that is populated on page load. I added a search option and when user clicks button I want the matching row to be highlighted in gridview. The grid will only highlight the matching row. Below is my code but it doesn't highlight the matching row. Any suggestions?


Thanks

What I have tried:

protected void Button1_Click(object sender, EventArgs e)
{
	string cs = "Data Source=DESKTOP-Q69PRF4;Initial Catalog=new;Integrated Security=True";
	SqlConnection con = new SqlConnection(cs);
	if (con.State == ConnectionState.Open)
	{
		con.Close();
	}

	string Query = "select * from Posst where StId='"+TextBox1.Text+"'";
	SqlCommand com = new SqlCommand(Query, con);
	SqlDataAdapter da = new SqlDataAdapter(com);
	DataSet ds = new DataSet();
	DataTable dt = new DataTable();
	da.SelectCommand = com;
	da.Fill(dt);
	GridView1.DataSource = dt;
}

protected void TextBox1_TextChanged(object sender, EventArgs e)
{
	DataView DV = new DataView(dt);
	DV.RowFilter = string.Format("StID", TextBox1.Text);
   GridView1.DataSource = DV;
}