private void textBox8_TextChanged(object sender, EventArgs e)
{
DataTable dt = new DataTable();
dt = dl.select();//selecting Table from database using select() function
DataView dvu = dt.DefaultView;
dvu.RowFilter = "User Name LIKE '%" + textBox8.Text + "%'";}
I am trying to make a search button using this code but it throws an error as
Syntax error: Missing operand after 'Name' operator.'
so kindly some one tell me what is the correct syntax.