How to compare a value obtained from a textbox to all entries of a database using SQL commands?

Question

0.00/5 (No votes)

See more:

Hi..I am currently doing a project on Library Management System. how can i compare a value obtained from a textbox to all entries in a database & find the correct match? plz help me out!

Posted 2-Mar-13 6:43am

Madhubala Ganesan

Add a Solution

Comments

[no name] 2-Mar-13 13:17pm

Help with what? Connect to whatever database you are using and run a query against your data using the TextBox.Text. Your question is broad and very vague.

1 solution

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)

OriginalGriff · Answer 1 · 2013-03-02T07:18:00

Solution 1

Try:

SQL

SELECT * FROM MyTable WHERE ColumnName LIKE '%myCompareString%'

You will probably want code to set the TextBox.Text as a parameter to the SqlCommand object, but that depends on which language you want to use.

Posted 2-Mar-13 7:18am

OriginalGriff

Comments

Madhubala Ganesan 3-Mar-13 3:55am

No..while issuing a book to a member,i get the member ID as input in a textbox. i need to check if such an ID really exists in my database. i need to compare the member ID from text box to all member IDs in the database. If such an ID exists, book should be issued. If not found, book will not be issued.

"Select * FROM MyTable WHERE" statement cannot be used since i am not using any other parameter to 'select' use for WHERE. i jus need to check a particular column of a whole table with the input from the textbox.

OriginalGriff 3-Mar-13 4:28am

So you should use
SELECT * FROM MyTable WHERE myColumn=myID
but myID should *definitely* be supplied as a parameter if it is coming from a text box or you rusk SQL Injection attacks. If you get any rows returned then your ID exists.