how to search record with last digits of ID number

Question

4.00/5 (1 vote)

See more:

i have a barcode 41/3/100 ,

100 will be saved in data base when i scan barcode with scanner it will read 41/3/100 when i click the button how should i search the record only with 100 using c# code????

help

Posted 14-Nov-12 10:50am

Mohammed Abdul Muqeet

Add a Solution

Comments

ZurdoDev 14-Nov-12 16:51pm

I don't fully understand your question but if you want to find the data in SQL just use WHERE field LIKE '%100'.

4 solutions

Solution 4

You can try...

C#

string keyword = textbox.Text;
var substring = keyword.Split('/');

var dbSaveString = substring[substring.Length - 1];

Posted 18-Nov-12 22:43pm

Munir Hassan

Solution 2

in my process i am using sql server 2008 r2 and 41/3/ is fixed and the value 100 will increment and only from 100 will save in database
like
100
101
102
103 so on

but for the barcode it will get
41/3/100
41/3/101
41/3/102
so onn...

when they scan with barcode scanner 41/3/102 or some thing in text box when they click search button how should i search with only 102 ???/

Posted 15-Nov-12 1:08am

Mohammed Abdul Muqeet

Solution 3

Hi,

Use the below code snippet into your search method.

string keyword = textbox.Text.SubString(textbox.Text.IndexOf("41/3/"));

and use keyword in your where condition.

Hope this will help you.

Posted 15-Nov-12 1:14am

Mohd. Mukhtar

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)

Christian Graus · Accepted Answer · 2012-11-14T10:54:00

ryan is right, if it's a string, you can use a LIKE clause. If it's a digit, you will have to write SQL that turns it in to a string so you can use a LIKE clause ( assuming that works ). Otherwise, you're stuck. One possibility, if you were searching for 351, you could do where x % 1000 = 351. That would be if you divide x by 1000, 351 is the remainder. so if you were searching for a two digit number, it would be % 100, etc.

Having looked again, you're clearly storing a string, so searching x LIKE '%100' is what you need.