数据库错误(MS访问) [英] Data Base Error(Ms Access)

问题描述

我有一个名为db1.mdb的数据库.它的路径是F:\ client management systemfinalz \ db1.mdb

连接字符串

I have a database named db1.mdb. Its path is F:\client management systemfinalz\db1.mdb

Connection String

con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\\client management systemfinalz\\db1.mdb;Persist Security Info=False";

它可以执行INSERT查询

It can execute INSERT query

obj.IDUCommand("insert into tbl_password  values(''" + ''3'' + "'',''" + "kishore" + "'',''" + "kishore" + "'',''" + "kishore" + "'',''" + "kishore" + "'')");

表tbl_password包含5个字段，其中1个为数字，其他为文本.

上面的INSERT查询正在工作，下面的SELECT查询不工作

The table tbl_password contains 5 fields, 1 is number and others are text.

The above INSERT query is working,bt the following SELECT query is not working

dr2=select cmpname from tbl_password where password=''12345''
 txtcount.Text = dr2["cmpname"].ToString();

dr2获取读取器的返回值

调试时显示不存在数据/列"，但其中包含值

请帮助我
Kishore R
吉斯解决方案
www.uniquewebdeveloper.co.cc

dr2 get return value of reader

When debugging its shows that "no data/column exists", but it contains values

Kindly help me
Kishore R
Gis Solutions
www.uniquewebdeveloper.co.cc

推荐答案

检查列"cmpname"和"password"是否存在?

Check whether column "cmpname" and "password" exist or not?

这篇关于数据库错误(MS访问)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！