数据集列格式 [英] Dataset column formatting

问题描述

在我的N层应用程序中，我有一个包含以下代码的数据集：

In my N Tier application, I have a dataset with following code:

try
           {
               int acid;
               acid = Convert.ToInt32(textBoxActivityNumber.Text);
               _localds = new DataSet("CRMBCC");
               _localds = myActivity.GetAllServiceRequestsFromActivity(acid);//acid
               dataGridViewActivityServiceRequest.DataSource = _localds.Tables[0];
               //Make unvisible columns
               dataGridViewActivityServiceRequest.Columns["ActivityId"].Visible = false;
               dataGridViewActivityServiceRequest.Columns["ServiceRequestId"].Visible = false;
               dataGridViewActivityServiceRequest.Columns["ActivityServiceRequestId"].Visible = false;
               dataGridViewActivityServiceRequest.Columns["Description"].Visible = false;
               dataGridViewActivityServiceRequest.Columns["Comments"].Visible = false;
               dataGridViewActivityServiceRequest.Columns["OperationNumber"].Visible = false;
               dataGridViewActivityServiceRequest.Columns["ProductId"].Visible = false;
               dataGridViewActivityServiceRequest.Columns["ProductId1"].Visible = false;
               dataGridViewActivityServiceRequest.Columns["Active"].Visible = false;
               dataGridViewActivityServiceRequest.Columns["Type"].Visible = false;
               dataGridViewActivityServiceRequest.Columns["Line"].Visible = false;
               //Order columns
               dataGridViewActivityServiceRequest.Columns["ServiceRequestId1"].DisplayIndex = 1;
               dataGridViewActivityServiceRequest.Columns["Area"].DisplayIndex = 2;
               dataGridViewActivityServiceRequest.Columns["SubArea"].DisplayIndex = 3;
               dataGridViewActivityServiceRequest.Columns["Name"].DisplayIndex = 4;
               dataGridViewActivityServiceRequest.Columns["Priority"].DisplayIndex = 5;
               dataGridViewActivityServiceRequest.Columns["Status"].DisplayIndex = 6;

               dataGridViewActivityServiceRequest.Refresh();

           }
           catch (Exception ex)
           {
               MessageBox.Show(ex.Message, "Activity Service Requests",
                                                   MessageBoxButtons.OK, MessageBoxIcon.Error);
           }

现在我想给可见列另一个更有意义的名字，我想autoformat列的宽度？

有人可以帮我吗？



亲切的问候!!

Now I would like to give the visible columns another more meaningfull name AND I would like to autoformat the width of the columns?
Can someone help me with this?

Kind regards!!

推荐答案

设置自动列宽：

To set the auto column width:

dataGridView1.Columns["Col1"].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;

提供自定义列标题：

To give custom column headers:

dataGridView1.Columns["Col1"].HeaderText = "Custom Header";

这篇关于数据集列格式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！