Click here to Skip to main content
13,145,068 members (54,408 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


but I would like to display as


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)
               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]; }
               dataGrid1.ItemsSource = ds.Tables[0].DefaultView;
           catch (Exception ex)

Posted 19-Dec-12 3:18am

1 solution

Rate this: bad
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

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 |
Web04 | 2.8.170915.1 | Last Updated 20 Dec 2012
Copyright © CodeProject, 1999-2017
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