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

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

searching Info in database

3 solutions

Solution 2

Solution 1

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us