一个access数据库连接的问题，数据源找不到using

[没落的过客]

if (tbID.Text.Trim() != "" || tbName.Text.Trim() != "" || tbAddress.Text.Trim() != "" || tbPhone.Text.Trim() != "" || tbRace.Text.Trim() != "" || tbRole.Text.Trim() != "" || tbPostalCode.Text.Trim() != "" || tbSex.Text.Trim() != "")
{
//进行数据库的连接
String con = "Provider=Microsoft.Jet.OLEDB.4.0";
Data Source = "C:\\Documents and Settings\\Administrator\\桌面\tbStudentInfo.mdb";
OleDbConnection conec = new OleDbConnection(con);

conec.Open();
OleDbCommand conmd = new OleDbCommand("select * from tbStudentInfo where filedStudentNumber='" + tbID.Text.Trim() + "'", conec);
if (conmd.ExecuteNonQuery() > 0)
{
MessageBox.Show("学号重复，请重新输入 ");
}
else
{
string sqlInsert, sqlvalues, sql;
sqlInsert = "insert into tbStudentInfo(filedStudentsNumber,filedName,filedSex,filedAddress,filedPhone,filedRoce,filedRace,filedPostalCode";
sqlvalues = "values('" + tbID.Text.Trim() + "','" + tbName.Text.Trim() + "','" + tbPhone.Text.Trim() + "','" + tbPostalCode.Text.Trim() + "','" + tbRace.Text.Trim() + "','" + tbSex.Text.Trim() + "','" + tbRole.Text.Trim() + "','" + tbAddress.Text.Trim() + "'";
sql = sqlInsert + ")" + sqlvalues + ")";
conmd.ExecuteNonQuery();
MessageBox.Show("添加成功！");
}
}
报错了，找不到类型或命名空间，我在主窗口绑定了一个ACCESS文件，然后向在这个文件中修改，也就是插入新的，但是为什么不能.open(),
string sqlInsert, sqlvalues, sql;
sqlInsert = "insert into tbStudentInfo(filedStudentsNumber,filedName,filedSex,filedAddress,filedPhone,filedRoce,filedRace,filedPostalCode";
sqlvalues = "values('" + tbID.Text.Trim() + "','" + tbName.Text.Trim() + "','" + tbPhone.Text.Trim() + "','" + tbPostalCode.Text.Trim() + "','" + tbRace.Text.Trim() + "','" + tbSex.Text.Trim() + "','" + tbRole.Text.Trim() + "','" + tbAddress.Text.Trim() + "'";
sql = sqlInsert + ")" + sqlvalues + ")";
这些语句写的没问题吧

[wuyq11]

检查参数类型
那句string strConnection = "Provider=Microsoft.ACE.OLEDB.12.0;";
strConnection += @"Data Source=C:\Documents and Settings\Database1.accdb;";
strConnection += "Persist Security Info=False";
using (OleDbConnection objConnection = new OleDbConnection(strConnection))
{}

[hao1hao2hao3]

报错了，找不到类型或命名空间

问题应该是在头部的using 那一块
没有添加引用就访问了。

另外还有一种情况就是可以参考
http://topic.csdn.net/u/20080225/09/bb81505d-c2d5-42fb-907b-84da46391e34.html

空军的回复。