/// <summary> /// 点击查询按钮 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Button1_Click(object sender, EventArgs e) { string condition = ""; string value = textBox1.Text; if (comboBox1.Text == "员工姓名") { condition = "name"; } if (comboBox1.Text == "性别") { condition = "gender"; } //模糊查询关键字 string sql = string.Format("SELECT [Id],[name],[gender],[date] FROM [Attendance] WHERE [{0}] LIKE '%{1}%'", condition, value); DataTable dt = AttendanceDAL.FindDataTable(sql); dataGridView1.DataSource = null; dataGridView1.Columns.Clear(); dataGridView1.DataSource = dt; dataGridView1.Columns["name"].HeaderText = "员工姓名"; dataGridView1.Columns["gender"].HeaderText = "性别"; dataGridView1.Columns["date"].HeaderText = "考勤日期"; dataGridView1.Columns["Id"].HeaderText = "考勤ID"; }