可以在垂直方向上获取HeaderText列吗？ [英] is it Possible to get a HeaderText Columns on the vertical?

问题描述

盖伊，我需要你的帮助。我选择DataTable dt1 之后从数据库收集我的数据我选择了我将在我的新对象DataTable dt2 中添加的列，而不是我只需要传输我的dt2的avlues到datagridview。就像你可以在Code中看到Hier。

Hi Guy i Need your help please. I collect my data from database througth DataTable dt1 after it i choice wich Column i will add in my new Object DataTable dt2 and than i just Need to Transfer avlues of my dt2 on to datagridview. like you can see Hier in Code.

using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;
using System.Data;
using System.Globalization;
using System.Threading;
using System.Drawing;
using System.IO;
using System.Windows.Forms;
using System.Reflection;

amespace Kommissionierung
{
     public static class __DataRequest
    {
        private static string rowValue = "";
        private static string Status;
        private static string ArtikelNr;
        private static int index = 0;
        private static string Mitarbeiter;
        private static string ArtikelName;
        private static bool result = true;
        private static string prioritaet;
       private static DataGridViewCheckBoxColumn chk = new DataGridViewCheckBoxColumn();


 public static DataTable KommissionAktualisieren(DataGridView dg)
{  DataTable dt = new DataTable();
    using (SqlConnection connection = new SqlConnection())
    {
   connection.ConnectionString = Properties.Settings.Default.KomissionierungDemoConnectionString;
 DataSet ds = new DataSet();
 SqlDataAdapter da = new SqlDataAdapter(
            try
            {
 da.SelectCommand = new SqlCommand("SELECT * FROM V_KommissionAnsicht ", connection);
   ds.Clear();
    da.Fill(ds);
    dt = ds.Tables[0];
    DataTable dt2 = new DataTable();
    DataRow row;


   foreach (DataTable dts in ds.Tables)
   {
     foreach (DataRow dr in dts.Rows)
      {
        row = dt2.NewRow();
        ArtikelNr = dr.ItemArray[2].ToString();
        Status = dr.ItemArray[4].ToString();
        Mitarbeiter = dr.ItemArray[3].ToString();
        prioritaet = dr.ItemArray[5].ToString();

        if (dt2.Columns.Contains("Artikel") == false)
        {
          chk.Name = "checked";
          chk.HeaderText = "Text";
         chk.Resizable = DataGridViewTriState.False;  
         dg.Columns.Add(chk);
         dt2.Columns.Add("Artikel");
        }

       if (dt2.Columns[0].ToString() == "Artikel")
        {
           row["Artikel"] = dr.ItemArray[1].ToString();
           ArtikelName = row["Artikel"].ToString();

            }

          if (dt2.Columns.Contains("ArtikelNr") == false)
        {
           dt2.Columns.Add("ArtikelNr");
        }

         if (dt2.Columns[1].ToString() == "ArtikelNr")
           {
              row["ArtikelNr"] = dr.ItemArray[2].ToString();
           }
         if (dt2.Columns.Contains("Prioritaet") == false)
           {
            dt2.Columns.Add("Prioritaet");
           }
         if (dt2.Columns[2].ToString() == "Prioritaet")
         {
           row["Prioritaet"] = dr.ItemArray[5].ToString();
         }
     }
  }
 }

我有问题。在我的DataGridView上，我想在垂直方向上获取我的列的HeaderText。



有人有想法吗？

除了得到一列喜欢这个

| Col1 | Col2 |

我需要得到这样的



| C | C |
| o | o |

| l | l |

| 1 | 2 |

I have a Problem please. on my DataGridView i want to get a HeaderText of my Columns on the Vertical.

has somebody an idea?
Beside to get a column like this
|Col1|Col2|
I Need to get it like this

|C|C|
|o|o|
|l | l|
|1|2|

推荐答案

这里是解决方案检查带有垂直文本的Datagridview标题单元格

这篇关于可以在垂直方向上获取HeaderText列吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！