How to Search a value in a data base

Question

4.00/5 (1 vote)

See more:

Hi There,

I am trying to make an application where if the user enters a number in a text box and then presses a button then it will search my sql database file data.mdf and will display the name of the person of that particular unique no. entered in the text box.

Can Anyone please tell me the coding for the button.

I am a Newbie so please try to help...

THANKS IN ADVANCE

Posted 9-Mar-11 5:04am

rahuliyer95

Add a Solution

3 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)

Kschuler · Answer 1 · 2011-03-09T05:39:00

Solution 2

Try searching for some articles on Google [^]or the articles in CodeProject.

This one[^] looks like a good start for you.

Posted 9-Mar-11 5:39am

Kschuler

Piccadilly Yum Yum · Answer 2 · 2011-03-09T05:38:00

Solution 1

You need SQL to query the database.
For example in your case : SELECT NameOfThePerson WHERE ID=YourTextBoxValueAsInteger

For executing the query you need coding in your application, do some thing like open the database, query it and close.

If you search "C# SQL QUERY" in some engine you find a lot of examples ...

Posted 9-Mar-11 5:38am

Piccadilly Yum Yum

Comments

Kschuler 9-Mar-11 11:43am

You should also mention, however, that it's not good practice to just use WHERE ID=YourTextBoxValueAsInteger because it can lead to problems with SQL Injection attacks. Best practice would be to use parameters instead.

RadethDart · Answer 3 · 2011-03-09T09:50:00

Or...maybe this can get you started?

VB

' If search box is empty
If SearchBox.Text = "" Then
   ' Bring up all names
   Me.BindingSource1.Filter = "UniqueID like '" & "%" & "'"
Else
   ' Bring up name being searched for
   Me.BindingSource1.Filter = "UniqueID like '" & "%" & SearchBox.Text & "%" & "'"
End If

Not sure this is what you are looking for, but here is an idea.

[Modified to specify the language for the pre block so that it will be color-formatted correctly]