MS Access DB Help

Question

I have a program with a MS Access DB that holds the login details for users.

I really cant work out how to connect to the database and check to see if the login username and then password that are enetered are the same as those in the databse..

Can anyone guide me in the right direction?

Thanks in advance

Hirendra Sisodiya · Answer

hello adam try this OleDbConnection oCon = new OleDbConnection(Put your Connection string); oCon.Open(); object obj; string str = Select count(*) from tablename where Login=' + UserId + ' ams password =' + password + ' ; OleDbCommand cmd = new OleDbCommand(str oCon); obj = cmd.ExecuteScalar(); if ((int)obj!= 0) { //Login successfull } else { // Unsuccessfull } thanks please mark as answer if it helps