how to make row value as column header

Question

0.00/5 (No votes)

See more:

i have simple grid view like below..all data i'm fetching from the database...and each columns are dynamic,like user can add more earnings to the database and that earning will come to the grid view

EmpName	Earnings	Amount
Austin	HRA	1000$
Austin	DA	1000$
Austin	Basic	1000$

now i have to make above grid view as below

Austin	HRA	DA	Basic
	1000$	1000$	1000$

can you please suggest me some idea and examples using C# to do it..actually i'm just new to asp.net and i don have idea to do it

Posted 18-Jul-11 20:41pm

rajeevcse04

Updated 18-Jul-11 20:42pm

v2

Add a Solution

3 solutions

Solution 4

take a look at this article [^]- it may shed some light on it for you.

Posted 21-Jul-11 21:39pm

Mycroft Holmes

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)

Herman<T>.Instance · Accepted Answer · 2011-07-18T21:23:00

Solution 2

I have recently writen an article about dynamic pivotting. In 7 steps it is shown how to create a pivot with summings of each column and row.

You do not need to go hat far but with the information in this link you should be able to tackle this simple gimmick

Posted 18-Jul-11 21:23pm

Herman<T>.Instance

rajeevcse04 · Accepted Answer · 2011-07-20T00:00:00

If any one face this kind of proble plese refer this code

SqlCommand cmd = new SqlCommand("Your query", con);
            SqlDataReader rdr;
            rdr = cmd.ExecuteReader();

            DataTable dt = new DataTable();

            DataRow newRow = dt.NewRow();


            DataColumn dc = new DataColumn();


            rdr.Read();
            dt.Columns.Add(new DataColumn(rdr[Index].ToString()));
            rdr.Close();

            rdr = cmd.ExecuteReader();
            while (rdr.Read())
            {

                dt.Columns.Add(new DataColumn(rdr[Index].ToString()));
            }

            rdr.Close();
            rdr = cmd.ExecuteReader();
            while (rdr.Read())
            {
                string Amount = rdr[Index].ToString();
                string EarnName = rdr[Index].ToString();
                newRow[EarnName] = Amount;


            }
            dt.Rows.Add(newRow);

            GridView1.DataSource = dt;
            GridView1.DataBind();