Hi,

     I am creating a class file which has a function of authenticating user. It connects to database and check password verification according to the username. But the variable I use as parameter which is "username"
how to pass that value to select query . code is as below.

public Boolean AuthenticateUser(string username, string password)
    {
        String ConStr = ("Data Source=localhost;Initial Catalog=test;user ID = sa ;Password = keyur");
        String SQL = " SELECT Password from LoginInfo WHERE UserName = '" & username & "'

        SqlConnection conn = new SqlConnection(ConStr);
        SqlCommand cmd = new SqlCommand(SQL, conn);
        String var = null;
        conn.Open();
        var = (String)cmd.ExecuteScalar();




KAR
Web Developer

It looks like you are coding in java. Why don't you use VBA? Anyway, without getting into java, this:

" SELECT Password from LoginInfo WHERE UserName = '" & username & "'

should be this:

"SELECT Password from LoginInfo WHERE UserName = '" & username & "'"

Did that help?



mmcdonal