check if value exists in database particular column

Question

2.00/5 (1 vote)

See more:

Hi all,

I've a text box in windows form and its name is txtbx and database table name is table1 in which 3 columns and 1 column name is column1.My question is how to compare textbox value with column1 existed value,if same should say 'Found' else 'Not Found'. please reply with an example

MOVED FROM ANSWER:

hi thank u for reply, i got confused at below code

ReadData r = new ReadData();
if (r.FindString("Shahingg"))//? (my question is below)
  MessageBox.Show("I Found it!");
else 
  MessageBox.Show("I can't Find it!");

? is since i using textbox,how to include textbox value instead "Shahingg".

Posted 17-Jan-11 17:47pm

ks ravi

Updated 17-Jan-11 18:35pm

JF2015

v3

Add a Solution

Comments

Baji Jabbar 18-Jan-11 0:34am

First I have to say no effort!
You can read the values of the column using 'datareader' and compare it with the textbox value.

JF2015 18-Jan-11 0:36am

I moved you answer to the question and updated my answer to solve your code issue.

Baji Jabbar 18-Jan-11 0:38am

texbx.Text will give you the value

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

**JF2015** · Answer 1 · 2011-01-17T18:12:00

Solution 2

Hi,

you already got some solutions here:
How to check if value exists in database, [^]
Have you tried some of those? If yes, show us your code! If you don't tell us what problems you face we can't help you any further.

Edited after updated question:

Here is the solution:

C#

ReadData r = new ReadData();
if (r.FindString(textBox1.Text))
  MessageBox.Show("I Found it!");
else
  MessageBox.Show("I can't Find it!");

Posted 17-Jan-11 18:12pm

JF2015

Updated 17-Jan-11 18:36pm

v2

Comments

Anupama Roy 18-Jan-11 0:31am

Exactly!My Vote of 5! I had clearly mentioned in the post that he has to put value of textbox in where condition of sql in order to compare.He downvoted my answer!

ks ravi 18-Jan-11 1:50am

thank you its working

Espen Harlinn 18-Jan-11 8:53am

5+ Well answered

TheyCallMeMrJames · Answer 2 · 2011-01-17T18:10:00

Hi ks ravi.

You will need to get a couple of things in order.

You need:
a) a connection
b) a way to query the database
c) a way to encapsulate and evaluate the results

First, you need to make the application you're developing aware of the database. The configuration is expressed as a connection string, which is often constructed and stored for you through the VS tools.

The easiest way to do what you're looking for might be to use LINQ to SQL. This is very well documented. The steps are along the lines of:
1) Use the server window to add a data connection to the database in question
2) Add a LINQ to SQL file to the database
3) Drag a table from the server explorer onto the LINQ to SQL designer
4) Compile your application

At this point, your application is fully aware of the database and the connection bits are constructed and ready to use. The configuration is stored in your app.config file. The result of the designer is a DataContext and its related classes.

Now, in your code, you're going to need to do the following:
1) Create an instance of the datacontext
2) "Ask" if your table contains the data

It might look something like this:

DesignerNameDataContext dc = new DesignerNameDataContext();
var matchingRecord = dc.table1.Where(c => c.column1 == txtbx.Text).FirstOrDefault();
if(matchingRecord == null)
{
  // there was no match
}

I've given you a bunch of tools and vocabulary here. A Google search will get you further along the way. If you have any specific questions or need help with a particular concept, please post another question!

Hope this helps.

Cheers.