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); } }
pivot
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)