i want to populate grid view with data from more than two sql server tables

Question

0.00/5 (No votes)

See more:

hai all
i want to populate grid view with data from sql server tables.

the tables are as follows:

first table: Profile:

Id	Name 	Age Designation_code
1	ABC	22	3
2	DEF	24	2
3	GHI	25	1
4	JKL	23	3
5	MNO	22	3
6	PQR	25	2

Second Table: Designation:

D_id	Designation_name Designation_code
1	Consultant	E1
2	Project Lead	E2
3	Programmer	E3

the result in the grid view should be this way

D_id	Designation_name	Employees
1	Consultant	            GHI
2	Project Lead                DEF
                                    PQR
3	Programmer	            ABC
                                    JKL
                                    MNO

the sql code i used is as follows

SQL

SELECT p.Id,d.Designation_name,p.Name as Employee
FROM profile p
LEFT OUTER JOIN Designation d
ON p.Designation_code=d.Designation_code

I know the sql for the result but.. the result is displayed like this

D_id    Designation name    Employees
1   Consultant              GHI
2   Project Lead            DEF
3   Project Lead            PQR
4   Programmer              ABC
5   Programmer              JKL
6   Programmer              MNO

i want the result as i showed. what should i do to get the data of two tables in the grid view this way

D_id   Designation name    Employees
1   Consultant              GHI
2   Project Lead            DEF
                            PQR
3   Programmer              ABC
                            JKL
                            MNO

please help me thanks in advance

Posted 22-Apr-12 21:21pm

Ragi Gopi

Updated 22-Apr-12 22:18pm

Mehdi Gholam

v2

Add a Solution

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)

Sandeep Mewara · Answer 1 · 2012-04-22T23:08:00

Solution 2

Here you go:
Eliminate Duplicate Values from the Grid View[^]
How do I Hide duplicate row values in a Gridview Control [^]

Posted 22-Apr-12 23:08pm

Sandeep Mewara

Comments

Ragi Gopi 23-Apr-12 5:16am

Sorry this is not the answaer..
i am talking about, if it happens with more than 6 or seven coloumns.

Arav Pradeep Gupta 23-Apr-12 5:20am

Gopi, Did you try the Solution 1.?

One thing if you have couple of colomns then you need to apply the same condition.

Sandeep Mewara 23-Apr-12 5:52am

Not sure what do you mean by 'happens with more..'. Articles above are for removing duplicates as you asked for.

Arav Pradeep Gupta · Answer 2 · 2012-04-22T21:28:00

protected void Grid_RowDataBound(Object sender, GridViewRowEventArgs e)
 {
 if(e.Row.RowType == DataControlRowType.DataRow)
 {
 Label lbl= (Label)e.Row.FindControl("ID Of Control taken for Designation  into the inline page"));

if(sDesignation!=e.Row.Cells[Index].Text) 
{ lbl.Text=sDesignation;}
 
 sDesignation=e.Row.Cells["ColomnName"].Text;
 } 
}
 NOTE- sDesignation this variable out of this event. No need create the instanse each time calling.As a Global