if else condition

Question

private void textBox8_Validated(object sender, EventArgs e)
{
SqlCommand cmd = new SqlCommand("SELECT model,fram_no,status FROM add_stock WHERE engen_no='" + textBox8.Text + "'", my);
my.Open();
SqlDataReader dr = cmd.ExecuteReader();
dr.Read();

if (dr.HasRows)
{
if (dr["status"].ToString() == "Sold")
{
MessageBox.Show("This Bike Is Sold");
textBox8.Text = "";

}

if (dr["status"].ToString() == "Available")
{
textBox16.Text = dr["model"].ToString();
textBox9.Text = dr["fram_no"].ToString();
}
}

else
{ MessageBox.Show("NOT A VALID ENGINE NO");
textBox8.Text = "";}
my.Close();
}

no error in code when i enter invalid no error messag shown bt when enter correct one no messag is diplayed for sold and not woks available code wahts wrong

Jignesh Trivedi · Answer

hi can you please check what the value in dr[status] ? also try if (dr[status].ToString().Trim() == Sold) { // do you code here... }

Sunny Sharma · Answer

ta mu Trim() removes the trailing and following spaces from a string.

ta mu · Answer

Jignesh Trivedi yes this code is working. plz tell me what this trim() function did

Sunny Sharma · Answer

have you checked with your db if it has the value for what you're looking for? Here it simply says- dr.HasRows is false.

ta mu · Answer

there is no other option in database only status have to values sold or available befor it was working fine but now i dont know what hapend

Jignesh Trivedi · Answer

hi message NOT A VALID ENGINE NO comes when no engine no is found. here it might possible if engine no is found but it status is not sold or available. it also might possible there is space in database value.... check it.