C#与access数据库的相关操作(详细)

1、C#对Access数据库的操作刚刚完成了c#与数据库的编程,做个很实用的总结。1.操作涉及的主要C#类有:(1D ataSet:对应数据库表的一个集合,实际上是数据库表在内存中的一个缓存;(2D ataTable:对应数据库表,是数据库表行的集合;(3D ataRow:对应数据库表行;(4O leDbConnection:建立数据库连接(5O leDbDataAdapter:由数据库生成DataSet,并负责DataSet与数据库的同步(6O leDbCommandBuilder:生成更新数据库所需的指令2.链接Access数据库需要的链接字符串:3.链接Access数据库需要引入的明明空间:

2、(1查询:string sql = ""if (radioButton1.Checked = false && radioButton2.Checked = falsesql = "select * from StuInfo_table"else if (radioButton1.Checkedif (textBox1.Text = ""sql = "select * from StuInfo_table"elsesql = "select * from StuInfo_table whe

3、re 学号='" + textBox1.Text + "'"elseif (textBox1.Text = ""sql = "select * from StuInfo_table"elsesql = "select * from StuInfo_table where 姓名='" + textBox1.Text + "'"dataGridView1.Show(;OleDbDataAdapter da = new OleDbDataAdapter(sql

4、, gongyongclass.Conn;DataSet ds=new DataSet(;da.Fill(ds, "StuInfo_table"dataGridView1.DataSource = ds.Tables0;(2增加:if (textBox1.Text != "" && textBox2.Text != "" && textBox3.Text != "" && textBox4.Text != ""if (textBox3.Text !

5、= textBox4.TextMessageBox.Show("两次密码不一致!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information;textBox3.Text = ""textBox4.Text = ""elseOleDbCommand Comm = new OleDbCommand("",gongyongclass.Conn;Comm.CommandText = "select * from Admin_table wh

6、ere Ssid='" + textBox2.Text + "'"if (Comm.ExecuteScalar( = nullComm.CommandText = sql;Comm.ExecuteNonQuery(;MessageBox.Show("添加成功!"this.Close(;elseMessageBox.Show("用户已存在!"elseMessageBox.Show("信息不完整!", "提示", MessageBoxButtons.OK, MessageB

7、oxIcon.Information;(3删除OleDbCommand Comm = new OleDbCommand("delete from StuInfo_table where 学号='"+textBox1.Text+"'", gongyongclass.Conn;Comm.ExecuteNonQuery(;MessageBox.Show("操作成功"this.Close(;(4修改OleDbCommand Comm = new OleDbCommand("update StuInfo_table set " + comboBox1.Text + "='" + textBox2.Text + "'where 学号='"+gongyongclass.StuNo+"&