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

源码开发语言/平台
当前位置：首页 > 源码/资料 > Windows编程 > 查看源码
modizh.cs
资源名称：xqwy.rar　[点击查看]
上传用户：fuyouda
上传日期：2021-03-17
资源大小：8619k
文件大小：20k
源码类别：

Windows编程

开发平台：

C/C++

modizh.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;
  7. using System.Data.OleDb;
  9. namespace WindowsApplication1
  10. {
  11. /// <summary>
  12. /// modizh 的摘要说明。
  13. /// </summary>
  14. public class modizh : System.Windows.Forms.Form
  15. {
  16. private System.Windows.Forms.Button button11;
  17. private System.Windows.Forms.Button button12;
  18. private System.Windows.Forms.Button button13;
  19. private System.Windows.Forms.Button button14;
  20. private System.Windows.Forms.Button button15;
  21. private System.Windows.Forms.Button button16;
  22. private System.Windows.Forms.Button button17;
  23. private System.Windows.Forms.Button button18;
  24. private System.Windows.Forms.Button button19;
  25. private BindingManagerBase MyBind;
  26. private System.Windows.Forms.GroupBox groupBox1;
  27. private System.Windows.Forms.TextBox textBox6;
  28. private System.Windows.Forms.TextBox textBox5;
  29. private System.Windows.Forms.TextBox textBox4;
  30. private System.Windows.Forms.TextBox textBox3;
  31. private System.Windows.Forms.TextBox textBox2;
  32. private System.Windows.Forms.TextBox textBox1;
  33. private System.Windows.Forms.Label label6;
  34. private System.Windows.Forms.Label label5;
  35. private System.Windows.Forms.Label label4;
  36. private System.Windows.Forms.Label label3;
  37. private System.Windows.Forms.Label label2;
  38. private System.Windows.Forms.Label label1;
  39. private System.Windows.Forms.TextBox textBox7;
  40. /// <summary>
  41. /// 必需的设计器变量。
  42. /// </summary>
  43. private System.ComponentModel.Container components = null;
  45. public modizh()
  46. {
  47. //
  48. // Windows 窗体设计器支持所必需的
  49. //
  50. InitializeComponent();
  52. //
  53. // TODO: 在 InitializeComponent 调用后添加任何构造函数代码
  54. //
  55. }
  57. /// <summary>
  58. /// 清理所有正在使用的资源。
  59. /// </summary>
  60. protected override void Dispose( bool disposing )
  61. {
  62. if( disposing )
  63. {
  64. if(components != null)
  65. {
  66. components.Dispose();
  67. }
  68. }
  69. base.Dispose( disposing );
  70. }
  72. #region Windows 窗体设计器生成的代码
  73. /// <summary>
  74. /// 设计器支持所需的方法 - 不要使用代码编辑器修改
  75. /// 此方法的内容。
  76. /// </summary>
  77. private void InitializeComponent()
  78. {
  79. System.Resources.ResourceManager resources = new System.Resources.ResourceManager(typeof(modizh));
  80. this.button11 = new System.Windows.Forms.Button();
  81. this.button12 = new System.Windows.Forms.Button();
  82. this.button13 = new System.Windows.Forms.Button();
  83. this.button14 = new System.Windows.Forms.Button();
  84. this.button15 = new System.Windows.Forms.Button();
  85. this.button16 = new System.Windows.Forms.Button();
  86. this.button17 = new System.Windows.Forms.Button();
  87. this.button18 = new System.Windows.Forms.Button();
  88. this.button19 = new System.Windows.Forms.Button();
  89. this.groupBox1 = new System.Windows.Forms.GroupBox();
  90. this.textBox6 = new System.Windows.Forms.TextBox();
  91. this.textBox5 = new System.Windows.Forms.TextBox();
  92. this.textBox4 = new System.Windows.Forms.TextBox();
  93. this.textBox3 = new System.Windows.Forms.TextBox();
  94. this.textBox2 = new System.Windows.Forms.TextBox();
  95. this.textBox1 = new System.Windows.Forms.TextBox();
  96. this.label6 = new System.Windows.Forms.Label();
  97. this.label5 = new System.Windows.Forms.Label();
  98. this.label4 = new System.Windows.Forms.Label();
  99. this.label3 = new System.Windows.Forms.Label();
  100. this.label2 = new System.Windows.Forms.Label();
  101. this.label1 = new System.Windows.Forms.Label();
  102. this.textBox7 = new System.Windows.Forms.TextBox();
  103. this.groupBox1.SuspendLayout();
  104. this.SuspendLayout();
  105. // 
  106. // button11
  107. // 
  108. this.button11.BackColor = System.Drawing.Color.Transparent;
  109. this.button11.Location = new System.Drawing.Point(416, 224);
  110. this.button11.Name = "button11";
  111. this.button11.Size = new System.Drawing.Size(75, 30);
  112. this.button11.TabIndex = 30;
  113. this.button11.Text = "关闭程序";
  114. this.button11.Click += new System.EventHandler(this.button11_Click);
  115. // 
  116. // button12
  117. // 
  118. this.button12.BackColor = System.Drawing.Color.Transparent;
  119. this.button12.Location = new System.Drawing.Point(232, 264);
  120. this.button12.Name = "button12";
  121. this.button12.Size = new System.Drawing.Size(75, 30);
  122. this.button12.TabIndex = 29;
  123. this.button12.Text = "修改记录";
  124. this.button12.Click += new System.EventHandler(this.button12_Click);
  125. // 
  126. // button13
  127. // 
  128. this.button13.BackColor = System.Drawing.Color.Transparent;
  129. this.button13.Location = new System.Drawing.Point(128, 264);
  130. this.button13.Name = "button13";
  131. this.button13.Size = new System.Drawing.Size(75, 30);
  132. this.button13.TabIndex = 28;
  133. this.button13.Text = "增加记录";
  134. this.button13.Click += new System.EventHandler(this.button13_Click);
  135. // 
  136. // button14
  137. // 
  138. this.button14.BackColor = System.Drawing.Color.Transparent;
  139. this.button14.Location = new System.Drawing.Point(32, 264);
  140. this.button14.Name = "button14";
  141. this.button14.Size = new System.Drawing.Size(75, 30);
  142. this.button14.TabIndex = 27;
  143. this.button14.Text = "新建记录";
  144. this.button14.Click += new System.EventHandler(this.button14_Click);
  145. // 
  146. // button15
  147. // 
  148. this.button15.BackColor = System.Drawing.Color.Transparent;
  149. this.button15.Location = new System.Drawing.Point(328, 224);
  150. this.button15.Name = "button15";
  151. this.button15.Size = new System.Drawing.Size(75, 30);
  152. this.button15.TabIndex = 26;
  153. this.button15.Text = "末一条记录";
  154. this.button15.Click += new System.EventHandler(this.button15_Click);
  155. // 
  156. // button16
  157. // 
  158. this.button16.BackColor = System.Drawing.Color.Transparent;
  159. this.button16.Location = new System.Drawing.Point(224, 224);
  160. this.button16.Name = "button16";
  161. this.button16.Size = new System.Drawing.Size(75, 30);
  162. this.button16.TabIndex = 25;
  163. this.button16.Text = "后一条记录";
  164. this.button16.Click += new System.EventHandler(this.button16_Click);
  165. // 
  166. // button17
  167. // 
  168. this.button17.BackColor = System.Drawing.Color.Transparent;
  169. this.button17.Location = new System.Drawing.Point(128, 224);
  170. this.button17.Name = "button17";
  171. this.button17.Size = new System.Drawing.Size(75, 30);
  172. this.button17.TabIndex = 23;
  173. this.button17.Text = "前一条记录";
  174. this.button17.Click += new System.EventHandler(this.button17_Click);
  175. // 
  176. // button18
  177. // 
  178. this.button18.BackColor = System.Drawing.Color.Transparent;
  179. this.button18.Location = new System.Drawing.Point(32, 224);
  180. this.button18.Name = "button18";
  181. this.button18.Size = new System.Drawing.Size(75, 30);
  182. this.button18.TabIndex = 22;
  183. this.button18.Text = "第一条记录";
  184. this.button18.Click += new System.EventHandler(this.button18_Click);
  185. // 
  186. // button19
  187. // 
  188. this.button19.BackColor = System.Drawing.Color.Transparent;
  189. this.button19.Location = new System.Drawing.Point(328, 264);
  190. this.button19.Name = "button19";
  191. this.button19.Size = new System.Drawing.Size(75, 30);
  192. this.button19.TabIndex = 24;
  193. this.button19.Text = "删除记录";
  194. this.button19.Click += new System.EventHandler(this.button19_Click);
  195. // 
  196. // groupBox1
  197. // 
  198. this.groupBox1.BackgroundImage = ((System.Drawing.Image)(resources.GetObject("groupBox1.BackgroundImage")));
  199. this.groupBox1.Controls.Add(this.textBox6);
  200. this.groupBox1.Controls.Add(this.textBox5);
  201. this.groupBox1.Controls.Add(this.textBox4);
  202. this.groupBox1.Controls.Add(this.textBox3);
  203. this.groupBox1.Controls.Add(this.textBox2);
  204. this.groupBox1.Controls.Add(this.textBox1);
  205. this.groupBox1.Controls.Add(this.label6);
  206. this.groupBox1.Controls.Add(this.label5);
  207. this.groupBox1.Controls.Add(this.label4);
  208. this.groupBox1.Controls.Add(this.label3);
  209. this.groupBox1.Controls.Add(this.label2);
  210. this.groupBox1.Controls.Add(this.label1);
  211. this.groupBox1.Controls.Add(this.textBox7);
  212. this.groupBox1.Location = new System.Drawing.Point(24, 32);
  213. this.groupBox1.Name = "groupBox1";
  214. this.groupBox1.Size = new System.Drawing.Size(456, 176);
  215. this.groupBox1.TabIndex = 31;
  216. this.groupBox1.TabStop = false;
  217. this.groupBox1.Enter += new System.EventHandler(this.groupBox1_Enter);
  218. // 
  219. // textBox6
  220. // 
  221. this.textBox6.Location = new System.Drawing.Point(320, 136);
  222. this.textBox6.Name = "textBox6";
  223. this.textBox6.Size = new System.Drawing.Size(128, 21);
  224. this.textBox6.TabIndex = 23;
  225. this.textBox6.Text = "";
  226. this.textBox6.TextChanged += new System.EventHandler(this.textBox6_TextChanged);
  227. // 
  228. // textBox5
  229. // 
  230. this.textBox5.Location = new System.Drawing.Point(320, 80);
  231. this.textBox5.Name = "textBox5";
  232. this.textBox5.Size = new System.Drawing.Size(128, 21);
  233. this.textBox5.TabIndex = 22;
  234. this.textBox5.Text = "";
  235. this.textBox5.TextChanged += new System.EventHandler(this.textBox5_TextChanged);
  236. // 
  237. // textBox4
  238. // 
  239. this.textBox4.Location = new System.Drawing.Point(320, 32);
  240. this.textBox4.Name = "textBox4";
  241. this.textBox4.Size = new System.Drawing.Size(128, 21);
  242. this.textBox4.TabIndex = 21;
  243. this.textBox4.Text = "";
  244. this.textBox4.TextChanged += new System.EventHandler(this.textBox4_TextChanged);
  245. // 
  246. // textBox3
  247. // 
  248. this.textBox3.Location = new System.Drawing.Point(88, 136);
  249. this.textBox3.Name = "textBox3";
  250. this.textBox3.Size = new System.Drawing.Size(128, 21);
  251. this.textBox3.TabIndex = 20;
  252. this.textBox3.Text = "";
  253. // 
  254. // textBox2
  255. // 
  256. this.textBox2.Location = new System.Drawing.Point(88, 80);
  257. this.textBox2.Name = "textBox2";
  258. this.textBox2.Size = new System.Drawing.Size(128, 21);
  259. this.textBox2.TabIndex = 19;
  260. this.textBox2.Text = "";
  261. this.textBox2.TextChanged += new System.EventHandler(this.textBox2_TextChanged);
  262. // 
  263. // textBox1
  264. // 
  265. this.textBox1.Location = new System.Drawing.Point(88, 32);
  266. this.textBox1.Name = "textBox1";
  267. this.textBox1.Size = new System.Drawing.Size(128, 21);
  268. this.textBox1.TabIndex = 18;
  269. this.textBox1.Text = "";
  270. this.textBox1.TextChanged += new System.EventHandler(this.textBox1_TextChanged);
  271. // 
  272. // label6
  273. // 
  274. this.label6.BackColor = System.Drawing.Color.Transparent;
  275. this.label6.Location = new System.Drawing.Point(256, 144);
  276. this.label6.Name = "label6";
  277. this.label6.Size = new System.Drawing.Size(56, 16);
  278. this.label6.TabIndex = 17;
  279. this.label6.Text = "备  注：";
  280. // 
  281. // label5
  282. // 
  283. this.label5.BackColor = System.Drawing.Color.Transparent;
  284. this.label5.Location = new System.Drawing.Point(264, 85);
  285. this.label5.Name = "label5";
  286. this.label5.Size = new System.Drawing.Size(56, 16);
  287. this.label5.TabIndex = 16;
  288. this.label5.Text = "电  话：";
  289. this.label5.Click += new System.EventHandler(this.label5_Click);
  290. // 
  291. // label4
  292. // 
  293. this.label4.BackColor = System.Drawing.Color.Transparent;
  294. this.label4.Location = new System.Drawing.Point(256, 37);
  295. this.label4.Name = "label4";
  296. this.label4.Size = new System.Drawing.Size(72, 16);
  297. this.label4.TabIndex = 15;
  298. this.label4.Text = "常住人口：";
  299. this.label4.Click += new System.EventHandler(this.label4_Click);
  300. // 
  301. // label3
  302. // 
  303. this.label3.BackColor = System.Drawing.Color.Transparent;
  304. this.label3.Location = new System.Drawing.Point(32, 141);
  305. this.label3.Name = "label3";
  306. this.label3.Size = new System.Drawing.Size(56, 16);
  307. this.label3.TabIndex = 14;
  308. this.label3.Text = "户  型：";
  309. this.label3.Click += new System.EventHandler(this.label3_Click);
  310. // 
  311. // label2
  312. // 
  313. this.label2.BackColor = System.Drawing.Color.Transparent;
  314. this.label2.Location = new System.Drawing.Point(32, 86);
  315. this.label2.Name = "label2";
  316. this.label2.Size = new System.Drawing.Size(56, 16);
  317. this.label2.TabIndex = 13;
  318. this.label2.Text = "户  主：";
  319. this.label2.Click += new System.EventHandler(this.label2_Click);
  320. // 
  321. // label1
  322. // 
  323. this.label1.BackColor = System.Drawing.Color.Transparent;
  324. this.label1.Location = new System.Drawing.Point(32, 38);
  325. this.label1.Name = "label1";
  326. this.label1.Size = new System.Drawing.Size(56, 18);
  327. this.label1.TabIndex = 12;
  328. this.label1.Text = "门牌号：";
  329. this.label1.Click += new System.EventHandler(this.label1_Click);
  330. // 
  331. // textBox7
  332. // 
  333. this.textBox7.Location = new System.Drawing.Point(88, 136);
  334. this.textBox7.Name = "textBox7";
  335. this.textBox7.Size = new System.Drawing.Size(128, 21);
  336. this.textBox7.TabIndex = 20;
  337. this.textBox7.Text = "textBox3";
  338. this.textBox7.TextChanged += new System.EventHandler(this.textBox7_TextChanged);
  339. // 
  340. // modizh
  341. // 
  342. this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
  343. this.BackgroundImage = ((System.Drawing.Image)(resources.GetObject("$this.BackgroundImage")));
  344. this.ClientSize = new System.Drawing.Size(528, 312);
  345. this.Controls.Add(this.groupBox1);
  346. this.Controls.Add(this.button11);
  347. this.Controls.Add(this.button12);
  348. this.Controls.Add(this.button13);
  349. this.Controls.Add(this.button14);
  350. this.Controls.Add(this.button15);
  351. this.Controls.Add(this.button16);
  352. this.Controls.Add(this.button17);
  353. this.Controls.Add(this.button18);
  354. this.Controls.Add(this.button19);
  355. this.Name = "modizh";
  356. this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
  357. this.Text = "modizh";
  358. this.Load += new System.EventHandler(this.modizh_Load);
  359. this.groupBox1.ResumeLayout(false);
  360. this.ResumeLayout(false);
  362. }
  363. #endregion
  365. private void modizh_Load(object sender, System.EventArgs e)
  366. {
  367. string connstr,selectcmd;
  368. connstr="Provider=Microsoft.jet.oledb.4.0;data source="+Application.StartupPath+"\xqwy.mdb";
  369. selectcmd="select * from zhb";
  370. OleDbConnection conn=new OleDbConnection(connstr);
  371. conn.Open();
  372. OleDbDataAdapter da=new OleDbDataAdapter(selectcmd,conn);
  373. //OleDbDataAdapter oleDbDataAdapter1=new OleDbDataAdapter(selectcmd,conn);
  374. DataSet ds=new DataSet();
  376. //DataSet dataSet1=new DataSet();
  377. da.Fill(ds);
  379. DataTable mytable=new DataTable();
  380. mytable=ds.Tables[0];
  382. MyBind=this.groupBox1.BindingContext[mytable];
  384. //oleDbDataAdapter1.Fill(dataSet1);
  385. //this.dataGrid1.DataSource=mytable;
  386. //conn.Close();
  387. try
  388. {
  390. //this.oleDbDataAdapter1.Fill(this.dataSet1,"user1");
  391. this.textBox1.DataBindings.Add("Text",mytable,"Mph");
  392. this.textBox2.DataBindings.Add("Text",mytable,"Hz");
  393. this.textBox3.DataBindings.Add("Text",mytable,"Hx");
  394. this.textBox4.DataBindings.Add("Text",mytable,"Czr");
  395. this.textBox5.DataBindings.Add("Text",mytable,"Dh");
  396. this.textBox6.DataBindings.Add("Text",mytable,"Bz");
  397. }
  398. catch(Exception Err)
  399. {
  400. MessageBox.Show("打开数据库表错误："+Err.Message,"信息提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
  401. return;
  402. }
  403. }
  405. private void button18_Click(object sender, System.EventArgs e)
  406. {
  407. this.MyBind.Position=0;
  408. }
  410. private void button17_Click(object sender, System.EventArgs e)
  411. {
  412. this.MyBind.Position--;
  413. }
  415. private void button16_Click(object sender, System.EventArgs e)
  416. {
  417. this.MyBind.Position++;
  418. }
  420. private void button15_Click(object sender, System.EventArgs e)
  421. {
  422. try
  423. {
  424. this.MyBind.Position=this.MyBind.Count-1;
  425. }
  426. catch(Exception Err)
  427. {
  428. MessageBox.Show("打开数据库表错误："+Err.Message,"信息提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
  429. return;
  430. }
  431. }
  433. private void button13_Click(object sender, System.EventArgs e)
  434. {
  435. //增加记录
  436. if(this.textBox2.Text.Length<1|this.textBox3.Text.Length<1)
  437. {
  438. MessageBox.Show("客户所有信息必须填写！","信息提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
  439. return;
  440. }
  441. try
  442. {
  443. string connstr="Provider=Microsoft.jet.oledb.4.0;data source="+Application.StartupPath+"\xqwy.mdb";
  444. OleDbConnection conn=new OleDbConnection(connstr);
  445. conn.Open();
  446. string StrSQL="INSERT INTO zhb (Mph,Hz,Hx,Czr,Dh,Bz)VALUES('"+this.textBox1.Text.Trim()+"','"+this.textBox2.Text.Trim()+"','"+this.textBox3.Text.Trim()+"','"+this.textBox4.Text.Trim()+"','"+this.textBox5.Text.Trim()+"','"+this.textBox6.Text.Trim()+"')";
  448. OleDbCommand cmd=new OleDbCommand(StrSQL,conn);
  449. cmd.ExecuteNonQuery();
  452. MessageBox.Show("增加数据集记录操作成功！","信息提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
  453. }
  454. catch(Exception Err)
  455. {
  456. MessageBox.Show("增加数据集记录操作失败："+Err.Message,"信息提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
  458. }
  459. }
  461. private void button19_Click(object sender, System.EventArgs e)
  462. {
  463. try
  464. {
  465. string connstr="Provider=Microsoft.jet.oledb.4.0;data source="+Application.StartupPath+"\xqwy.mdb";
  466. OleDbConnection conn=new OleDbConnection(connstr);
  467. conn.Open();
  468. string StrSQL="DELETE FROM  zhb WHERE ";
  469. StrSQL+=" Mph='"+this.textBox1.Text+"'";
  470. OleDbCommand cmd=new OleDbCommand(StrSQL,conn);
  471. cmd.ExecuteNonQuery();
  475. MessageBox.Show("删除数据集记录操作成功！","信息提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
  476. }
  477. catch(Exception Err)
  478. {
  479. MessageBox.Show("删除数据集记录操作失败："+Err.Message,"信息提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
  481. }
  482. }
  484. private void button14_Click(object sender, System.EventArgs e)
  485. {
  486. this.textBox1.Text="";
  487. this.textBox2.Text="";
  488. this.textBox3.Text="";
  489. this.textBox4.Text="";
  490. this.textBox5.Text="";
  491. this.textBox6.Text="";
  492. }
  494. private void button12_Click(object sender, System.EventArgs e)
  495. {
  496. //修改记录
  497. try
  498. {
  500. OleDbConnection conn2=new OleDbConnection(@"provider=Microsoft.jet.oledb.4.0;data source="+Application.StartupPath+ "\xqwy.mdb");
  501. conn2.Open();
  503. string strsql="select * from zhb where Mph='"+this.textBox1.Text.Trim()+"' ";
  505. OleDbDataAdapter da=new OleDbDataAdapter(strsql,conn2);
  507. DataSet ds=new DataSet();
  508. da.Fill(ds);
  510. DataTable mytable=new DataTable();
  511. mytable=ds.Tables[0];
  514. DataRow row1;
  515. row1=mytable.Rows[0];
  516. row1[0]=this.textBox1.Text.Trim();
  517. row1[1]=this.textBox2.Text.Trim();
  518. row1[2]=this.textBox3.Text.Trim();
  519. row1[3]=this.textBox4.Text.Trim();
  520. row1[4]=this.textBox5.Text.Trim();
  521. row1[5]=this.textBox6.Text.Trim();
  523. OleDbCommandBuilder cmdbld=new OleDbCommandBuilder(da);
  525. da.Update(mytable);
  526. MessageBox.Show("记录修改成功！");
  529. conn2.Close();
  530. }
  531. catch(Exception err)
  532. {
  533. MessageBox.Show(err.Message);
  534. }
  535. }
  537. private void button11_Click(object sender, System.EventArgs e)
  538. {
  539. this.Close();
  540. }
  542. private void label8_Click(object sender, System.EventArgs e)
  543. {
  545. }
  547. private void label7_Click(object sender, System.EventArgs e)
  548. {
  550. }
  552. private void textBox7_TextChanged(object sender, System.EventArgs e)
  553. {
  555. }
  557. private void textBox4_TextChanged(object sender, System.EventArgs e)
  558. {
  560. }
  562. private void textBox2_TextChanged(object sender, System.EventArgs e)
  563. {
  565. }
  567. private void textBox1_TextChanged(object sender, System.EventArgs e)
  568. {
  570. }
  572. private void label5_Click(object sender, System.EventArgs e)
  573. {
  575. }
  577. private void label4_Click(object sender, System.EventArgs e)
  578. {
  580. }
  582. private void label2_Click(object sender, System.EventArgs e)
  583. {
  585. }
  587. private void label1_Click(object sender, System.EventArgs e)
  588. {
  590. }
  592. private void groupBox1_Enter(object sender, System.EventArgs e)
  593. {
  595. }
  597. private void textBox6_TextChanged(object sender, System.EventArgs e)
  598. {
  600. }
  602. private void textBox5_TextChanged(object sender, System.EventArgs e)
  603. {
  605. }
  607. private void label3_Click(object sender, System.EventArgs e)
  608. {
  610. }
  611. }
  612. }