C# code to retrieve data from multiple tables

Question

0.00/5 (No votes)

See more:

The informations are stored in diff tables of a database. For instance DB name say DB1. It has tables such as task,story,person,... I want to check the condition as if task.acceptor_id and story.owner_id=person.userId, then name of the task and story should be displayed in the particular user's page.
I also want to display the details of the tasks/story for a user/dev in a project website checking the condition that the user/developer is only assigned to any task/story of the project. Or it should not be display any tasks/story related information in his/her page.
should be done in C#
Please help me to finish it.
Thanks in advance...

Posted 23-Dec-12 23:01pm

Manjari Raj

Add a Solution

Comments

Sampath Kumar Sathiya 24-Dec-12 5:05am

Have you tried anything, Please give those details?

[no name] 24-Dec-12 5:27am

"should be done in C#" Does this mean you want to do the above task using C# only with out any sql server involvement?

Zoltán Zörgő 24-Dec-12 5:29am

This is not a "quick answers" kind of question. Much like a whole project. Nobody will be able or willing to do the job for you. You have to try to solve by yourself, and if you get lost somewhere, and you have a really concrete question in a really concrete situation, you can come back, and we will be willing to help you - and most likely able to help you if it is possible.
You have not even specified if you want to make a thick (windows forms) or thin (asp.net) application...

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 · Accepted Answer · 2012-12-24T00:00:00

Try using an SQL JOIN:

SQL

SELECT t.Name, s.Name FROM person p
JOIN story s ON p.userId=s.owner_id
JOIN task t ON p.userId=t.acceptor_id

All you have to do is package it in C# code:

C#

using (SqlConnection con = new SqlConnection(strConnect))
    {
    con.Open();
    using (SqlCommand com = new SqlCommand("SELECT t.Name AS task, s.Name AS story FROM person p JOIN story s ON p.userId=s.owner_id JOIN task t ON p.userId=t.acceptor_id", con))
        {
        using (SqlDataReader reader = com.ExecuteReader())
            {
            while (reader.Read())
                {
                string task = (string) reader["task"];
                string story = (string) reader["story"];
                Console.WriteLine("{0}, {1}", task, story);
                }
            }
        }
    }