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

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

Windows编程

开发平台：

C/C++

userg1.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;
  10. namespace WindowsApplication1
  11. {
  12. /// <summary>
  13. /// userg1 的摘要说明。
  14. /// </summary>
  15. public class userg1 : System.Windows.Forms.Form
  16. {
  17. private System.Windows.Forms.TabControl tabControl1;
  18. private System.Windows.Forms.TabPage tabPage1;
  19. private System.Windows.Forms.TabPage tabPage2;
  20. private System.Windows.Forms.Panel panel1;
  21. private System.Windows.Forms.Label label2;
  22. private System.Windows.Forms.Label label3;
  23. private System.Windows.Forms.TextBox textBox2;
  24. private System.Windows.Forms.TextBox textBox3;
  25. private System.Windows.Forms.DataGrid dataGrid1;
  26. private System.Windows.Forms.Button button11;
  27. private System.Windows.Forms.Button button12;
  28. private System.Windows.Forms.Button button13;
  29. private System.Windows.Forms.Button button14;
  30. private System.Windows.Forms.Button button15;
  31. private System.Windows.Forms.Button button16;
  32. private System.Windows.Forms.Button button17;
  33. private System.Windows.Forms.Button button18;
  34. private System.Windows.Forms.Button button19;
  35. private System.Windows.Forms.Button button1;
  36. private System.Windows.Forms.Button button5;
  37. private System.Windows.Forms.Button button6;
  38. private System.Windows.Forms.Button button7;
  39. private System.Windows.Forms.Button button8;
  40. //private System.Data.OleDb.OleDbDataAdapter oleDbDataAdapter1;
  41. //private System.Data.DataSet dataSet1;
  42. private BindingManagerBase MyBind;
  43. private System.Windows.Forms.Label label1;
  45. /// <summary>
  46. /// 必需的设计器变量。
  47. /// </summary>
  48. private System.ComponentModel.Container components = null;
  50. public userg1()
  51. {
  52. //
  53. // Windows 窗体设计器支持所必需的
  54. //
  55. InitializeComponent();
  57. //
  58. // TODO: 在 InitializeComponent 调用后添加任何构造函数代码
  59. //
  60. }
  62. /// <summary>
  63. /// 清理所有正在使用的资源。
  64. /// </summary>
  65. protected override void Dispose( bool disposing )
  66. {
  67. if( disposing )
  68. {
  69. if(components != null)
  70. {
  71. components.Dispose();
  72. }
  73. }
  74. base.Dispose( disposing );
  75. }
  77. #region Windows 窗体设计器生成的代码
  78. /// <summary>
  79. /// 设计器支持所需的方法 - 不要使用代码编辑器修改
  80. /// 此方法的内容。
  81. /// </summary>
  82. private void InitializeComponent()
  83. {
  84. System.Resources.ResourceManager resources = new System.Resources.ResourceManager(typeof(userg1));
  85. this.tabControl1 = new System.Windows.Forms.TabControl();
  86. this.tabPage1 = new System.Windows.Forms.TabPage();
  87. this.dataGrid1 = new System.Windows.Forms.DataGrid();
  88. this.panel1 = new System.Windows.Forms.Panel();
  89. this.button1 = new System.Windows.Forms.Button();
  90. this.button5 = new System.Windows.Forms.Button();
  91. this.button6 = new System.Windows.Forms.Button();
  92. this.button7 = new System.Windows.Forms.Button();
  93. this.button8 = new System.Windows.Forms.Button();
  94. this.tabPage2 = new System.Windows.Forms.TabPage();
  95. this.button11 = new System.Windows.Forms.Button();
  96. this.button12 = new System.Windows.Forms.Button();
  97. this.button13 = new System.Windows.Forms.Button();
  98. this.button14 = new System.Windows.Forms.Button();
  99. this.button15 = new System.Windows.Forms.Button();
  100. this.button16 = new System.Windows.Forms.Button();
  101. this.button17 = new System.Windows.Forms.Button();
  102. this.button18 = new System.Windows.Forms.Button();
  103. this.button19 = new System.Windows.Forms.Button();
  104. this.textBox3 = new System.Windows.Forms.TextBox();
  105. this.textBox2 = new System.Windows.Forms.TextBox();
  106. this.label3 = new System.Windows.Forms.Label();
  107. this.label2 = new System.Windows.Forms.Label();
  108. this.label1 = new System.Windows.Forms.Label();
  109. this.tabControl1.SuspendLayout();
  110. this.tabPage1.SuspendLayout();
  111. ((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit();
  112. this.panel1.SuspendLayout();
  113. this.tabPage2.SuspendLayout();
  114. this.SuspendLayout();
  115. // 
  116. // tabControl1
  117. // 
  118. this.tabControl1.Controls.Add(this.tabPage1);
  119. this.tabControl1.Controls.Add(this.tabPage2);
  120. this.tabControl1.Location = new System.Drawing.Point(0, 0);
  121. this.tabControl1.Name = "tabControl1";
  122. this.tabControl1.SelectedIndex = 0;
  123. this.tabControl1.Size = new System.Drawing.Size(520, 376);
  124. this.tabControl1.TabIndex = 0;
  125. this.tabControl1.SelectedIndexChanged += new System.EventHandler(this.tabControl1_SelectedIndexChanged);
  126. // 
  127. // tabPage1
  128. // 
  129. this.tabPage1.Controls.Add(this.dataGrid1);
  130. this.tabPage1.Controls.Add(this.panel1);
  131. this.tabPage1.Location = new System.Drawing.Point(4, 21);
  132. this.tabPage1.Name = "tabPage1";
  133. this.tabPage1.Size = new System.Drawing.Size(512, 351);
  134. this.tabPage1.TabIndex = 0;
  135. this.tabPage1.Text = "多行显示";
  136. // 
  137. // dataGrid1
  138. // 
  139. this.dataGrid1.DataMember = "";
  140. this.dataGrid1.HeaderForeColor = System.Drawing.SystemColors.ControlText;
  141. this.dataGrid1.Location = new System.Drawing.Point(8, 0);
  142. this.dataGrid1.Name = "dataGrid1";
  143. this.dataGrid1.Size = new System.Drawing.Size(464, 208);
  144. this.dataGrid1.TabIndex = 1;
  145. // 
  146. // panel1
  147. // 
  148. this.panel1.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D;
  149. this.panel1.Controls.Add(this.button1);
  150. this.panel1.Controls.Add(this.button5);
  151. this.panel1.Controls.Add(this.button6);
  152. this.panel1.Controls.Add(this.button7);
  153. this.panel1.Controls.Add(this.button8);
  154. this.panel1.Location = new System.Drawing.Point(0, 208);
  155. this.panel1.Name = "panel1";
  156. this.panel1.Size = new System.Drawing.Size(472, 72);
  157. this.panel1.TabIndex = 0;
  158. this.panel1.Paint += new System.Windows.Forms.PaintEventHandler(this.panel1_Paint);
  159. // 
  160. // button1
  161. // 
  162. this.button1.BackColor = System.Drawing.Color.Transparent;
  163. this.button1.BackgroundImage = ((System.Drawing.Image)(resources.GetObject("button1.BackgroundImage")));
  164. this.button1.Location = new System.Drawing.Point(360, 8);
  165. this.button1.Name = "button1";
  166. this.button1.TabIndex = 30;
  167. this.button1.Text = "关闭程序";
  168. this.button1.Click += new System.EventHandler(this.button1_Click);
  169. // 
  170. // button5
  171. // 
  172. this.button5.BackgroundImage = ((System.Drawing.Image)(resources.GetObject("button5.BackgroundImage")));
  173. this.button5.Location = new System.Drawing.Point(280, 8);
  174. this.button5.Name = "button5";
  175. this.button5.TabIndex = 26;
  176. this.button5.Text = "末一条记录";
  177. this.button5.Click += new System.EventHandler(this.button5_Click);
  178. // 
  179. // button6
  180. // 
  181. this.button6.BackgroundImage = ((System.Drawing.Image)(resources.GetObject("button6.BackgroundImage")));
  182. this.button6.Location = new System.Drawing.Point(192, 8);
  183. this.button6.Name = "button6";
  184. this.button6.TabIndex = 25;
  185. this.button6.Text = "后一条记录";
  186. this.button6.Click += new System.EventHandler(this.button6_Click);
  187. // 
  188. // button7
  189. // 
  190. this.button7.BackgroundImage = ((System.Drawing.Image)(resources.GetObject("button7.BackgroundImage")));
  191. this.button7.Location = new System.Drawing.Point(104, 8);
  192. this.button7.Name = "button7";
  193. this.button7.TabIndex = 23;
  194. this.button7.Text = "前一条记录";
  195. this.button7.Click += new System.EventHandler(this.button7_Click);
  196. // 
  197. // button8
  198. // 
  199. this.button8.BackgroundImage = ((System.Drawing.Image)(resources.GetObject("button8.BackgroundImage")));
  200. this.button8.Location = new System.Drawing.Point(16, 8);
  201. this.button8.Name = "button8";
  202. this.button8.TabIndex = 22;
  203. this.button8.Text = "第一条记录";
  204. this.button8.Click += new System.EventHandler(this.button8_Click);
  205. // 
  206. // tabPage2
  207. // 
  208. this.tabPage2.BackgroundImage = ((System.Drawing.Image)(resources.GetObject("tabPage2.BackgroundImage")));
  209. this.tabPage2.Controls.Add(this.button11);
  210. this.tabPage2.Controls.Add(this.button12);
  211. this.tabPage2.Controls.Add(this.button13);
  212. this.tabPage2.Controls.Add(this.button14);
  213. this.tabPage2.Controls.Add(this.button15);
  214. this.tabPage2.Controls.Add(this.button16);
  215. this.tabPage2.Controls.Add(this.button17);
  216. this.tabPage2.Controls.Add(this.button18);
  217. this.tabPage2.Controls.Add(this.button19);
  218. this.tabPage2.Controls.Add(this.textBox3);
  219. this.tabPage2.Controls.Add(this.textBox2);
  220. this.tabPage2.Controls.Add(this.label3);
  221. this.tabPage2.Controls.Add(this.label2);
  222. this.tabPage2.Location = new System.Drawing.Point(4, 21);
  223. this.tabPage2.Name = "tabPage2";
  224. this.tabPage2.Size = new System.Drawing.Size(512, 351);
  225. this.tabPage2.TabIndex = 1;
  226. this.tabPage2.Text = "单框显示";
  227. this.tabPage2.Click += new System.EventHandler(this.tabPage2_Click);
  228. // 
  229. // button11
  230. // 
  231. this.button11.BackColor = System.Drawing.Color.Transparent;
  232. this.button11.Location = new System.Drawing.Point(344, 208);
  233. this.button11.Name = "button11";
  234. this.button11.TabIndex = 21;
  235. this.button11.Text = "关闭程序";
  236. this.button11.Click += new System.EventHandler(this.button11_Click);
  237. // 
  238. // button12
  239. // 
  240. this.button12.BackColor = System.Drawing.Color.Transparent;
  241. this.button12.Location = new System.Drawing.Point(168, 208);
  242. this.button12.Name = "button12";
  243. this.button12.TabIndex = 20;
  244. this.button12.Text = "修改记录";
  245. this.button12.Click += new System.EventHandler(this.button12_Click);
  246. // 
  247. // button13
  248. // 
  249. this.button13.BackColor = System.Drawing.Color.Transparent;
  250. this.button13.Location = new System.Drawing.Point(344, 168);
  251. this.button13.Name = "button13";
  252. this.button13.TabIndex = 19;
  253. this.button13.Text = "增加记录";
  254. this.button13.Click += new System.EventHandler(this.button13_Click);
  255. // 
  256. // button14
  257. // 
  258. this.button14.BackColor = System.Drawing.Color.Transparent;
  259. this.button14.Location = new System.Drawing.Point(256, 168);
  260. this.button14.Name = "button14";
  261. this.button14.TabIndex = 18;
  262. this.button14.Text = "新建记录";
  263. this.button14.Click += new System.EventHandler(this.button14_Click);
  264. // 
  265. // button15
  266. // 
  267. this.button15.BackColor = System.Drawing.Color.Transparent;
  268. this.button15.Location = new System.Drawing.Point(168, 168);
  269. this.button15.Name = "button15";
  270. this.button15.TabIndex = 17;
  271. this.button15.Text = "末一条记录";
  272. this.button15.Click += new System.EventHandler(this.button15_Click);
  273. // 
  274. // button16
  275. // 
  276. this.button16.BackColor = System.Drawing.Color.Transparent;
  277. this.button16.Location = new System.Drawing.Point(344, 128);
  278. this.button16.Name = "button16";
  279. this.button16.TabIndex = 16;
  280. this.button16.Text = "后一条记录";
  281. this.button16.Click += new System.EventHandler(this.button16_Click);
  282. // 
  283. // button17
  284. // 
  285. this.button17.BackColor = System.Drawing.Color.Transparent;
  286. this.button17.Location = new System.Drawing.Point(256, 128);
  287. this.button17.Name = "button17";
  288. this.button17.TabIndex = 14;
  289. this.button17.Text = "前一条记录";
  290. this.button17.Click += new System.EventHandler(this.button17_Click);
  291. // 
  292. // button18
  293. // 
  294. this.button18.BackColor = System.Drawing.Color.Transparent;
  295. this.button18.Location = new System.Drawing.Point(168, 128);
  296. this.button18.Name = "button18";
  297. this.button18.TabIndex = 13;
  298. this.button18.Text = "第一条记录";
  299. this.button18.Click += new System.EventHandler(this.button18_Click);
  300. // 
  301. // button19
  302. // 
  303. this.button19.BackColor = System.Drawing.Color.Transparent;
  304. this.button19.Location = new System.Drawing.Point(256, 208);
  305. this.button19.Name = "button19";
  306. this.button19.TabIndex = 15;
  307. this.button19.Text = "删除记录";
  308. this.button19.Click += new System.EventHandler(this.button19_Click);
  309. // 
  310. // textBox3
  311. // 
  312. this.textBox3.Location = new System.Drawing.Point(96, 80);
  313. this.textBox3.Name = "textBox3";
  314. this.textBox3.Size = new System.Drawing.Size(120, 21);
  315. this.textBox3.TabIndex = 6;
  316. this.textBox3.Text = "";
  317. // 
  318. // textBox2
  319. // 
  320. this.textBox2.Location = new System.Drawing.Point(96, 24);
  321. this.textBox2.Name = "textBox2";
  322. this.textBox2.Size = new System.Drawing.Size(120, 21);
  323. this.textBox2.TabIndex = 5;
  324. this.textBox2.Text = "";
  325. // 
  326. // label3
  327. // 
  328. this.label3.BackColor = System.Drawing.Color.Transparent;
  329. this.label3.Location = new System.Drawing.Point(40, 87);
  330. this.label3.Name = "label3";
  331. this.label3.Size = new System.Drawing.Size(56, 16);
  332. this.label3.TabIndex = 2;
  333. this.label3.Text = "密  码：";
  334. // 
  335. // label2
  336. // 
  337. this.label2.BackColor = System.Drawing.Color.Transparent;
  338. this.label2.Location = new System.Drawing.Point(40, 31);
  339. this.label2.Name = "label2";
  340. this.label2.Size = new System.Drawing.Size(56, 16);
  341. this.label2.TabIndex = 1;
  342. this.label2.Text = "用户名：";
  343. // 
  344. // label1
  345. // 
  346. this.label1.Location = new System.Drawing.Point(544, 80);
  347. this.label1.Name = "label1";
  348. this.label1.Size = new System.Drawing.Size(152, 32);
  349. this.label1.TabIndex = 1;
  350. this.label1.Text = "label1";
  351. // 
  352. // userg1
  353. // 
  354. this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
  355. this.ClientSize = new System.Drawing.Size(480, 272);
  356. this.Controls.Add(this.label1);
  357. this.Controls.Add(this.tabControl1);
  358. this.Name = "userg1";
  359. this.Text = "用户管理";
  360. this.Load += new System.EventHandler(this.userg1_Load);
  361. this.tabControl1.ResumeLayout(false);
  362. this.tabPage1.ResumeLayout(false);
  363. ((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
  364. this.panel1.ResumeLayout(false);
  365. this.tabPage2.ResumeLayout(false);
  366. this.ResumeLayout(false);
  368. }
  369. #endregion
  371. private void tabPage2_Click(object sender, System.EventArgs e)
  372. {
  374. }
  376. private void tabControl1_SelectedIndexChanged(object sender, System.EventArgs e)
  377. {
  379. }
  381. private void userg1_Load(object sender, System.EventArgs e)
  382. {
  383. string connstr,selectcmd;
  384. connstr="Provider=Microsoft.jet.oledb.4.0;data source="+Application.StartupPath+"\xqwy.mdb";
  385. selectcmd="select * from user1";
  386. OleDbConnection conn=new OleDbConnection(connstr);
  387. conn.Open();
  388. OleDbDataAdapter da=new OleDbDataAdapter(selectcmd,conn);
  389. //OleDbDataAdapter oleDbDataAdapter1=new OleDbDataAdapter(selectcmd,conn);
  390. DataSet ds=new DataSet();
  392. //DataSet dataSet1=new DataSet();
  393. da.Fill(ds);
  395. DataTable mytable=new DataTable();
  396. mytable=ds.Tables[0];
  398. //oleDbDataAdapter1.Fill(dataSet1);
  399. this.dataGrid1.DataSource=mytable;
  400. //conn.Close();
  401. try
  402. {
  404. //this.oleDbDataAdapter1.Fill(this.dataSet1,"user1");
  405. this.textBox2.DataBindings.Add("Text",mytable,"Name");
  406. this.textBox3.DataBindings.Add("Text",mytable,"Passwd");
  408. this.MyBind=this.dataGrid1.BindingContext[mytable];
  410. this.dataGrid1.Select(0);
  411. }
  412. catch(Exception Err)
  413. {
  414. MessageBox.Show("打开数据库表错误："+Err.Message,"信息提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
  415. return;
  416. }
  417. }
  419. private void button8_Click(object sender, System.EventArgs e)
  420. {
  421. //第一条记录
  422. this.dataGrid1.UnSelect(MyBind.Position);
  423. this.MyBind.Position=0;
  424. this.dataGrid1.Select(MyBind.Position);
  425. }
  427. private void button7_Click(object sender, System.EventArgs e)
  428. {
  429. //前一条记录
  430. if(this.MyBind.Position==0)
  431. {
  432. MessageBox.Show("已经是第一条记录","信息提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
  433. return;
  434. }
  435. else
  436. {
  437. this.dataGrid1.UnSelect(MyBind.Position);
  438. this.MyBind.Position--;
  439. this.dataGrid1.Select(MyBind.Position);
  441. }
  442. }
  444. private void button6_Click(object sender, System.EventArgs e)
  445. {
  446. //后一条记录
  447. if(this.MyBind.Position==this.MyBind.Count-1)
  448. {
  449. MessageBox.Show("已经是末一条记录","信息提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
  450. return;
  451. }
  452. else
  453. {
  454. this.dataGrid1.UnSelect(MyBind.Position);
  455. this.MyBind.Position++;
  456. this.dataGrid1.Select(MyBind.Position);
  457. this.label1.Text=MyBind.Count.ToString();
  459. }
  460. }
  462. private void button5_Click(object sender, System.EventArgs e)
  463. {
  464. //末一条记录
  465. this.dataGrid1.UnSelect(MyBind.Position);
  467. this.MyBind.Position=this.MyBind.Count-1;
  470. this.dataGrid1.Select(this.MyBind.Position);
  471. }
  473. private void button4_Click(object sender, System.EventArgs e)
  474. {
  475. //新建记录
  478. }
  480. private void button18_Click(object sender, System.EventArgs e)
  481. {
  483. this.MyBind.Position=0;
  484. }
  486. private void button17_Click(object sender, System.EventArgs e)
  487. {
  489. this.MyBind.Position--;
  490. }
  492. private void button16_Click(object sender, System.EventArgs e)
  493. {
  494. this.MyBind.Position++;
  495. }
  497. private void button15_Click(object sender, System.EventArgs e)
  498. {
  499. this.MyBind.Position=this.MyBind.Count-1;
  501. }
  503. private void button14_Click(object sender, System.EventArgs e)
  504. {
  505. this.textBox2.Text="";
  506. this.textBox3.Text="";
  507. }
  509. private void button13_Click(object sender, System.EventArgs e)
  510. {
  511. //增加记录
  512. if(this.textBox2.Text.Length<1|this.textBox3.Text.Length<1)
  513. {
  514. MessageBox.Show("客户所有信息必须填写！","信息提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
  515. return;
  516. }
  517. try
  518. {
  519. string connstr="Provider=Microsoft.jet.oledb.4.0;data source="+Application.StartupPath+"\xqwy.mdb";
  520. OleDbConnection conn=new OleDbConnection(connstr);
  521. conn.Open();
  522. string StrSQL="INSERT INTO user1(Name,Passwd)VALUES('"+this.textBox2.Text.Trim()+"','"+this.textBox3.Text.Trim()+"')";
  524. //sring strsql="select * from***"
  526. /*OleDbDataAdapter da1=new OleDbDataAdapter(StrSQL,conn);
  527. DataSet ds1=new DataSet();
  528. da1.Fill(ds1);
  530. DataTable mytable1=new DataTable();
  532. DataRow newrow=myatble.newrow()
  533. newrow[0=
  535. mytable[1,2]
  537. mytable.add(datarow)
  538. mytable1=ds1.Tables[0];
  539. OleDbCommandBuilder cmdbld1=new OleDbCommandBuilder(da1);*/
  541. OleDbCommand cmd=new OleDbCommand(StrSQL,conn);
  542. cmd.ExecuteNonQuery();
  545. //da1.Update(mytable1);
  548. MessageBox.Show("增加数据集记录操作成功！","信息提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
  549. }
  550. catch(Exception Err)
  551. {
  552. MessageBox.Show("增加数据集记录操作失败："+Err.Message,"信息提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
  554. }
  555. }
  557. private void panel1_Paint(object sender, System.Windows.Forms.PaintEventArgs e)
  558. {
  560. }
  562. private void button1_Click(object sender, System.EventArgs e)
  563. {
  564. Application.Exit();
  565. }
  567. private void button11_Click(object sender, System.EventArgs e)
  568. {
  569. Application.Exit();
  570. }
  572. private void button12_Click(object sender, System.EventArgs e)
  573. {
  574. //修改记录
  575. try
  576. {
  578. OleDbConnection conn2=new OleDbConnection(@"provider=Microsoft.jet.oledb.4.0;data source="+Application.StartupPath+ "\xqwy.mdb");
  579. conn2.Open();
  581. string strsql="select * from user1 where name='"+this.textBox2.Text.Trim()+"' ";
  583. OleDbDataAdapter da=new OleDbDataAdapter(strsql,conn2);
  585. DataSet ds=new DataSet();
  586. da.Fill(ds);
  588. DataTable mytable=new DataTable();
  589. mytable=ds.Tables[0];
  592. DataRow row1;
  593. row1=mytable.Rows[0];
  594. row1[0]=this.textBox2.Text.Trim();
  595. row1[1]=this.textBox3.Text.Trim();
  597. OleDbCommandBuilder cmdbld=new OleDbCommandBuilder(da);
  599. da.Update(mytable);
  600. MessageBox.Show("密码修改成功！");
  603. conn2.Close();
  604. }
  605. catch(Exception err)
  606. {
  607. MessageBox.Show(err.Message);
  608. }
  610. }
  612. private void button3_Click(object sender, System.EventArgs e)
  613. {
  615. }
  617. private void button2_Click(object sender, System.EventArgs e)
  618. {
  620. }
  622. private void button19_Click(object sender, System.EventArgs e)
  623. {
  625. try
  626. {
  627. string connstr="Provider=Microsoft.jet.oledb.4.0;data source="+Application.StartupPath+"\xqwy.mdb";
  628. OleDbConnection conn=new OleDbConnection(connstr);
  629. conn.Open();
  630. string StrSQL="DELETE FROM  user1 WHERE ";
  631. StrSQL+=" Name='"+this.textBox2.Text+"'";
  632. //"delete from user1 where( "Name="'"+this.textBox2.Text.Trim()+"','"+this.textBox3.Text.Trim()+"')";
  633. //string StrSQL="DELETE FROM  user1 WHERE(Name='"+this.textBox2.Text.Trim()+"'and Passwd='"+this.textBox3.Text.Trim()+"')";
  634. //StrSQL+="Name='"+this.textBox2.Text.Trim()+"'";
  635. //StrSQL+="Passwd='"+this.textBox3.Text.Trim()+"'";
  637. OleDbCommand cmd=new OleDbCommand(StrSQL,conn);
  638. cmd.ExecuteNonQuery();
  642. MessageBox.Show("删除数据集记录操作成功！","信息提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
  643. }
  644. catch(Exception Err)
  645. {
  646. MessageBox.Show("删除数据集记录操作失败："+Err.Message,"信息提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
  648. }
  651. }
  652. }
  653. }