Click here to Skip to main content
12,943,701 members (56,159 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
OriginalGriff 4,643
CHill60 2,970
Maciej Los 2,348
Jochen Arndt 1,900
ppolymorphe 1,765

Advertise | Privacy | Mobile
Web02 | 2.8.170518.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