C#如何在DataGridViewCell中自定义脚本编辑器

    上一篇博文探讨了如何自定义DataGridViewColumn实现一个TreeViewColumn来在DataGridView控件中显示TreeView控件,其实我们还可以继续发挥想象,自定义其他的列类型,下面介绍一个脚本编辑器列类型,我这里取名ScriptTextEditorColumn,当用户单击DataGridView的ScriptTextEditorColumn时,单元格右边会出现一个按钮,单击按钮会弹出一个脚本编辑器窗体,用户可以在窗体中进行代码维护,然后回写到单元格中。

  用人会问,这个控件有啥实际作用,其实结合动态编译的技术,在datagridview中进行取值公式的模板设定,也就是在对应的单元格中设置C#脚本,然后动态执行后呈现结果到一个datagridview单元格中,这样就实现了动态配置datagridview后台计算逻辑的目的,当然实现这样的功能还需要大量的工作,但是主要的思路就是这样。

1 ScriptTextEditorColumn

  1 using System;
  2 using System.Collections.Generic;
  3 using System.Linq;
  4 using System.Text;
  5 using System.Windows.Forms;
  6 
  7 namespace Host_Controls_in_Windows_Forms_DataGridView_Cells
  8 {
  9    public class ScriptTextEditorColumn : DataGridViewColumn
 10     {
 11        public ScriptTextEditorColumn()
 12            : base(new ScriptTextEditorCell())
 13         {
 14         }
 15 
 16         public override DataGridViewCell CellTemplate
 17         {
 18             get
 19             {
 20                 return base.CellTemplate;
 21             }
 22             set
 23             {
 24                 // Ensure that the cell used for the template is a ScriptTextEditorCell.
 25                 if (value != null &&
 26                     !value.GetType().IsAssignableFrom(typeof(ScriptTextEditorCell)))
 27                 {
 28                     throw new InvalidCastException("Must be a ScriptTextEditorCell");
 29                 }
 30                 base.CellTemplate = value;
 31             }
 32         }
 33     }
 34 
 35     //----------------------------------------------------------------------
 36     public class  ScriptTextEditorCell : DataGridViewTextBoxCell
 37     {
 38 
 39         public ScriptTextEditorCell()
 40             : base()
 41         {
 42            
 43         }
 44 
 45         public override void InitializeEditingControl(int rowIndex, object
 46             initialFormattedValue, DataGridViewCellStyle dataGridViewCellStyle)
 47         {
 48             // Set the value of the editing control to the current cell value.
 49             base.InitializeEditingControl(rowIndex, initialFormattedValue,
 50                 dataGridViewCellStyle);
 51             ScriptTextEditingControl ctl =
 52                 DataGridView.EditingControl as ScriptTextEditingControl;
 53             // Use the default row value when Value property is null.
 54             if (this.Value == null)
 55             {
 56                 ctl.textBox1.Text = (String)this.DefaultNewRowValue;
 57             }
 58             else
 59             {
 60                 ctl.textBox1.Text = (String)this.Value;
 61             }
 62         }
 63 
 64         public override Type EditType
 65         {
 66             get
 67             {
 68                 // Return the type of the editing control that CalendarCell uses.
 69                 return typeof(ScriptTextEditingControl);
 70             }
 71         }
 72 
 73         public override Type ValueType
 74         {
 75             get
 76             {
 77                 // Return the type of the value that CalendarCell contains.
 78 
 79                 return typeof(String);
 80             }
 81         }
 82 
 83         public override object DefaultNewRowValue
 84         {
 85             get
 86             {
 87                 // Use the current date and time as the default value.
 88                 string code = @"
 89 #region
 90 //jackwangcumt
 91 #endregion
 92 using System;
 93 using System.Collections.Generic;
 94 using System.ComponentModel;
 95 using System.Drawing;
 96 using System.Data;
 97 using System.Linq;
 98 using System.Text;
 99 using System.Windows.Forms;
100 namespace Host_Controls_in_Windows_Forms_DataGridView_Cells
101 {
102     public partial class SourceTextBox : UserControl
103     {
104         public SourceTextBox()
105         {
106             InitializeComponent();
107             this.textBox1.Location = this.Location;
108             this.textBox1.Width = this.Width;
109             this.textBox1.Height = this.Height;
110         }
111         protected void OnValueChanged(string text)
112         {
113             this.textBox1.Text = text;
114         }
115 
116         private void btnSource_Click(object sender, EventArgs e)
117         {
118             ScriptEditor frm = new ScriptEditor(this.textBox1.Text);
119             frm.ShowDialog();
120             this.textBox1.Text = frm.fastColoredTextBox1.Text;
121         }
122     }
123 }
124                 ";
125                 return code;
126             }
127         }
128     }
129     //-----------------------------------------------------------------
130 
131     class ScriptTextEditingControl : SourceTextBox, IDataGridViewEditingControl
132     {
133         DataGridView dataGridView;
134         private bool valueChanged = false;
135         int rowIndex;
136 
137         public ScriptTextEditingControl()
138         {
139             //文本变更更新到cell
140             this.textBox1.TextChanged += new EventHandler(textBox1_TextChanged);
141         }
142 
143         void textBox1_TextChanged(object sender, EventArgs e)
144         {
145             // Notify the DataGridView that the contents of the cell
146             // have changed.
147             valueChanged = true;
148             this.EditingControlDataGridView.NotifyCurrentCellDirty(true);
149             //调用SourceTextBox的OnValueChanged(string Text)
150             base.OnValueChanged(this.textBox1.Text);
151         }
152 
153         // Implements the IDataGridViewEditingControl.EditingControlFormattedValue 
154         // property.
155         public object EditingControlFormattedValue
156         {
157             get
158             {
159                 return this.textBox1.Text;
160             }
161             set
162             {
163                 if (value is String)
164                 {
165                     try
166                     {
167                         // This will throw an exception of the string is 
168                         // null, empty, or not in the format of a date.
169                        this.textBox1.Text=((String)value);
170                     }
171                     catch
172                     {
173                         // In the case of an exception, just use the 
174                         // default value so we're not left with a null
175                         // value.
176                         this.textBox1.Text = "jackwangcumt>>error";
177                     }
178                 }
179             }
180         }
181 
182         // Implements the 
183         // IDataGridViewEditingControl.GetEditingControlFormattedValue method.
184         public object GetEditingControlFormattedValue(
185             DataGridViewDataErrorContexts context)
186         {
187             return EditingControlFormattedValue;
188         }
189 
190         // Implements the 
191         // IDataGridViewEditingControl.ApplyCellStyleToEditingControl method.
192         public void ApplyCellStyleToEditingControl(
193             DataGridViewCellStyle dataGridViewCellStyle)
194         {
195             this.Font = dataGridViewCellStyle.Font;
196             //this.CalendarForeColor = dataGridViewCellStyle.ForeColor;
197             //this.CalendarMonthBackground = dataGridViewCellStyle.BackColor;
198         }
199 
200         // Implements the IDataGridViewEditingControl.EditingControlRowIndex 
201         // property.
202         public int EditingControlRowIndex
203         {
204             get
205             {
206                 return rowIndex;
207             }
208             set
209             {
210                 rowIndex = value;
211             }
212         }
213 
214         // Implements the IDataGridViewEditingControl.EditingControlWantsInputKey 
215         // method.
216         public bool EditingControlWantsInputKey(
217             Keys key, bool dataGridViewWantsInputKey)
218         {
219             // Let the DateTimePicker handle the keys listed.
220             switch (key & Keys.KeyCode)
221             {
222                 case Keys.Left:
223                 case Keys.Up:
224                 case Keys.Down:
225                 case Keys.Right:
226                 case Keys.Home:
227                 case Keys.End:
228                 case Keys.PageDown:
229                 case Keys.PageUp:
230                     return true;
231                 default:
232                     return !dataGridViewWantsInputKey;
233             }
234         }
235 
236         // Implements the IDataGridViewEditingControl.PrepareEditingControlForEdit 
237         // method.
238         public void PrepareEditingControlForEdit(bool selectAll)
239         {
240             // No preparation needs to be done.
241         }
242 
243         // Implements the IDataGridViewEditingControl
244         // .RepositionEditingControlOnValueChange property.
245         public bool RepositionEditingControlOnValueChange
246         {
247             get
248             {
249                 return false;
250             }
251         }
252 
253         // Implements the IDataGridViewEditingControl
254         // .EditingControlDataGridView property.
255         public DataGridView EditingControlDataGridView
256         {
257             get
258             {
259                 return dataGridView;
260             }
261             set
262             {
263                 dataGridView = value;
264             }
265         }
266 
267         // Implements the IDataGridViewEditingControl
268         // .EditingControlValueChanged property.
269         public bool EditingControlValueChanged
270         {
271             get
272             {
273                 return valueChanged;
274             }
275             set
276             {
277                 valueChanged = value;
278             }
279         }
280 
281         // Implements the IDataGridViewEditingControl
282         // .EditingPanelCursor property.
283         public Cursor EditingPanelCursor
284         {
285             get
286             {
287                 return base.Cursor;
288             }
289         }
290 
291         protected override void OnTextChanged(EventArgs e)
292         {
293             // Notify the DataGridView that the contents of the cell
294             // have changed.
295             valueChanged = true;
296             this.EditingControlDataGridView.NotifyCurrentCellDirty(true);
297             base.OnTextChanged(e);
298           
299         }
300    
301     }
302 
303 
304 
305 }

2 SourceTextBox

 1 using System;
 2 using System.Collections.Generic;
 3 using System.ComponentModel;
 4 using System.Drawing;
 5 using System.Data;
 6 using System.Linq;
 7 using System.Text;
 8 using System.Windows.Forms;
 9 
10 namespace Host_Controls_in_Windows_Forms_DataGridView_Cells
11 {
12     public partial class SourceTextBox : UserControl
13     {
14         public SourceTextBox()
15         {
16             InitializeComponent();
17             this.textBox1.Location = this.Location;
18             this.textBox1.Width = this.Width;
19             this.textBox1.Height = this.Height;
20         }
21         protected void OnValueChanged(string text)
22         {
23             this.textBox1.Text = text;
24         }
25 
26         private void btnSource_Click(object sender, EventArgs e)
27         {
28             ScriptEditor frm = new ScriptEditor(this.textBox1.Text);
29             frm.ShowDialog();
30             this.textBox1.Text = frm.fastColoredTextBox1.Text;
31         }
32     }
33 }
 1 namespace Host_Controls_in_Windows_Forms_DataGridView_Cells
 2 {
 3     partial class SourceTextBox
 4     {
 5         /// <summary> 
 6         /// 必需的设计器变量。
 7         /// </summary>
 8         private System.ComponentModel.IContainer components = null;
 9 
10         /// <summary> 
11         /// 清理所有正在使用的资源。
12         /// </summary>
13         /// <param name="disposing">如果应释放托管资源,为 true;否则为 false。</param>
14         protected override void Dispose(bool disposing)
15         {
16             if (disposing && (components != null))
17             {
18                 components.Dispose();
19             }
20             base.Dispose(disposing);
21         }
22 
23         #region 组件设计器生成的代码
24 
25         /// <summary> 
26         /// 设计器支持所需的方法 - 不要
27         /// 使用代码编辑器修改此方法的内容。
28         /// </summary>
29         private void InitializeComponent()
30         {
31             this.textBox1 = new System.Windows.Forms.TextBox();
32             this.btnSource = new System.Windows.Forms.Button();
33             this.SuspendLayout();
34             // 
35             // textBox1
36             // 
37             this.textBox1.BorderStyle = System.Windows.Forms.BorderStyle.None;
38             this.textBox1.Location = new System.Drawing.Point(3, 3);
39             this.textBox1.Margin = new System.Windows.Forms.Padding(4);
40             this.textBox1.Multiline = true;
41             this.textBox1.Name = "textBox1";
42             this.textBox1.Size = new System.Drawing.Size(175, 21);
43             this.textBox1.TabIndex = 1;
44             // 
45             // btnSource
46             // 
47             this.btnSource.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom)
48                         | System.Windows.Forms.AnchorStyles.Right)));
49             this.btnSource.BackColor = System.Drawing.Color.Transparent;
50             this.btnSource.BackgroundImage = global::Host_Controls_in_Windows_Forms_DataGridView_Cells.Resource.setting;
51             this.btnSource.BackgroundImageLayout = System.Windows.Forms.ImageLayout.Zoom;
52             this.btnSource.FlatAppearance.BorderColor = System.Drawing.Color.White;
53             this.btnSource.FlatAppearance.BorderSize = 0;
54             this.btnSource.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
55             this.btnSource.Font = new System.Drawing.Font("新宋体", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
56             this.btnSource.Location = new System.Drawing.Point(159, -1);
57             this.btnSource.Margin = new System.Windows.Forms.Padding(0);
58             this.btnSource.Name = "btnSource";
59             this.btnSource.Size = new System.Drawing.Size(19, 25);
60             this.btnSource.TabIndex = 0;
61             this.btnSource.UseVisualStyleBackColor = false;
62             this.btnSource.Click += new System.EventHandler(this.btnSource_Click);
63             // 
64             // SourceTextBox
65             // 
66             this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 12F);
67             this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
68             this.Controls.Add(this.btnSource);
69             this.Controls.Add(this.textBox1);
70             this.Margin = new System.Windows.Forms.Padding(0);
71             this.Name = "SourceTextBox";
72             this.Size = new System.Drawing.Size(178, 26);
73             this.ResumeLayout(false);
74             this.PerformLayout();
75 
76         }
77 
78         #endregion
79 
80         public System.Windows.Forms.Button btnSource;
81         public System.Windows.Forms.TextBox textBox1;
82     }
83 }
View Code

3 效果

 

原文地址:https://www.cnblogs.com/isaboy/p/datagridview_source_code_editor.html