its very urgent

[arunnathan]

hi,
i want to dispaly records according to user,typed in textbox.I tried this code.but it didn't works.help me plz
select * from where Users Name Like '" + TextBox1.Text + "'"

[prp]

hi,
i want to dispaly records according to user,typed in textbox.I tried this code.but it didn't works.help me plz
select * from where Users Name Like '" + TextBox1.Text + "'"

you have wrote wrong statement
try this
select * from table_name where UsersName like "' + Textbox1.text + '";