Data Base Error(Ms Access)

See more:

MS-Access

Microsoft

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";

It can execute INSERT query

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

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 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