更改datagridview列名时无法搜索

Question

我更改了datagridview的列名，现在搜索查询不工作它说在查询(2)中找不到列名emp_f_name，第二个查询

有什么问题?

SqlConnection con = new SqlConnection(); 
con.ConnectionString = "Data Source=LFC;Initial Catalog=contactmgmt;Integrated Security=True"; 
SqlDataAdapter sda = new SqlDataAdapter("SELECT emp_id as 'EmployeeID' , emp_f_name as 'First Name', emp_l_name as 'Last Name',emp_alias as 'Alias Name',emp_contact_no as 'Contact No',emp_address as 'Address',emp_company as 'Company Name',emp_bdate as 'DOB',emp_email as'EmailID' FROM cntc_employee",con); 
dt = new DataTable(); 
sda.Fill(dt); 
dataGridView1.DataSource = dt;
dv.RowFilter = string.Format("emp_f_name LIKE '%{0}%'",textBox9.Text);

Answer 1

您已经为emp_f_name即First Name使用了别名，要么删除别名，要么使用别名。您需要将多字别名/列放在方括号中，如[First Name] .

]。

dv.RowFilter = string.Format("[First Name] LIKE '%{0}%'",textBox9.Text);