how get data from table

Upendra Pratap Shahi11y ago

Accepted answer

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

Upendra Pratap Shahi11y ago

thanks a ton Lalit Raghav for appreciation.

Lalit Raghav11y ago

if user write in textbox as "Mohit RamPur" then how search

Raja T11y ago

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 Menoth11y ago

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 Shahi11y ago

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.