error in database query

See more:

C#

database

hello

I have an error in my database command of query
when I run the program , an error appear on message as follow

incorrect syntax near the keyword "WHERE

this is the code

public static Boolean AddTodo(string name, string email, string password)
       {
           Boolean c = false;

           try
           {

               SqlConnection connection = new SqlConnection();
               connection.ConnectionString = @"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\Documents\WinDB.mdf;Connect Timeout=30;User Instance=True;Integrated Security=SSPI";

               connection.Open();


               SqlCommand command1 = new SqlCommand("SELECT * FROM UserInfo.  WHERE UserName= @UserName", connection);
               command1.Parameters.Add(new SqlParameter("@UserName", name));
               command1.ExecuteNonQuery();

               SqlDataReader reader = command1.ExecuteReader();
               {

                   if (!reader.HasRows)
                   {
                       reader.Close();

                       SqlCommand command = new SqlCommand("insert into UserInfo. (UserName, UserEmail, Password) values (@UserName, @UserEmail, @Password)", connection);
                       command.Parameters.Add(new SqlParameter("@UserName", name));
                       command.Parameters.Add(new SqlParameter("@UserEmail", email));
                       command.Parameters.Add(new SqlParameter("@Password", password));

                       command.ExecuteNonQuery();
                       c = true;
                   }
                   else
                   {
                       MessageBox.Show("UserName is thaken");

                   }

               }


               connection.Close();

           }
           catch (SqlException e)
           {
               MessageBox.Show(e.Message);
           }

           return c ;

       }

why is there error ?
what is the wrong !! :(


thanks

PS: UserName key world is as in the database
i.e the same name