Hello! I am working on a login form and creating a validation.

Muhammad Anees

i am working on a validation but it gives me an error that "operator && cannot be applied to bool"..

if (txt_Name.Text != "" && txt_State.Text != "") {  
    cmd = new SqlCommand("insert into tbl_Record(Name,State) values(@name,@state)", con);  
    con.Open();  
    cmd.Parameters.AddWithValue("@name", txt_Name.Text);  
    cmd.Parameters.AddWithValue("@state", txt_State.Text);  
    cmd.ExecuteNonQuery();  
    con.Close();  
    MessageBox.Show("Record Inserted Successfully");  
    DisplayData();  
    ClearData();  
} else {  
    MessageBox.Show("Please Provide Details!"); 
}

Please guide me how to fix it???

3 Replies

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

Vikas Panwar4y ago
Accepted answer
Use like this
if (!String.IsNullOrEmpty(txt_Name.Text) && !String.IsNullOrEmpty(txt_State.Text))
{
cmd = new SqlCommand("insert into tbl_Record(Name,State) values(@name,@state)", con);
con.Open();
cmd.Parameters.AddWithValue("@name", txt_Name.Text);
cmd.Parameters.AddWithValue("@state", txt_State.Text);
cmd.ExecuteNonQuery();
con.Close();
MessageBox.Show("Record Inserted Successfully");
DisplayData();
ClearData();
}
else
{
MessageBox.Show("Please Provide Details!");
}
Muhammad Anees4y ago
Thank You so much bro!!!
it works and my problem is solved.
God bless you
Srinivasan Ramamoorthi4y ago
Use isnullorempty() function instead of checking “”