MS Access DB Help

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