C# MySQL 搜索查询

Question

此代码具有搜索患者房间分配的功能:

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();                     
    }                    

我在搜索患者姓名时遇到困难，它在数据库中存储为两个不同的字段，FirstName 和 LastName。我只想输入名字和姓氏的组合。

Answer 1

尝试将您的 SQL 代码更改为:

cmd = new MySqlCommand("Select * from patientinfo where LastName + ' ' + FirstName like '%" + textBox1.Text + "%'", con.con);