if (checkBox1.Checked == true)
{
string strconn = "Provider=Micrsoft.Jet.OleDb.4.0;Data Source=G:\\通讯录.mdb";
//strconn += @"";
OleDbConnection oleconn = new OleDbConnection(strconn);
oleconn.Open();
string strquery = "select * from cheziliao where 车号='" + textBox1.Text + "'";
OleDbCommand cmd = new OleDbCommand(strquery, oleconn);
OleDbDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
this.textBox2.Text += reader.GetString(0) + " " +
reader.GetString(1) + " " + reader.GetString(2) + " " +
reader.GetString(3) + " " + reader.GetString(4) + " " +
reader.GetString(5) + " " + reader.GetString(6) + " " +
reader.GetString(7) + "\r\n"; }
oleconn.Close();
}我想实现的是当我在TEXTBOX1输入车号时,在TEXTBOX2显示车号相同的不同的信息
但是老出现“未在本地计算机上注册“Micrsoft.Jet.OleDb.4.0”提供程序。”
{
string strconn = "Provider=Micrsoft.Jet.OleDb.4.0;Data Source=G:\\通讯录.mdb";
//strconn += @"";
OleDbConnection oleconn = new OleDbConnection(strconn);
oleconn.Open();
string strquery = "select * from cheziliao where 车号='" + textBox1.Text + "'";
OleDbCommand cmd = new OleDbCommand(strquery, oleconn);
OleDbDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
this.textBox2.Text += reader.GetString(0) + " " +
reader.GetString(1) + " " + reader.GetString(2) + " " +
reader.GetString(3) + " " + reader.GetString(4) + " " +
reader.GetString(5) + " " + reader.GetString(6) + " " +
reader.GetString(7) + "\r\n"; }
oleconn.Close();
}我想实现的是当我在TEXTBOX1输入车号时,在TEXTBOX2显示车号相同的不同的信息
但是老出现“未在本地计算机上注册“Micrsoft.Jet.OleDb.4.0”提供程序。”
2.Data Source不要写成“Data Sourse”,
3.检查是否安装了Office
4.重新安装注册MDAC28.exe (一般你的vs安装目录里有或者到微软的官方网站上下)
http://access911.net/fixhtm/72FABF1E14DC.htm?tt= (这个地址是一个朋友给的)
5.如果是64位平台,也可能出现这种情况;解决方法:生成->配置管理器->平台->点击Any Cpu选项卡->新建->新建平台->X86