这篇文章主要介绍了C#中DataBindings用法,结合实例形式详细分析了DataBindings绑定数据源及刷新数据的相关技巧,具有一定参考借鉴价值,需要的朋友可以参考下
正文
C#中DataBindings用法实例分析
本文实例讲述了C#中DataBindings用法。分享给大家供大家参考，具体如下：
在C#操作数据库过程中，针对一般的文本控件，比如TextBox，Label等，我们赋值直接使用类似TextBox.Text=****的方式来进行，这种方式从某种意义上来说的确是最简便的方式，但是对于复杂一些的空间，比如说DataGridView，这个时候，绑定数据源我们一般使用DataGridView1.DataSource=****的方式来进行，如果数据源稍微有更改，那么只需要重新调用绑定一遍即可。可以说这种方式是单向的，也即从数据库到UI，但是有没有一种方式能够实现数据源改变的时候，不用重新绑定DataGridView就让它能够自动刷新数据呢，当然，这里要提到的就是DataBinding了。
代码如下
Form2.cs代码：
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
|
using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;namespace DataBindingsTest{ public partial class Form2 : Form { public Form2() { InitializeComponent(); } MyDataSource mydatasource = new MyDataSource(); //应用于第二种方式 public int Num { get; set; } //应用于第三种方式 public List<BlogNew> blogNews { get; set; } //应用于第四种方式 public BindingList<BlogNew> blogNewsRegardUI { get; set; } //应用于DataGridView界面UI更新 private void mainFrm_Load(object sender, EventArgs e) { #region 测试一 /************************************************ * 第一个值：要绑定到TextBox的什么地方 * 第二个值：数据源是什么 * 第三个值：应该取数据源的什么属性 * 第四个值：是否开启数据格式化 * 第五个值：在什么时候启用数据源绑定 * *********************************************/ textBox1.DataBindings.Add("Text", trackBar1, "Value", false, DataSourceUpdateMode.OnPropertyChanged); #endregion #region 测试二 /********************************************* * 这个主要就是通过一个外部的类，当做数据源 * *********************************************/ mydatasource.Myvalue = "这是个测试"; textBox2.DataBindings.Add("Text", mydatasource, "Myvalue", false, DataSourceUpdateMode.OnPropertyChanged); #endregion #region 测试三 /***************************************** *这个主要就是通过本身拥有的属性，当做数据源 ****************************************/ Num = 5; textBox3.DataBindings.Add("Text", this, "Num", false, DataSourceUpdateMode.OnPropertyChanged); #endregion /* * 注意：上面的3个测试，改变文本框中的值，数据源中对应的属性值会改变 * 但是，数据源的属性值改变了，文本框中的值不会改变 */ #region 测试四 ： List<T> blogNews = new List<BlogNew>(); blogNews.Add(new BlogNew { BlogID = 1, BlogTitle = "人生若只如初见" }); blogNews.Add(new BlogNew { BlogID = 2, BlogTitle = "何事秋风悲画扇" }); blogNews.Add(new BlogNew { BlogID = 3, BlogTitle = "最喜欢纳兰性德" }); dataGridView1.DataBindings.Add("DataSource", this, "blogNews", false, DataSourceUpdateMode.OnPropertyChanged); #endregion #region 测试五 ： BindingList<T> blogNewsRegardUI = new BindingList<BlogNew>(); blogNewsRegardUI.Add(new BlogNew { BlogID = 11, BlogTitle = "僵卧孤村不自哀" }); blogNewsRegardUI.Add(new BlogNew { BlogID = 12, BlogTitle = "尚思为国戍轮台" }); blogNewsRegardUI.Add(new BlogNew { BlogID = 13, BlogTitle = "夜阑卧听风吹雨" }); dataGridView2.DataBindings.Add("DataSource", this, "blogNewsRegardUI", false, DataSourceUpdateMode.OnPropertyChanged); #endregion } private void button1_Click(object sender, EventArgs e) { //从这里可以看出，改变了TextBox2中的值，这里的值也改变了，原因是因为类属于引用类型 MessageBox.Show(mydatasource.Myvalue); } private void button2_Click(object sender, EventArgs e) { //从这里可以看出，改变了TextBox3中的值，这里的值也改变了， //原因是Num被当做了当前窗体的一个属性(窗体本身就是一个类)，也属于引用类型 MessageBox.Show(Num.ToString()); //this.Num = 10; //MessageBox.Show(Num.ToString()); } private void button3_Click(object sender, EventArgs e) { //在这里向DataGridView中插入一行 var data = dataGridView1.DataSource as List<BlogNew>; data.Add(new BlogNew { BlogID = 4, BlogTitle = "取次花丛懒回顾，半缘修道半缘君" }); foreach (BlogNew blogNew in dataGridView1.DataSource as List<BlogNew>) { /*********** * 当我们心插入一条BlogID记录为4的数据的时候，在界面上可以看出dataGridView1的dataSource已经被更新， * 但是界面上依旧显示为BlogID为1,2,3三条数据，很奇怪 * *********************/ MessageBox.Show(blogNew.BlogID + "--" + blogNew.BlogTitle); } } private void button4_Click(object sender, EventArgs e) { /*这里主要用来解决DataGridView1界面不更新的问题，其实原因在于使用了List<BlogNew>,这里我们采用BindList<BlogNew> *通过测试，我们发现，只要数据源改变，界面就可以自动的进行更新了，很是方便，不需要重新绑定 */ var dataRegardUI = dataGridView2.DataSource as BindingList<BlogNew>; dataRegardUI.Add(new BlogNew { BlogID = 20, BlogTitle = "竹外桃花三两枝，春江水暖鸭先知" }); } } public class MyDataSource { public string Myvalue { get; set; } } public class BlogNew { public int BlogID { get; set; } public string BlogTitle { get; set; } }} |
Form2.Designer.cs代码：
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
|
namespace DataBindingsTest{ partial class Form2 { /// <summary> /// Required designer variable. /// </summary> private System.ComponentModel.IContainer components = null; /// <summary> /// Clean up any resources being used. /// </summary> /// <param name="disposing">true if managed resources should be disposed; otherwise, false.</param> protected override void Dispose(bool disposing) { if (disposing && (components != null)) { components.Dispose(); } base.Dispose(disposing); } #region Windows Form Designer generated code /// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { this.groupBox1 = new System.Windows.Forms.GroupBox(); this.groupBox2 = new System.Windows.Forms.GroupBox(); this.button1 = new System.Windows.Forms.Button(); this.textBox2 = new System.Windows.Forms.TextBox(); this.groupBox3 = new System.Windows.Forms.GroupBox(); this.button2 = new System.Windows.Forms.Button(); this.textBox3 = new System.Windows.Forms.TextBox(); this.groupBox4 = new System.Windows.Forms.GroupBox(); this.button3 = new System.Windows.Forms.Button(); this.dataGridView1 = new System.Windows.Forms.DataGridView(); this.groupBox5 = new System.Windows.Forms.GroupBox(); this.button4 = new System.Windows.Forms.Button(); this.dataGridView2 = new System.Windows.Forms.DataGridView(); this.textBox1 = new System.Windows.Forms.TextBox(); this.trackBar1 = new System.Windows.Forms.TrackBar(); this.groupBox1.SuspendLayout(); this.groupBox2.SuspendLayout(); this.groupBox3.SuspendLayout(); this.groupBox4.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.dataGridView1)).BeginInit(); this.groupBox5.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.dataGridView2)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.trackBar1)).BeginInit(); this.SuspendLayout(); // // groupBox1 // this.groupBox1.Controls.Add(this.trackBar1); this.groupBox1.Controls.Add(this.textBox1); this.groupBox1.Location = new System.Drawing.Point(12, 12); this.groupBox1.Name = "groupBox1"; this.groupBox1.Size = new System.Drawing.Size(200, 100); this.groupBox1.TabIndex = 0; this.groupBox1.TabStop = false; this.groupBox1.Text = "方式一"; // // groupBox2 // this.groupBox2.Controls.Add(this.button1); this.groupBox2.Controls.Add(this.textBox2); this.groupBox2.Location = new System.Drawing.Point(218, 12); this.groupBox2.Name = "groupBox2"; this.groupBox2.Size = new System.Drawing.Size(200, 100); this.groupBox2.TabIndex = 2; this.groupBox2.TabStop = false; this.groupBox2.Text = "方式二"; // // button1 // this.button1.Location = new System.Drawing.Point(22, 59); this.button1.Name = "button1"; this.button1.Size = new System.Drawing.Size(157, 23); this.button1.TabIndex = 3; this.button1.Text = "查看已修改的数据源的值"; this.button1.UseVisualStyleBackColor = true; this.button1.Click += new System.EventHandler(this.button1_Click); // // textBox2 // this.textBox2.Location = new System.Drawing.Point(22, 20); this.textBox2.Name = "textBox2"; this.textBox2.Size = new System.Drawing.Size(157, 21); this.textBox2.TabIndex = 2; // // groupBox3 // this.groupBox3.Controls.Add(this.button2); this.groupBox3.Controls.Add(this.textBox3); this.groupBox3.Location = new System.Drawing.Point(428, 12); this.groupBox3.Name = "groupBox3"; this.groupBox3.Size = new System.Drawing.Size(200, 100); this.groupBox3.TabIndex = 4; this.groupBox3.TabStop = false; this.groupBox3.Text = "方式三"; // // button2 // this.button2.Location = new System.Drawing.Point(22, 59); this.button2.Name = "button2"; this.button2.Size = new System.Drawing.Size(157, 23); this.button2.TabIndex = 3; this.button2.Text = "查看已修改的数据源的值"; this.button2.UseVisualStyleBackColor = true; this.button2.Click += new System.EventHandler(this.button2_Click); // // textBox3 // this.textBox3.Location = new System.Drawing.Point(22, 20); this.textBox3.Name = "textBox3"; this.textBox3.Size = new System.Drawing.Size(157, 21); this.textBox3.TabIndex = 2; // // groupBox4 // this.groupBox4.Controls.Add(this.button3); this.groupBox4.Controls.Add(this.dataGridView1); this.groupBox4.Location = new System.Drawing.Point(12, 118); this.groupBox4.Name = "groupBox4"; this.groupBox4.Size = new System.Drawing.Size(568, 157); this.groupBox4.TabIndex = 5; this.groupBox4.TabStop = false; this.groupBox4.Text = "方式四"; // // button3 // this.button3.Location = new System.Drawing.Point(377, 122); this.button3.Name = "button3"; this.button3.Size = new System.Drawing.Size(157, 23); this.button3.TabIndex = 4; this.button3.Text = "插入一行"; this.button3.UseVisualStyleBackColor = true; this.button3.Click += new System.EventHandler(this.button3_Click); // // dataGridView1 // this.dataGridView1.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize; this.dataGridView1.Location = new System.Drawing.Point(18, 20); this.dataGridView1.Name = "dataGridView1"; this.dataGridView1.RowTemplate.Height = 23; this.dataGridView1.Size = new System.Drawing.Size(516, 96); this.dataGridView1.TabIndex = 0; // // groupBox5 // this.groupBox5.Controls.Add(this.button4); this.groupBox5.Controls.Add(this.dataGridView2); this.groupBox5.Location = new System.Drawing.Point(12, 281); this.groupBox5.Name = "groupBox5"; this.groupBox5.Size = new System.Drawing.Size(568, 162); this.groupBox5.TabIndex = 6; this.groupBox5.TabStop = false; this.groupBox5.Text = "方式五"; // // button4 // this.button4.Location = new System.Drawing.Point(377, 127); this.button4.Name = "button4"; this.button4.Size = new System.Drawing.Size(157, 23); this.button4.TabIndex = 4; this.button4.Text = "插入一行"; this.button4.UseVisualStyleBackColor = true; this.button4.Click += new System.EventHandler(this.button4_Click); // // dataGridView2 // this.dataGridView2.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize; this.dataGridView2.Location = new System.Drawing.Point(18, 20); this.dataGridView2.Name = "dataGridView2"; this.dataGridView2.RowTemplate.Height = 23; this.dataGridView2.Size = new System.Drawing.Size(516, 91); this.dataGridView2.TabIndex = 0; // // textBox1 // this.textBox1.Location = new System.Drawing.Point(18, 20); this.textBox1.Name = "textBox1"; this.textBox1.Size = new System.Drawing.Size(157, 21); this.textBox1.TabIndex = 0; // // trackBar1 // this.trackBar1.Location = new System.Drawing.Point(18, 47); this.trackBar1.Name = "trackBar1"; this.trackBar1.Size = new System.Drawing.Size(157, 45); this.trackBar1.TabIndex = 1; // // Form2 // this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 12F); this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; this.ClientSize = new System.Drawing.Size(676, 471); this.Controls.Add(this.groupBox5); this.Controls.Add(this.groupBox4); this.Controls.Add(this.groupBox3); this.Controls.Add(this.groupBox2); this.Controls.Add(this.groupBox1); this.Name = "Form2"; this.Text = "Form2"; this.Load += new System.EventHandler(this.mainFrm_Load); this.groupBox1.ResumeLayout(false); this.groupBox1.PerformLayout(); this.groupBox2.ResumeLayout(false); this.groupBox2.PerformLayout(); this.groupBox3.ResumeLayout(false); this.groupBox3.PerformLayout(); this.groupBox4.ResumeLayout(false); ((System.ComponentModel.ISupportInitialize)(this.dataGridView1)).EndInit(); this.groupBox5.ResumeLayout(false); ((System.ComponentModel.ISupportInitialize)(this.dataGridView2)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.trackBar1)).EndInit(); this.ResumeLayout(false); } #endregion private System.Windows.Forms.GroupBox groupBox1; private System.Windows.Forms.GroupBox groupBox2; private System.Windows.Forms.Button button1; private System.Windows.Forms.TextBox textBox2; private System.Windows.Forms.GroupBox groupBox3; private System.Windows.Forms.Button button2; private System.Windows.Forms.TextBox textBox3; private System.Windows.Forms.GroupBox groupBox4; private System.Windows.Forms.Button button3; private System.Windows.Forms.DataGridView dataGridView1; private System.Windows.Forms.GroupBox groupBox5; private System.Windows.Forms.Button button4; private System.Windows.Forms.DataGridView dataGridView2; private System.Windows.Forms.TrackBar trackBar1; private System.Windows.Forms.TextBox textBox1; }} |
效果图：
希望本文所述对大家C#程序设计有所帮助。
发表评论