开发者

Formatting Cells in DataGridViewColumn

开发者 https://www.devze.com 2023-03-01 13:58 出处:网络
How can I display the string with value: 12345678 to the 开发者_JAVA百科user in a datagridview cell as: 1234/56/78.

How can I display the string with value: 12345678 to the 开发者_JAVA百科user in a datagridview cell as: 1234/56/78.

I think I should use the DefaultCellStyle.Format property of the DataGridViewColumn, But I don't know what the appropriate value is.

I'm using .NET Framework 2.0


you can set the format like this for your case

foreach (DataGridViewRow var in dataGridView1.Rows)
{
    (var.Cells[7] as DataGridViewTextBoxCell).Style.Format = "0000/00/00";
}


using System;
using System.Windows.Forms;

namespace DGVFormatColumn
{
   public class MyCell : DataGridViewTextBoxCell
   {
      protected override object GetFormattedValue(object value, int rowIndex, ref DataGridViewCellStyle cellStyle, System.ComponentModel.TypeConverter valueTypeConverter, System.ComponentModel.TypeConverter formattedValueTypeConverter, DataGridViewDataErrorContexts context)
      {
         String fullString = Value as String;

         // if we don't have an 8 character string, just call the base method with the values which were passed in
         if (fullString == null || fullString.Length != 8 || IsInEditMode)
            return base.GetFormattedValue(value, rowIndex, ref cellStyle, valueTypeConverter, formattedValueTypeConverter, context);

         // split the string into 3 parts
         String[] parts = new String[3];
         parts[0] = fullString.Substring(0, 4);
         parts[1] = fullString.Substring(4, 2);
         parts[2] = fullString.Substring(6, 2);

         // combine the parts with a "/" as separator
         String formattedValue = String.Join("/", parts);

         return formattedValue;
      }
   }

   class MyForm : Form
   {
      public MyForm()
      {
         // create a datagridview with 1 column and add it to the form
         DataGridView dgv = new DataGridView();
         DataGridViewColumn col = new DataGridViewColumn(new MyCell()); // use my custom cell as default cell template
         dgv.Columns.Add(col);
         this.Controls.Add(dgv);
      }
   }

   static class Program
   {
      static void Main()
      {
         Application.Run(new MyForm());
      }
   }
}
0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号