Click here to Skip to main content
12,078,298 members (47,021 online)
Rate this:
 
Please Sign up or sign in to vote.
I have a table displayed from a database.
I would like to display the horizontal Header Column-> Vertically

My table Structure is

Server|Role|Status|Date

but I would like to display as

Server|
Role|
Status|
Date|

I tried the to flip the dataset, and tried to build it. Initially the build was successful but I can't view any data on my datagrid.
kindly help , is there any other way to approach this problem ?

here is my code snippet

    SqlConnection con;
    SqlDataAdapter da = null;
    DataSet ds = null;
 
private void Page_Loaded(object sender, RoutedEventArgs e)
 {
      try
     {
         da = new SqlDataAdapter("Select * from [ServerDB_Test].[dbo].[ServerStatus] ", con);
         ds = new DataSet();
         foreach (DataTable dt in ds.Tables)
         {
             DataTable table = new DataTable();
 
             for (int i = 0; i <= dt.Rows.Count; i++)
             { table.Columns.Add(Convert.ToString(i)); }
 
             DataRow r;
             for (int k = 0; k < dt.Columns.Count; k++)
             {
                 r = table.NewRow();
                 r[0] = dt.Columns[k].ToString();
                 for (int j = 1; j <= dt.Rows.Count; j++)
                 { r[j] = dt.Rows[j - 1][k]; }
                 table.Rows.Add(r);
             }
             ds.Tables.Add(table);
         }
 
         dataGrid1.ItemsSource = ds.Tables[0].DefaultView;
     }
     catch (Exception ex)
     {
         Console.WriteLine(ex.Message);
     }
 }

Thanks
Posted 19-Dec-12 4:18am

1 solution

Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

What you need to do is pivot your data on a columns content. This article [^]may be useful
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web03 | 2.8.160212.1 | Last Updated 20 Dec 2012
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100