Loading

How i can remove Thos error

fawad alam

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.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ruchi Sharavat8y ago
What is the column name in your datatable dt? If it is "User Name" i.e. there is space between "User" and "Name" than try this:
dvu.RowFilter = "[User Name] LIKE '%" + textBox8.Text + "%'";
Otherwise remove the space between User and Name
Jenith Thakkar8y ago
there's one sapace in word 'User Name' so please remove that space