Category

Development Platform
Home > SourceCode/Document > Windows Develop > ADO-ODBC > View Code
Form1.cs
Package: VC#.NET范例.rar　[view]
Upload User: chinafred
Upload Date: 2007-08-14
Package Size: 10127k
Code Size: 23k
Category:

ADO-ODBC

Development Platform:

C#

Form1.cs：Code Content
  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_3
  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.Data.OleDb.OleDbDataAdapter oleDbDataAdapter1;
  19. private System.Data.OleDb.OleDbCommand oleDbSelectCommand1;
  20. private System.Data.OleDb.OleDbCommand oleDbInsertCommand1;
  21. private System.Data.OleDb.OleDbCommand oleDbUpdateCommand1;
  22. private System.Data.OleDb.OleDbCommand oleDbDeleteCommand1;
  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.Label label1;
  28. private System.Windows.Forms.Label label2;
  29. private System.Windows.Forms.Label label3;
  30. private System.Windows.Forms.Label label4;
  31. private System.Windows.Forms.GroupBox groupBox1;
  32. private System.Windows.Forms.Button button1;
  33. private System.Windows.Forms.Button button2;
  34. private System.Windows.Forms.Button button3;
  35. private System.Windows.Forms.Button button4;
  36. private System.Windows.Forms.Button button5;
  37. private System.Windows.Forms.Button button6;
  39. private BindingManagerBase myBind;
  40. private System.Data.DataSet dataSet1;
  41. private System.Windows.Forms.Button button7;
  42. private System.Windows.Forms.Button button8;
  44. /// <summary>
  45. /// 必需的设计器变量。
  46. /// </summary>
  47. private System.ComponentModel.Container components = null;
  49. public Form1()
  50. {
  51. //
  52. // Windows 窗体设计器支持所必需的
  53. //
  54. InitializeComponent();
  56. 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.电子邮件");
  75. //构造
  76. myBind=this.BindingContext[this.dataSet1,"information"];
  78.    
  79. }
  80. /// <summary>
  81. /// 清理所有正在使用的资源。
  82. /// </summary>
  83. protected override void Dispose( bool disposing )
  84. {
  85. if( disposing )
  86. {
  87. if (components != null) 
  88. {
  89. components.Dispose();
  90. }
  91. }
  92. base.Dispose( disposing );
  93. }
  95. #region Windows Form Designer generated code
  96. /// <summary>
  97. /// 设计器支持所需的方法 - 不要使用代码编辑器修改
  98. /// 此方法的内容。
  99. /// </summary>
  100. private void InitializeComponent()
  101. {
  102. this.oleDbConnection1 = new System.Data.OleDb.OleDbConnection();
  103. this.oleDbDataAdapter1 = new System.Data.OleDb.OleDbDataAdapter();
  104. this.oleDbDeleteCommand1 = new System.Data.OleDb.OleDbCommand();
  105. this.oleDbInsertCommand1 = new System.Data.OleDb.OleDbCommand();
  106. this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand();
  107. this.oleDbUpdateCommand1 = new System.Data.OleDb.OleDbCommand();
  108. this.textBox1 = new System.Windows.Forms.TextBox();
  109. this.textBox2 = new System.Windows.Forms.TextBox();
  110. this.textBox3 = new System.Windows.Forms.TextBox();
  111. this.textBox4 = new System.Windows.Forms.TextBox();
  112. this.label1 = new System.Windows.Forms.Label();
  113. this.label2 = new System.Windows.Forms.Label();
  114. this.label3 = new System.Windows.Forms.Label();
  115. this.label4 = new System.Windows.Forms.Label();
  116. this.groupBox1 = new System.Windows.Forms.GroupBox();
  117. this.button1 = new System.Windows.Forms.Button();
  118. this.button2 = new System.Windows.Forms.Button();
  119. this.button3 = new System.Windows.Forms.Button();
  120. this.button4 = new System.Windows.Forms.Button();
  121. this.button5 = new System.Windows.Forms.Button();
  122. this.button6 = new System.Windows.Forms.Button();
  123. this.dataSet1 = new System.Data.DataSet();
  124. this.button7 = new System.Windows.Forms.Button();
  125. this.button8 = new System.Windows.Forms.Button();
  126. this.groupBox1.SuspendLayout();
  127. ((System.ComponentModel.ISupportInitialize)(this.dataSet1)).BeginInit();
  128. this.SuspendLayout();
  129. // 
  130. // oleDbConnection1
  131. // 
  132. 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";
  133. // 
  134. // oleDbDataAdapter1
  135. // 
  136. this.oleDbDataAdapter1.DeleteCommand = this.oleDbDeleteCommand1;
  137. this.oleDbDataAdapter1.InsertCommand = this.oleDbInsertCommand1;
  138. this.oleDbDataAdapter1.SelectCommand = this.oleDbSelectCommand1;
  139. this.oleDbDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
  140. new System.Data.Common.DataTableMapping("Table", "information", new System.Data.Common.DataColumnMapping[] {
  141.    new System.Data.Common.DataColumnMapping("姓名", "姓名"),
  142.    new System.Data.Common.DataColumnMapping("年龄", "年龄"),
  143.    new System.Data.Common.DataColumnMapping("电话", "电话"),
  144.    new System.Data.Common.DataColumnMapping("电子邮件", "电子邮件")})});
  145. this.oleDbDataAdapter1.UpdateCommand = this.oleDbUpdateCommand1;
  146. // 
  147. // oleDbDeleteCommand1
  148. // 
  149. this.oleDbDeleteCommand1.CommandText = "DELETE FROM information WHERE (姓名 = ?) AND (电子邮件 = ? OR ? IS NULL AND 电子邮件 IS NUL" +
  150. "L) AND (电话 = ? OR ? IS NULL AND 电话 IS NULL)";
  151. this.oleDbDeleteCommand1.Connection = this.oleDbConnection1;
  152. 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));
  153. 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));
  154. 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));
  155. 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));
  156. 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));
  157. // 
  158. // oleDbInsertCommand1
  159. // 
  160. this.oleDbInsertCommand1.CommandText = "INSERT INTO information(电话, 电子邮件, 年龄, 姓名) VALUES (?, ?, ?, ?)";
  161. this.oleDbInsertCommand1.Connection = this.oleDbConnection1;
  162. this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("电话", System.Data.OleDb.OleDbType.VarWChar, 50, "电话"));
  163. this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("电子邮件", System.Data.OleDb.OleDbType.VarWChar, 50, "电子邮件"));
  164. 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));
  165. this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("姓名", System.Data.OleDb.OleDbType.VarWChar, 50, "姓名"));
  166. // 
  167. // oleDbSelectCommand1
  168. // 
  169. this.oleDbSelectCommand1.CommandText = "SELECT 电话, 电子邮件, 年龄, 姓名 FROM information";
  170. this.oleDbSelectCommand1.Connection = this.oleDbConnection1;
  171. // 
  172. // oleDbUpdateCommand1
  173. // 
  174. this.oleDbUpdateCommand1.CommandText = "UPDATE information SET 电话 = ?, 电子邮件 = ?, 年龄 = ?, 姓名 = ? WHERE (姓名 = ?) AND (电子邮件 " +
  175. "= ? OR ? IS NULL AND 电子邮件 IS NULL) AND (电话 = ? OR ? IS NULL AND 电话 IS NULL)";
  176. this.oleDbUpdateCommand1.Connection = this.oleDbConnection1;
  177. this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("电话", System.Data.OleDb.OleDbType.VarWChar, 50, "电话"));
  178. this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("电子邮件", System.Data.OleDb.OleDbType.VarWChar, 50, "电子邮件"));
  179. 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));
  180. this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("姓名", System.Data.OleDb.OleDbType.VarWChar, 50, "姓名"));
  181. 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));
  182. 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));
  183. 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));
  184. 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));
  185. 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));
  186. // 
  187. // textBox1
  188. // 
  189. this.textBox1.Location = new System.Drawing.Point(104, 32);
  190. this.textBox1.Name = "textBox1";
  191. this.textBox1.Size = new System.Drawing.Size(160, 21);
  192. this.textBox1.TabIndex = 0;
  193. this.textBox1.Text = "";
  194. // 
  195. // textBox2
  196. // 
  197. this.textBox2.Location = new System.Drawing.Point(104, 64);
  198. this.textBox2.Name = "textBox2";
  199. this.textBox2.Size = new System.Drawing.Size(160, 21);
  200. this.textBox2.TabIndex = 1;
  201. this.textBox2.Text = "";
  202. // 
  203. // textBox3
  204. // 
  205. this.textBox3.Location = new System.Drawing.Point(104, 96);
  206. this.textBox3.Name = "textBox3";
  207. this.textBox3.Size = new System.Drawing.Size(160, 21);
  208. this.textBox3.TabIndex = 2;
  209. this.textBox3.Text = "";
  210. // 
  211. // textBox4
  212. // 
  213. this.textBox4.Location = new System.Drawing.Point(104, 128);
  214. this.textBox4.Name = "textBox4";
  215. this.textBox4.Size = new System.Drawing.Size(160, 21);
  216. this.textBox4.TabIndex = 3;
  217. this.textBox4.Text = "";
  218. // 
  219. // label1
  220. // 
  221. this.label1.Location = new System.Drawing.Point(24, 32);
  222. this.label1.Name = "label1";
  223. this.label1.Size = new System.Drawing.Size(56, 16);
  224. this.label1.TabIndex = 4;
  225. this.label1.Text = "姓名";
  226. // 
  227. // label2
  228. // 
  229. this.label2.Location = new System.Drawing.Point(24, 64);
  230. this.label2.Name = "label2";
  231. this.label2.Size = new System.Drawing.Size(72, 16);
  232. this.label2.TabIndex = 5;
  233. this.label2.Text = "年龄";
  234. // 
  235. // label3
  236. // 
  237. this.label3.Location = new System.Drawing.Point(24, 96);
  238. this.label3.Name = "label3";
  239. this.label3.Size = new System.Drawing.Size(72, 16);
  240. this.label3.TabIndex = 6;
  241. this.label3.Text = "电话";
  242. // 
  243. // label4
  244. // 
  245. this.label4.Location = new System.Drawing.Point(24, 128);
  246. this.label4.Name = "label4";
  247. this.label4.Size = new System.Drawing.Size(72, 16);
  248. this.label4.TabIndex = 7;
  249. this.label4.Text = "电子邮件";
  250. // 
  251. // groupBox1
  252. // 
  253. this.groupBox1.Controls.AddRange(new System.Windows.Forms.Control[] {
  254. this.textBox2,
  255. this.textBox1,
  256. this.textBox3,
  257. this.textBox4,
  258. this.label1,
  259. this.label2,
  260. this.label3,
  261. this.label4});
  262. this.groupBox1.Location = new System.Drawing.Point(16, 8);
  263. this.groupBox1.Name = "groupBox1";
  264. this.groupBox1.Size = new System.Drawing.Size(280, 176);
  265. this.groupBox1.TabIndex = 8;
  266. this.groupBox1.TabStop = false;
  267. this.groupBox1.Text = "我的朋友";
  268. // 
  269. // button1
  270. // 
  271. this.button1.Location = new System.Drawing.Point(40, 200);
  272. this.button1.Name = "button1";
  273. this.button1.Size = new System.Drawing.Size(64, 23);
  274. this.button1.TabIndex = 9;
  275. this.button1.Text = "最前";
  276. this.button1.Click += new System.EventHandler(this.button1_Click);
  277. // 
  278. // button2
  279. // 
  280. this.button2.Location = new System.Drawing.Point(104, 200);
  281. this.button2.Name = "button2";
  282. this.button2.Size = new System.Drawing.Size(64, 23);
  283. this.button2.TabIndex = 10;
  284. this.button2.Text = "前一个";
  285. this.button2.Click += new System.EventHandler(this.button2_Click);
  286. // 
  287. // button3
  288. // 
  289. this.button3.Location = new System.Drawing.Point(168, 200);
  290. this.button3.Name = "button3";
  291. this.button3.Size = new System.Drawing.Size(64, 23);
  292. this.button3.TabIndex = 11;
  293. this.button3.Text = "后一个";
  294. this.button3.Click += new System.EventHandler(this.button3_Click);
  295. // 
  296. // button4
  297. // 
  298. this.button4.Location = new System.Drawing.Point(232, 200);
  299. this.button4.Name = "button4";
  300. this.button4.Size = new System.Drawing.Size(64, 23);
  301. this.button4.TabIndex = 12;
  302. this.button4.Text = "最后";
  303. this.button4.Click += new System.EventHandler(this.button4_Click);
  304. // 
  305. // button5
  306. // 
  307. this.button5.Location = new System.Drawing.Point(168, 248);
  308. this.button5.Name = "button5";
  309. this.button5.Size = new System.Drawing.Size(64, 23);
  310. this.button5.TabIndex = 13;
  311. this.button5.Text = "添加记录";
  312. this.button5.Click += new System.EventHandler(this.button5_Click);
  313. // 
  314. // button6
  315. // 
  316. this.button6.Location = new System.Drawing.Point(232, 248);
  317. this.button6.Name = "button6";
  318. this.button6.Size = new System.Drawing.Size(64, 23);
  319. this.button6.TabIndex = 14;
  320. this.button6.Text = "删除记录";
  321. this.button6.Click += new System.EventHandler(this.button6_Click);
  322. // 
  323. // dataSet1
  324. // 
  325. this.dataSet1.DataSetName = "NewDataSet";
  326. this.dataSet1.Locale = new System.Globalization.CultureInfo("zh-CN");
  327. // 
  328. // button7
  329. // 
  330. this.button7.Location = new System.Drawing.Point(40, 248);
  331. this.button7.Name = "button7";
  332. this.button7.Size = new System.Drawing.Size(64, 23);
  333. this.button7.TabIndex = 15;
  334. this.button7.Text = "新建";
  335. this.button7.Click += new System.EventHandler(this.button7_Click);
  336. // 
  337. // button8
  338. // 
  339. this.button8.Location = new System.Drawing.Point(104, 248);
  340. this.button8.Name = "button8";
  341. this.button8.Size = new System.Drawing.Size(64, 23);
  342. this.button8.TabIndex = 16;
  343. this.button8.Text = "修改";
  344. this.button8.Click += new System.EventHandler(this.button8_Click);
  345. // 
  346. // Form1
  347. // 
  348. this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
  349. this.ClientSize = new System.Drawing.Size(312, 301);
  350. this.Controls.AddRange(new System.Windows.Forms.Control[] {
  351.   this.button8,
  352.   this.button7,
  353.   this.button6,
  354.   this.button5,
  355.   this.button4,
  356.   this.button3,
  357.   this.button2,
  358.   this.button1,
  359.   this.groupBox1});
  360. this.Name = "Form1";
  361. this.Text = "我的通讯录";
  362. this.groupBox1.ResumeLayout(false);
  363. ((System.ComponentModel.ISupportInitialize)(this.dataSet1)).EndInit();
  364. this.ResumeLayout(false);
  366. }
  367. #endregion
  369. /// <summary>
  370. /// 应用程序的主入口点。
  371. /// </summary>
  372. [STAThread]
  373. static void Main() 
  374. {
  375. Application.Run(new Form1());
  376. }
  378. private void button1_Click(object sender, System.EventArgs e)
  379. {
  380. //指向第一条记录
  381. this.myBind.Position=0;
  382. }
  384. private void button2_Click(object sender, System.EventArgs e)
  385. {
  386. //如果不是最前一条记录，则指针向前移动
  387. if (this.myBind.Position==0)
  388. {
  389. MessageBox.Show("没有前一条记录了","警告",MessageBoxButtons.OK,MessageBoxIcon.Information);
  390. }
  391. else
  392. {
  393. this.myBind.Position--;
  394. }
  395. }
  397. private void button3_Click(object sender, System.EventArgs e)
  398. {
  399. //如果不是最后一条记录，则指针向后移动
  400. if (this.myBind.Position==this.myBind.Count-1)
  401. {
  402. MessageBox.Show("没有后一条记录了","警告",MessageBoxButtons.OK,MessageBoxIcon.Information);
  403. }
  404. else
  405. {
  406. this.myBind.Position++;;
  407. }
  408. }
  410. private void button4_Click(object sender, System.EventArgs e)
  411. {
  412. //指向最后一条记录
  413. this.myBind.Position=this.myBind.Count-1;
  414. }
  416. private void button5_Click(object sender, System.EventArgs e)
  417. {
  419. try
  420. {
  421. //首先判断添加的信息是否完整
  422. if (this.textBox1.Text!="" & this.textBox2.Text!="" & this.textBox3.Text!="" & this.textBox4.Text!="")
  423. {
  424. //添加记录时的SQL命令
  425. string insert= " INSERT INTO information( 姓名,年龄 , 电话 ,电子邮件) VALUES ('" ;
  426. insert += this.textBox1.Text + "', '" ;
  427. insert += this.textBox2.Text + "', '" ;
  428. insert += this.textBox3.Text + "','" ;
  429. insert += this.textBox4.Text + "') " ;
  431. //初始化OleDbCommand
  432. OleDbCommand comm=new OleDbCommand();
  433. comm.CommandText=insert;
  434. comm.Connection=this.oleDbConnection1;
  436. //打开数据库连接
  437.                     this.oleDbConnection1.Open();
  438. //执行添加记录的语句
  439. comm.ExecuteNonQuery();
  440.                     //关闭记录
  441. this.oleDbConnection1.Close();
  442. //
  443. // //更新数据集
  444. // this.dataSet1.Tables["information"].Rows[this.myBind.Position].BeginEdit();
  445. // this.dataSet1.Tables["information"].Rows[this.myBind.Position].EndEdit();
  446. // this.dataSet1.AcceptChanges();
  447. //
  448. // //成功提示
  449. // MessageBox.Show("添加记录成功","提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
  450. //                    this.oleDbDataAdapter1.Fill(this.dataSet1,"information");
  451. }
  452. else
  453. {
  454. //错误提示
  455. MessageBox.Show("请将字段信息输入完整","提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
  456. }
  457. }
  458. catch (Exception error)
  459. {
  460. //错误提示 
  461. MessageBox.Show("添加记录发生错误："+error.Message,"提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
  462.              //如果打开了连接，则关闭
  463. if (this.oleDbConnection1.State==ConnectionState.Open)
  464.   {
  465.     this.oleDbConnection1.Close();
  466.   }
  467. }
  468. }
  470. private void button6_Click(object sender, System.EventArgs e)
  471. {
  472. //确认删除记录
  473. if (MessageBox.Show("是否删除记录","提示",MessageBoxButtons.OKCancel,MessageBoxIcon.Information)==DialogResult.OK)
  474. {
  476. try
  477. {
  478.     //删除记录时的SQL语句
  479.     string delete= " DELETE From information WHERE 姓名='" ;
  480. delete += this.textBox1.Text + "'" ;
  482.         //初始化OleDbCommand
  483.     OleDbCommand comm=new OleDbCommand();
  484. comm.CommandText=delete;
  485. comm.Connection=this.oleDbConnection1;
  487.     //打开数据库连接
  488. this.oleDbConnection1.Open();
  489.     //执行删除语句
  490. comm.ExecuteNonQuery();
  491.     //关闭数据库连接
  492. this.oleDbConnection1.Close();
  493.    
  494.     //更新数据集
  495. this.dataSet1.Tables["information"].Rows[this.myBind.Position].Delete();
  496. this.dataSet1.AcceptChanges();
  498.     //成功提示
  499.     MessageBox.Show("删除记录成功","提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
  500.                         this.oleDbDataAdapter1.Fill(this.dataSet1,"information");
  502. }
  503. catch (Exception error)
  504. {
  505. //错误提示
  506. MessageBox.Show("删除记录发生错误："+error.Message,"提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
  507. //如果打开了连接，则关闭
  508. if (this.oleDbConnection1.State==ConnectionState.Open)
  509. {
  510. this.oleDbConnection1.Close();
  511. }
  512. }
  514.   }
  516. }
  518. private void button7_Click(object sender, System.EventArgs e)
  519. {
  520. //请空数据，准备编辑
  521. this.textBox1.Text="";
  522. this.textBox2.Text="";
  523. this.textBox3.Text="";
  524. this.textBox4.Text="";
  526. }
  528. private void button8_Click(object sender, System.EventArgs e)
  529. {
  531. try
  532. {
  533. //首先判断添加的信息是否完整
  534. if (this.textBox1.Text!="" & this.textBox2.Text!="" & this.textBox3.Text!="" & this.textBox4.Text!="")
  535. {
  536. //更新记录的SQL语句
  537. string update= " UPDATE information SET ";
  538. update +=  " 年龄='" ;
  539. update += this.textBox2.Text + "', 电话='" ;
  540. update += this.textBox3.Text + "', 电子邮件='" ;
  541. update += this.textBox4.Text + "' WHERE 姓名='" ;
  542. update += this.textBox1.Text + "'";
  544. //初始化OleDbCommand对象
  545. OleDbCommand comm=new OleDbCommand();
  546. comm.CommandText=update;
  547. comm.Connection=this.oleDbConnection1;
  549. //打开数据库连接
  550. this.oleDbConnection1.Open();
  551. //执行更新语句
  552. comm.ExecuteNonQuery();
  553. //关闭数据库连接
  554. this.oleDbConnection1.Close();
  556. //更新数据集
  557. this.dataSet1.Tables["information"].Rows[this.myBind.Position].BeginEdit();
  558. this.dataSet1.Tables["information"].Rows[this.myBind.Position].EndEdit();
  559. this.dataSet1.AcceptChanges();
  561. //成功提示
  562. MessageBox.Show("修改记录成功","提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
  563. this.oleDbDataAdapter1.Fill(this.dataSet1,"information");
  564. }
  565. else
  566. {
  567. //错误提示
  568. MessageBox.Show("请将字段信息输入完整","提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
  569. }
  570. }
  571. catch (Exception error)
  572. {
  573. //错误提示
  574. MessageBox.Show("修改记录发生错误："+error.Message,"提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
  575. //如果打开了连接，则关闭
  576. if (this.oleDbConnection1.State==ConnectionState.Open)
  577. {
  578. this.oleDbConnection1.Close();
  579. }
  580. }
  582. }
  583. }
  584. }