vs2005和ccess数据库操作小练习.docVIP

c#实例：vs2005和access数据库操作 小练习 ?????? 去年上c#课，第一次接触，感觉很陌生，特别是写应用程序和数据库连接时错误一大堆。在网上辛辛苦苦的搜寻，终于熟悉了！在这里感谢各位热心人的帮助。 ???????? 今天清除电脑时，发现了这个小作业（如题）可能对各位莱鸟们有帮住，就写下了。界面设计很简单，样子很丑。但能完成对数据库的四种基本操作。 ????? 一、form1的设计 对应的代码： using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Text;using System.Windows.Forms; namespace WindowsApplication1{??? public partial class Form1 : Form??? {??????? public Form1()??????? {??????????? InitializeComponent();??????? } ??????? private void button1_Click(object sender, EventArgs e)??????? {??????????? string a = textBox1.Text;??????????? string g = textBox2.Text;??????????? string c = ; ??????????? string ql;??????????? ql = select zhanghao,mima,shenfen from b1 where zhanghao= + a + and mima= + g + ;??????????? DataSet ds = new DataSet();??????????? ds = ClassLibrary1.DataAccess.GetData(ql); ??????????? if (ds.Tables[0].Rows.Count 0)??????????? {??????????????? c = ds.Tables[0].Rows[0][2].ToString();??????????????? //传递身份??????????????? ClassLibrary1.DataAccess.a = c; ??????????????? ClassLibrary1.DataAccess.b = ds.Tables[0].Rows[0][0].ToString();//zhanghao??????????????? ClassLibrary1.DataAccess.c = ds.Tables[0].Rows[0][1].ToString();??????????????? ??????????????? if (c != null)??????????????? {??????????????????? Form2 fm2 = new Form2();??????????????????? fm2.Show();??????????????????? this.Hide();??????????????? } ??????????? }??????????? else { MessageBox.Show(密码或编号错误); }??????? }??? }} 二、form2的设计 对应的主要控件是：menustrip、treeview、richtextbox 。 代码如下： using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Text;using System.Windows.Forms; namespace WindowsApplication1{??? public partial class Form2 : Form??? {??????? public Form2()??????? {??????????? InitializeComponent();??????? }??????? DataSet aa = new DataSet();??????? private void Form2_Load(object s