Click here to Skip to main content
Rate this: bad
good
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
0 George Jonsson 215
1 Kornfeld Eliyahu Peter 169
2 OriginalGriff 120
3 PIEBALDconsult 110
4 BillWoodruff 85
0 OriginalGriff 6,165
1 DamithSL 4,658
2 Maciej Los 4,087
3 Kornfeld Eliyahu Peter 3,649
4 Sergey Alexandrovich Kryukov 3,294


Advertise | Privacy | Mobile
Web01 | 2.8.141220.1 | Last Updated 20 Dec 2012
Copyright © CodeProject, 1999-2014
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