How to display two columns values into the single column into the gridview .

Question

0.00/5 (No votes)

See more:

Hi Experts,

I have two tables:
1. Release_Master Table:

col1                        col2                                            col3.
 A                            B                                               C
 D                            E                                               F

2. Knowissues_master Table:

col5           col6             col7                                      col8.
 124            87              44                                         66
 33             gh              dd                                          44

I want to display col3 values of Release_Master and col8 values of Knowissues_master into the single column in the gridview

something like this:

Combined_column
C
F
66
44

How can I achieve this from code behind (C#) or how can I do this from sql server in the select statement.

Please help me out with this issue..i will appreciate you.

Posted 20-Sep-13 7:59am

argeraju

Updated 20-Sep-13 8:42am

Maciej Los

v4

Add a Solution

Comments

JoCodes 20-Sep-13 14:25pm

Do you have any common column in both the table?

argeraju 21-Sep-13 7:51am

No I don't have common column

argeraju 21-Sep-13 8:09am

I don't have common columns . If it is , how can we display two different columns values of different tables into separate row into the single column?

2 solutions

Solution 1

Assuming the data source has both the fields, you can use template fields

link[^]

If this is not what you are looking for:

Are you saying you have 2 data sources from which you wish to do the same? Post some code, it will be much more clearer.

PS: Sorry if this does not help

Posted 20-Sep-13 8:25am

Karthik. A

Updated 20-Sep-13 8:29am

v2

Comments

argeraju 21-Sep-13 7:50am

Hi karthik,

Actually i don't want to display the both column values into single column of same row.

I want to display them into single column in the separate row for every column value of those tables

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)

argeraju · Accepted Answer · 2013-09-21T02:23:00

 Hi  ,

I have solved that issue myself by using the table variables in the sql server.
The following code will give the same result what I expected.

DECLARE @table1 TABLE  (id int, name varchar(10))
INSERT INTO @table1 VALUES (1, 'issue1')
INSERT INTO @table1 VALUES (2,'issue2')
DECLARE @table2 TABLE (id int, name varchar(10), name2 varchar(10))
INSERT INTO @table2 VALUES (1, 'issue3','OneT')
INSERT INTO @table2 VALUES (2,'issue4','TwoT')
DECLARE @table3 TABLE (result nvarchar(max))


INSERT INTO @table3
SELECT name from @table1
UNION SELECT name from @table2
SELECT * FROM @table3