C# MySQL Search query
<p>This code has a function to search for the patient's room assignment:</p>

<pre><code>else if(radioButton1.Checked == true)
{
    DataTable table = new DataTable();
    cmd = new MySqlCommand("Select * from patientinfo where LastName and FirstName = '" + textBox1.Text + "'", con.con);
    reader = cmd.ExecuteReader();
    MySqlDataReader dr = cmd.ExecuteReader();
    if(dr.Read())
    {
        label2.Text = dr.GetString("LastName") + "," + dr.GetString("FirstName");
        label6.Text = dr.GetString("Room");
        if(label6.Text == "506")
        {
            label3.Text = "Payward Building";          
        }                
        else if(label6.Text == "507")                
        {                
            label3.Text = "Payward Building";                    
        }                    
    }
    else
    {                     
        MessageBox.Show("No Data! Please Try Again", "Warning", MessageBoxButtons.OK);                        
        con.Close();                     
    }                    
</code></pre>

<p>I am having difficulties to search for the patient name, which is stored as two different fields in the database, <code>FirstName</code> and <code>LastName</code>. I want only to input on the combination of the first name and last name.</p>