+972 52-548-6969
Negative hiring decisions, Part II
time to read 3 min | 493 words
Another case of a candidate completing a task at home and sending it to me which resulted in a negative hiring decision is this:
protected void Button1_Click(object sender, EventArgs e) { string connectionString = @"Data Source=OFFICE7-PC\SQLEXPRESS;Integrated Security=True"; string sqlQuery = "Select UserName From [Users].[dbo].[UsersInfo] Where UserName = ' " + TextBox1.Text + "' and Password = ' " + TextBox2.Text+"'"; using (SqlConnection connection = new SqlConnection(connectionString)) { SqlCommand command = new SqlCommand(sqlQuery, connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); try { while (reader.Read()) { } } finally { if (reader.HasRows) { reader.Close(); Response.Redirect(string.Format("WebForm2.aspx?UserName={0}&Password={1}", TextBox1.Text, TextBox2.Text)); } else { reader.Close(); Label1.Text = "Wrong user or password"; } } } }
The straw that really broke the camel’s back in this case was the naming of WebForm2. I could sort of figure out the rest, but not bothering to give a real name to the page was over the top.
Comments
Comment preview