Tblusers users = new Tblusers();
users.Login = "sgj320";
users.Password = "password";
ICriteria results = session.CreateCriteria(typeof(Tblusers))
.Add(Example.Create(users));
IList user = results.List();
return user.Count;

whats wrong with that it keeps not filling in the blanks.
SELECT this_.userid as userid0_0_, this_.username as username0_0_, this_.Password as Password0_0_, this_.email as email0_0_, this_.address as address0_0_, this_.name as name0_0_, this_.surname as surname0_0_, this_.town as town0_0_, this_.postcode as postcode0_0_, this_.telephone as telephone0_0_, this_.mobile as mobile0_0_ FROM Tblusers this_ WHERE (this_.username = ? and this_.Password = ?) ]
Positional parameters: 0 sgj320
0 password

Am using latest version of nhibernate and asp.net 3.5.
why? I can add records so am assumming it's something to do with that