Like operator in query

Question

0.00/5 (No votes)

See more:

i m searching data...and i have multiple fields.for expl

C#

SqlCommand cmd = new SqlCommand("select emp_code,emp_name,Br_name,dept_name,designation_name,emp_gender,emp_mobile,emp_email,emp_doj from employee_info where emp_code like %'" + txt_search.Text + "'% or emp_name like %'" + txt_search.Text + "'% or Br_name like % '" + txt_search.Text + "'% or dept_name like %'" + txt_search.Text + "'% or designation_name like %'" + txt_search.Text + "'% or emp_gender='" + txt_search.Text + "' or emp_mobile like %'" + txt_search.Text + "'% or emp_email like %'" + txt_search.Text + "'% or emp_doj like %'" + txt_search.Text + "' % ", con);

how can we write the % in query?plz reply

Posted 10-Oct-11 1:51am

pallavi ajin

Updated 10-Oct-11 2:15am

Toniyo Jackson

v2

Add a Solution

Comments

raj ch 10-Oct-11 7:52am

can u be more clear???

pallavi ajin 10-Oct-11 7:55am

ok i m using this query for searching data in table....
so i dnt knw how to write it.
for ex
select * from tablename where empname like %'"+txt.text+"'%
in txt.Text data is entered by user thn he will click on search button after that result will be shown in the gridview

5 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

raj ch · Answer 1 · 2011-10-10T01:56:00

I have used like operator in one of me queries
hope this helps

VB

sqlstr = "SELECT IPAIPNO_REG,IPAIPNO, T3.BEDTRNPATNAME,' ',' ',BEDTRNPATAGE, "
       sqlstr = sqlstr & " BEDTRNOCCUSEX, ' ',BEDTRNWRDCODE,BEDTRNRMCODE, IPAPOLCOMPCODE,IPADUMMY1,IPAADMDATE,IPAADMTIME  FROM"
       sqlstr = sqlstr & " TBL_IPA_TN_IPADMS T1,TBL_IPA_TN_BEDTRN T3 WHERE t1.IPAIPNO_REG = T3.BEDTRNIPNO_REG"
       sqlstr = sqlstr & " AND BEDTRNSTATUS = 'O' AND  BEDTRNOCCBYPAT='Y' AND IPAIPNO IN "
       sqlstr = sqlstr & " (SELECT MAX(IPAIPNO) FROM TBL_IPA_TN_IPADMS GROUP BY IPAIPNO_REG) "

       If objPatientDetailsEnquiryBussinessObjects.MRNo <> 0 Then
           sqlstr = sqlstr & " AND IPAIPNO_REG LIKE '" & objPatientDetailsEnquiryBussinessObjects.MRNo & "%'"
       End If
       If objPatientDetailsEnquiryBussinessObjects.ipno <> 0 Then
           sqlstr = sqlstr & " AND IPAIPNO LIKE '" & objPatientDetailsEnquiryBussinessObjects.ipno & "%'"
       End If
       If objPatientDetailsEnquiryBussinessObjects.patName <> Nothing Then
           sqlstr = sqlstr & " AND BEDTRNPATNAME LIKE '%" & objPatientDetailsEnquiryBussinessObjects.patName & "%'"
       End If
       If objPatientDetailsEnquiryBussinessObjects.BillPatType <> Nothing Then
           sqlstr = sqlstr & " AND IPAPAYTYPE LIKE '" & objPatientDetailsEnquiryBussinessObjects.BillPatType & "%'"
       End If

Toniyo Jackson · Answer 2 · 2011-10-10T02:16:00

Solution 2

Keep % inside the single quotes.

C#

...'%" + txt_search.Text + "%'...

Posted 10-Oct-11 2:16am

Toniyo Jackson

hitech_s · Answer 3 · 2011-10-10T02:20:00

replace your query with this once

SQL

select emp_code,emp_name,Br_name,dept_name,designation_name,emp_gender,emp_mobile,emp_email,emp_doj
from employee_info
where emp_code
like '%" + txt_search.Text + "%' or emp_name
like '%" + txt_search.Text + "%' or Br_name
like  '%" + txt_search.Text + "%' or dept_name
like '%" + txt_search.Text + "%' or designation_name
like '%" + txt_search.Text + "%' or emp_gender='" + txt_search.Text + "' or emp_mobile
like '%" + txt_search.Text + "%' or emp_email
like '%" + txt_search.Text + "%' or emp_doj
like '%" + txt_search.Text + "%'

devildx2050 · Answer 4 · 2011-10-10T02:21:00

Solution 4

Writing SQL Queries: Let's Start with the Basics

http://msdn.microsoft.com/en-us/library/bb264565%28v=sql.90%29.aspx[^]

Posted 10-Oct-11 2:21am

devildx2050

P.Salini · Answer 5 · 2011-10-10T02:22:00

use this one

C#

SqlCommand cmd = new SqlCommand("select emp_code,emp_name,Br_name,dept_name,designation_name,emp_gender,emp_mobile,emp_email,emp_doj from employee_info where emp_code like '%" + txt_search.Text + "%' or emp_name like '%" + txt_search.Text + "%' or Br_name like '%" + txt_search.Text + "%' or dept_name like '%" + txt_search.Text + "%' or designation_name like '%" + txt_search.Text + "%' or emp_gender='" + txt_search.Text + "' or emp_mobile like '%" + txt_search.Text + "%' or emp_email like '%" + txt_search.Text + "%' or emp_doj like '%" + txt_search.Text + "%' ", con);

Like operator in query

5 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Solution 5

Add your solution here

Preview 0