searching Info in database

Question

0.00/5 (No votes)

See more:

Hi friends,
I am confused about searching a data from database using SQL server. if any one have answer of this question in C# language please help me

Posted 7-Apr-11 23:35pm

Tayyabsam

Updated 7-Apr-11 23:40pm

Albin Abel

v2

Add a Solution

Comments

jim lahey 8-Apr-11 5:43am

the trouble is, I don't see the question..

Sandeep Mewara 8-Apr-11 6:43am

What trouble?

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)

OriginalGriff · Answer 1 · 2011-04-07T23:46:00

Use a SELECT statement with a WHERE clause:

using (SqlCommand com = new SqlCommand("SELECT * FROM Customers WHERE CustomerId=102", con))
   {
   SqlDataReader r = com.ExecuteReader();
   while (r.Read())
       {
       Console.WriteLine("{0}:{1}:{2}", r["Customer"], r["date"], r["Value"]);
       }
   }

Wayne Gaylard · Answer 2 · 2011-04-07T23:44:00

Solution 1

1. Google ADO.Net C#.
2. You will get 5,660,000 hits.
3. Read any of above.

See, programming is easy!

Posted 7-Apr-11 23:44pm

Wayne Gaylard

RaviRanjanKr · Answer 3 · 2011-04-08T00:38:00

you have mentioned that you are confused about searching data from database but you haven't mention whats lead you to confusion. have you tried some thing if so please so your code then we will easily justify with question.
whatever, come to your question "searching Data" means retrieving Specific Attributes based on the condition like
* Record that Match one or more conditions
* Records that Contain values in a given range
* Records that contain any value from a given set of values
* Records that match a pattern
* Records that Contain Null values
* Records to be displayed in a sequence
* Records from the top of a table
* Records without duplications of values
Now which condition matching your requirement
Take a look there-[Retrieving Data Using a C# ][^] where you can learn how to search data.

searching Info in database

3 solutions

Solution 2

Solution 1

Solution 3

Add your solution here

Preview 0