how get data from table

Question

This is my table i have a TEXT BOX in aspx page and want to search data from this table .user can put any data witch match any column data of table . Please tell me how to write query to get data from table .

Upendra Pratap Shahi · Answer

make recursive with textbox event to do this type of work.

Upendra Pratap Shahi · Answer

thanks a ton Lalit Raghav for appreciation.

Lalit Raghav · Answer

if user write in textbox as Mohit RamPur then how search

Raja T · Answer

HiTry like this Sample Exaple Use ASPX.CS page textBox1.Text=40 string selectQuery = select * from tbl_Test where name like '% + textBox1.Text + %' or age like '% + textBox1.Text + %' or city like '%+ textBox1.Text +%' or state like '%+ textBox1.Text +%' ; Use sqlserver select * from tbl_Test where name like '%40%' or age like '%40%' or city like '%40%' or state like '%40%'

Rajeesh Menoth · Answer

Hi Lalit Raghav  Write like this.. In simple way.. SELECT * FROM tablename WHERE columnname LIKE 's%'; Ref : click here The answer is helpful then please accept it ...!!!

Upendra Pratap Shahi · Answer

hello Try with below query- select id  Name  age  city  state where id like '%5%' or Name like '%Sanjay%' or age like '%12%' or city like '%Noida%' or state like '%UP%' Kindly accept the answer .