how to make row value as column header

i got a problem with开发者_Python百科 grid view ,because I'm new to asp.net(10 days),so i donno how to do it,so can you guyz please help me out this problem..

i have a simple gridview ,and i have to make new grid with row value as column header name

Empname Earnngs Amount

Austin HRA 20,000$

Austin DA 1,000$

Austin Basic 5,000$

and i have to make like this

.Austin HRA DA BASIC

    2000$ 2000$ 2000$

Please give some idea and some examples using C# to do it

Here is an example of doing this using an asp GridView:

// Create new DataTable.
DataTable dt = new DataTable();

// Total count of columns.
int colCount = 3;

// Add 3 columns.
for (int i = 0; i < colCount; i++)
{
    dt.Columns.Add(new DataColumn("col" + i.ToString()));
}

// Add data to the datatable.
dt.Rows.Add(new object[] { "Empname", "Earnngs", "Amount" });
dt.Rows.Add(new object[] { "Austin", "Earnngs", "Amount" });
dt.Rows.Add(new object[] { "Austin", "df", "Amount" });
dt.Rows.Add(new object[] { "sdfsdf", "dsfdf", "df" });
dt.Rows.Add(new object[] { "Empdsfsdfname", "Earnngs", "df" });

// Loop through each column in the DataTable and set the column name to the data in the first row of data.
foreach (DataColumn dc in dt.Columns)
{
    dc.ColumnName = dt.Rows[0][dc].ToString();
}

// Set the datasource of the grid.
this.GridView1.DataSource = dt;

// Bind the data to the grid.
this.GridView1.DataBind();

See these:

http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.gridview(v=VS.100).aspx

http://msdn.microsoft.com/en-us/library/system.data.datatable.aspx

http://msdn.microsoft.com/en-us/library/system.data.datacolumn.aspx

Strange. However create DataTable with first row values as dataColumn name and rest data will go as data row. Bind this table to the grid.

if any one face this kind of problem you can refer this coding

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();

DownLoad Torrent at High Speed