开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > Windows编程 > 数据库编程 > 查看源码
Form1.cs
资源名称：VC#.NET范例.rar　[点击查看]
上传用户：chinafred
上传日期：2007-08-14
资源大小：10127k
文件大小：17k
源码类别：

数据库编程

开发平台：

C#

Form1.cs：源码内容
  1. using System;
  2. using System.Drawing;
  3. using System.Collections;
  4. using System.ComponentModel;
  5. using System.Windows.Forms;
  6. using System.Data;
  8. using System.Data.OleDb;
  10. namespace ch6_1
  11. {
  12. /// <summary>
  13. /// Form1 的摘要说明。
  14. /// </summary>
  15. public class Form1 : System.Windows.Forms.Form
  16. {
  17. private System.Data.OleDb.OleDbConnection oleDbConnection1;
  18. private System.Windows.Forms.GroupBox groupBox1;
  19. private System.Windows.Forms.Label label1;
  20. private System.Windows.Forms.Label label2;
  21. private System.Windows.Forms.Label label3;
  22. private System.Windows.Forms.Label label4;
  23. private System.Windows.Forms.TextBox textBox1;
  24. private System.Windows.Forms.TextBox textBox2;
  25. private System.Windows.Forms.TextBox textBox3;
  26. private System.Windows.Forms.TextBox textBox4;
  27. private System.Windows.Forms.Button button1;
  28. private System.Windows.Forms.Button button2;
  29. private System.Data.OleDb.OleDbDataAdapter oleDbDataAdapter1;
  30. private System.Data.OleDb.OleDbCommand oleDbSelectCommand1;
  31. private System.Data.OleDb.OleDbCommand oleDbInsertCommand1;
  32. private System.Data.OleDb.OleDbCommand oleDbUpdateCommand1;
  33. private System.Data.OleDb.OleDbCommand oleDbDeleteCommand1;
  34. private System.Data.DataSet dataSet1;
  36. private BindingManagerBase myBind;
  37. private System.Windows.Forms.Button button3;
  38. private System.Windows.Forms.Button button4;
  39. /// <summary>
  40. /// 必需的设计器变量。
  41. /// </summary>
  42. private System.ComponentModel.Container components = null;
  46. public Form1()
  47. {
  48. //
  49. // Windows 窗体设计器支持所必需的
  50. //
  51. InitializeComponent();
  54. DataBinding();
  58. //
  59. // TODO: 在 InitializeComponent 调用后添加任何构造函数代码
  60. //
  61. }
  63. private void DataBinding()
  64.     {
  66.             //刷新数据集
  67. this.oleDbDataAdapter1.Fill(this.dataSet1,"information");
  69.             //数据绑定
  70. this.textBox1.DataBindings.Add("Text",this.dataSet1,"information.姓名");
  71. this.textBox2.DataBindings.Add("Text",this.dataSet1,"information.年龄");
  72. this.textBox3.DataBindings.Add("Text",this.dataSet1,"information.电话");
  73. this.textBox4.DataBindings.Add("Text",this.dataSet1,"information.电子邮件");
  77. //构造
  78. myBind=this.BindingContext[this.dataSet1,"information"];
  80.    
  81. }
  83. /// <summary>
  84. /// 清理所有正在使用的资源。
  85. /// </summary>
  86. protected override void Dispose( bool disposing )
  87. {
  88. if( disposing )
  89. {
  90. if (components != null) 
  91. {
  92. components.Dispose();
  93. }
  94. }
  95. base.Dispose( disposing );
  96. }
  98. #region Windows Form Designer generated code
  99. /// <summary>
  100. /// 设计器支持所需的方法 - 不要使用代码编辑器修改
  101. /// 此方法的内容。
  102. /// </summary>
  103. private void InitializeComponent()
  104. {
  105. this.oleDbConnection1 = new System.Data.OleDb.OleDbConnection();
  106. this.groupBox1 = new System.Windows.Forms.GroupBox();
  107. this.textBox4 = new System.Windows.Forms.TextBox();
  108. this.textBox3 = new System.Windows.Forms.TextBox();
  109. this.textBox2 = new System.Windows.Forms.TextBox();
  110. this.textBox1 = new System.Windows.Forms.TextBox();
  111. this.label4 = new System.Windows.Forms.Label();
  112. this.label3 = new System.Windows.Forms.Label();
  113. this.label2 = new System.Windows.Forms.Label();
  114. this.label1 = new System.Windows.Forms.Label();
  115. this.button1 = new System.Windows.Forms.Button();
  116. this.button2 = new System.Windows.Forms.Button();
  117. this.oleDbDataAdapter1 = new System.Data.OleDb.OleDbDataAdapter();
  118. this.oleDbDeleteCommand1 = new System.Data.OleDb.OleDbCommand();
  119. this.oleDbInsertCommand1 = new System.Data.OleDb.OleDbCommand();
  120. this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand();
  121. this.oleDbUpdateCommand1 = new System.Data.OleDb.OleDbCommand();
  122. this.dataSet1 = new System.Data.DataSet();
  123. this.button3 = new System.Windows.Forms.Button();
  124. this.button4 = new System.Windows.Forms.Button();
  125. this.groupBox1.SuspendLayout();
  126. ((System.ComponentModel.ISupportInitialize)(this.dataSet1)).BeginInit();
  127. this.SuspendLayout();
  128. // 
  129. // oleDbConnection1
  130. // 
  131. this.oleDbConnection1.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Password="""";User ID=Admin;Data Source=D:Documents and Settingsadministrator.TRINCE-JULIEMy Documentsperson.mdb;Mode=Share Deny None;Extended Properties="""";Jet OLEDB:System database="""";Jet OLEDB:Registry Path="""";Jet OLEDB:Database Password="""";Jet OLEDB:Engine Type=5;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="""";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False";
  132. // 
  133. // groupBox1
  134. // 
  135. this.groupBox1.Controls.AddRange(new System.Windows.Forms.Control[] {
  136. this.textBox4,
  137. this.textBox3,
  138. this.textBox2,
  139. this.textBox1,
  140. this.label4,
  141. this.label3,
  142. this.label2,
  143. this.label1});
  144. this.groupBox1.Location = new System.Drawing.Point(16, 16);
  145. this.groupBox1.Name = "groupBox1";
  146. this.groupBox1.Size = new System.Drawing.Size(264, 168);
  147. this.groupBox1.TabIndex = 1;
  148. this.groupBox1.TabStop = false;
  149. this.groupBox1.Text = "我的朋友";
  150. // 
  151. // textBox4
  152. // 
  153. this.textBox4.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
  154. this.textBox4.Location = new System.Drawing.Point(96, 124);
  155. this.textBox4.Name = "textBox4";
  156. this.textBox4.Size = new System.Drawing.Size(152, 21);
  157. this.textBox4.TabIndex = 8;
  158. this.textBox4.Text = "";
  159. // 
  160. // textBox3
  161. // 
  162. this.textBox3.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
  163. this.textBox3.Location = new System.Drawing.Point(96, 92);
  164. this.textBox3.Name = "textBox3";
  165. this.textBox3.Size = new System.Drawing.Size(152, 21);
  166. this.textBox3.TabIndex = 7;
  167. this.textBox3.Text = "";
  168. // 
  169. // textBox2
  170. // 
  171. this.textBox2.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
  172. this.textBox2.Location = new System.Drawing.Point(96, 58);
  173. this.textBox2.Name = "textBox2";
  174. this.textBox2.Size = new System.Drawing.Size(152, 21);
  175. this.textBox2.TabIndex = 6;
  176. this.textBox2.Text = "";
  177. // 
  178. // textBox1
  179. // 
  180. this.textBox1.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
  181. this.textBox1.Location = new System.Drawing.Point(96, 26);
  182. this.textBox1.Name = "textBox1";
  183. this.textBox1.Size = new System.Drawing.Size(152, 21);
  184. this.textBox1.TabIndex = 5;
  185. this.textBox1.Text = "";
  186. // 
  187. // label4
  188. // 
  189. this.label4.Location = new System.Drawing.Point(16, 128);
  190. this.label4.Name = "label4";
  191. this.label4.Size = new System.Drawing.Size(64, 16);
  192. this.label4.TabIndex = 4;
  193. this.label4.Text = "电子邮件";
  194. // 
  195. // label3
  196. // 
  197. this.label3.Location = new System.Drawing.Point(16, 96);
  198. this.label3.Name = "label3";
  199. this.label3.Size = new System.Drawing.Size(72, 16);
  200. this.label3.TabIndex = 3;
  201. this.label3.Text = "电话";
  202. // 
  203. // label2
  204. // 
  205. this.label2.Location = new System.Drawing.Point(16, 64);
  206. this.label2.Name = "label2";
  207. this.label2.Size = new System.Drawing.Size(72, 16);
  208. this.label2.TabIndex = 2;
  209. this.label2.Text = "年龄";
  210. // 
  211. // label1
  212. // 
  213. this.label1.Location = new System.Drawing.Point(16, 32);
  214. this.label1.Name = "label1";
  215. this.label1.Size = new System.Drawing.Size(72, 16);
  216. this.label1.TabIndex = 1;
  217. this.label1.Text = "姓名";
  218. // 
  219. // button1
  220. // 
  221. this.button1.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
  222. this.button1.Location = new System.Drawing.Point(72, 200);
  223. this.button1.Name = "button1";
  224. this.button1.Size = new System.Drawing.Size(72, 24);
  225. this.button1.TabIndex = 2;
  226. this.button1.Text = "前一个";
  227. this.button1.Click += new System.EventHandler(this.button1_Click);
  228. // 
  229. // button2
  230. // 
  231. this.button2.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
  232. this.button2.Location = new System.Drawing.Point(144, 200);
  233. this.button2.Name = "button2";
  234. this.button2.Size = new System.Drawing.Size(75, 24);
  235. this.button2.TabIndex = 3;
  236. this.button2.Text = "后一个";
  237. this.button2.Click += new System.EventHandler(this.button2_Click);
  238. // 
  239. // oleDbDataAdapter1
  240. // 
  241. this.oleDbDataAdapter1.DeleteCommand = this.oleDbDeleteCommand1;
  242. this.oleDbDataAdapter1.InsertCommand = this.oleDbInsertCommand1;
  243. this.oleDbDataAdapter1.SelectCommand = this.oleDbSelectCommand1;
  244. this.oleDbDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
  245. new System.Data.Common.DataTableMapping("Table", "information", new System.Data.Common.DataColumnMapping[] {
  246.    new System.Data.Common.DataColumnMapping("姓名", "姓名"),
  247.    new System.Data.Common.DataColumnMapping("年龄", "年龄"),
  248.    new System.Data.Common.DataColumnMapping("电话", "电话"),
  249.    new System.Data.Common.DataColumnMapping("电子邮件", "电子邮件")})});
  250. this.oleDbDataAdapter1.UpdateCommand = this.oleDbUpdateCommand1;
  251. // 
  252. // oleDbDeleteCommand1
  253. // 
  254. this.oleDbDeleteCommand1.CommandText = "DELETE FROM information WHERE (姓名 = ?) AND (电子邮件 = ? OR ? IS NULL AND 电子邮件 IS NUL" +
  255. "L) AND (电话 = ? OR ? IS NULL AND 电话 IS NULL)";
  256. this.oleDbDeleteCommand1.Connection = this.oleDbConnection1;
  257. this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_姓名", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "姓名", System.Data.DataRowVersion.Original, null));
  258. this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_电子邮件", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "电子邮件", System.Data.DataRowVersion.Original, null));
  259. this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_电子邮件1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "电子邮件", System.Data.DataRowVersion.Original, null));
  260. this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_电话", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "电话", System.Data.DataRowVersion.Original, null));
  261. this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_电话1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "电话", System.Data.DataRowVersion.Original, null));
  262. // 
  263. // oleDbInsertCommand1
  264. // 
  265. this.oleDbInsertCommand1.CommandText = "INSERT INTO information(电话, 电子邮件, 年龄, 姓名) VALUES (?, ?, ?, ?)";
  266. this.oleDbInsertCommand1.Connection = this.oleDbConnection1;
  267. this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("电话", System.Data.OleDb.OleDbType.VarWChar, 50, "电话"));
  268. this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("电子邮件", System.Data.OleDb.OleDbType.VarWChar, 50, "电子邮件"));
  269. this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("年龄", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "年龄", System.Data.DataRowVersion.Current, null));
  270. this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("姓名", System.Data.OleDb.OleDbType.VarWChar, 50, "姓名"));
  271. // 
  272. // oleDbSelectCommand1
  273. // 
  274. this.oleDbSelectCommand1.CommandText = "SELECT 电话, 电子邮件, 年龄, 姓名 FROM information";
  275. this.oleDbSelectCommand1.Connection = this.oleDbConnection1;
  276. // 
  277. // oleDbUpdateCommand1
  278. // 
  279. this.oleDbUpdateCommand1.CommandText = "UPDATE information SET 电话 = ?, 电子邮件 = ?, 年龄 = ?, 姓名 = ? WHERE (姓名 = ?) AND (电子邮件 " +
  280. "= ? OR ? IS NULL AND 电子邮件 IS NULL) AND (电话 = ? OR ? IS NULL AND 电话 IS NULL)";
  281. this.oleDbUpdateCommand1.Connection = this.oleDbConnection1;
  282. this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("电话", System.Data.OleDb.OleDbType.VarWChar, 50, "电话"));
  283. this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("电子邮件", System.Data.OleDb.OleDbType.VarWChar, 50, "电子邮件"));
  284. this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("年龄", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "年龄", System.Data.DataRowVersion.Current, null));
  285. this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("姓名", System.Data.OleDb.OleDbType.VarWChar, 50, "姓名"));
  286. this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_姓名", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "姓名", System.Data.DataRowVersion.Original, null));
  287. this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_电子邮件", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "电子邮件", System.Data.DataRowVersion.Original, null));
  288. this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_电子邮件1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "电子邮件", System.Data.DataRowVersion.Original, null));
  289. this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_电话", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "电话", System.Data.DataRowVersion.Original, null));
  290. this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_电话1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "电话", System.Data.DataRowVersion.Original, null));
  291. // 
  292. // dataSet1
  293. // 
  294. this.dataSet1.DataSetName = "NewDataSet";
  295. this.dataSet1.Locale = new System.Globalization.CultureInfo("zh-CN");
  296. // 
  297. // button3
  298. // 
  299. this.button3.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
  300. this.button3.Location = new System.Drawing.Point(216, 200);
  301. this.button3.Name = "button3";
  302. this.button3.Size = new System.Drawing.Size(64, 24);
  303. this.button3.TabIndex = 4;
  304. this.button3.Text = "最后";
  305. this.button3.Click += new System.EventHandler(this.button3_Click);
  306. // 
  307. // button4
  308. // 
  309. this.button4.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
  310. this.button4.Location = new System.Drawing.Point(8, 200);
  311. this.button4.Name = "button4";
  312. this.button4.Size = new System.Drawing.Size(64, 24);
  313. this.button4.TabIndex = 5;
  314. this.button4.Text = "最前";
  315. this.button4.Click += new System.EventHandler(this.button4_Click);
  316. // 
  317. // Form1
  318. // 
  319. this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
  320. this.ClientSize = new System.Drawing.Size(292, 245);
  321. this.Controls.AddRange(new System.Windows.Forms.Control[] {
  322.   this.button4,
  323.   this.button3,
  324.   this.button2,
  325.   this.button1,
  326.   this.groupBox1});
  327. this.Name = "Form1";
  328. this.Text = "我的通讯录";
  329. this.groupBox1.ResumeLayout(false);
  330. ((System.ComponentModel.ISupportInitialize)(this.dataSet1)).EndInit();
  331. this.ResumeLayout(false);
  333. }
  334. #endregion
  336. /// <summary>
  337. /// 应用程序的主入口点。
  338. /// </summary>
  339. [STAThread]
  340. static void Main() 
  341. {
  342. Application.Run(new Form1());
  343. }
  345. private void button1_Click(object sender, System.EventArgs e)
  346. {
  347. //如果不是最前一条记录，则指针向前移动
  348. if (this.myBind.Position==0)
  349. {
  350. MessageBox.Show("没有前一条记录了","警告",MessageBoxButtons.OK,MessageBoxIcon.Information);
  351. }
  352. else
  353. {
  354. this.myBind.Position--;
  355. }
  356. }
  358. private void button2_Click(object sender, System.EventArgs e)
  359. {
  360. //如果不是最后一条记录，则指针向后移动
  361. if (this.myBind.Position==this.myBind.Count-1)
  362. {
  363. MessageBox.Show("没有后一条记录了","警告",MessageBoxButtons.OK,MessageBoxIcon.Information);
  364. }
  365. else
  366. {
  367. this.myBind.Position++;;
  368. }
  369. }
  371. private void button3_Click(object sender, System.EventArgs e)
  372. {
  373. //指向最后一条记录
  374. this.myBind.Position=this.myBind.Count-1;
  375. }
  377. private void button4_Click(object sender, System.EventArgs e)
  378. {
  379. //指向第一条记录
  380. this.myBind.Position=0;
  381. }
  382. }
  383. }