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

Hi,Try 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 .

how get data from table

Answers (6)