if else condition

ta mu

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

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Trivedi13y ago
Accepted answer
hi,

can you please check what the value in dr["status"] ?
also try

if (dr["status"].ToString().Trim() == "Sold")
{
// do you code here...
}
0
Sunny Sharma13y ago
ta mu,

Trim() removes the trailing and following spaces from a string.
0
ta mu13y ago
Jignesh Trivedi yes this code is working. plz tell me what this trim() function did
0
Sunny Sharma13y ago
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.
0
ta mu13y ago
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

0
Jignesh Trivedi13y ago
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.
0