数据库操作入门速查（1）——Access数据库简单访问

引用
using System.Data.OleDb;
编写代码

string s = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\student\zws20151389047\EX1\Database1.mdb";
OleDbConnection strConnection = new OleDbConnection(s);
strConnection.Open();
OleDbCommand ocmd = new OleDbCommand();
ocmd.Connection = strConnection;
ocmd.CommandType = CommandType.Text;
string s1 = "insert into 成绩表 values('201513890','王二',22,89)";
ocmd.CommandText = s1;
ocmd.ExecuteNonQuery();

当我们使用的是Access 2007或更高版本Access创建的数据库时，创建的往往是.accdb文件，在这种情况下，我们需要更改Provider，即

@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\student\zws20151389047\EX1\Database1.accdb"

如果我们想创建几个TextBox来输入数据，则

string num = textBox1.Text;
string Sname = textBox2.Text;
int Nage = int.Parse(textBox3.Text);
int ef = int.Parse(textBox4.Text);

string s = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\student\zws20151389047\EX1\Database1.mdb";
OleDbConnection strConnection = new OleDbConnection(s);
strConnection.Open();
OleDbCommand ocmd = new OleDbCommand();
ocmd.Connection = strConnection;
ocmd.CommandType = CommandType.Text;

string s1 = "insert into 成绩表 values('"+num+"','"+Sname+"','"+Nage+"','"+ef+"')";
ocmd.CommandText = s1;
ocmd.ExecuteNonQuery();

在DataTable里显示数据库

DataTable Dt=new DataTable();
OleDbDataAdapter myda;
string s=@"";
OleDbConnection strConnection =new OleDbConnection(s);
strConnection.Open();
myda=new OleDbDataAdapter("select * from 成绩表",strConnection);
DataSet myds=new DataSet();
myda.Fill(Dt);
dataGridView.DataSource=Dt;
dataGridView.Columns[1].HeaderText="姓名";