hi i tried this code to search in database and display result in datagridview but it seems something is wrong what is the wrong ? this is my code
if (comboBox1.Text == "month") {
SqlDataAdapter dataAdapter = new SqlDataAdapter("SELECT name, mil_no, rotba, arrival_time, leaving_time, day, year FROM dbo.Hodor_data where month LIKE ='" + textBox1.Text + "'", co);
DataTable dt = new DataTable();
dataAdapter.Fill(dt);
dataGridView1.DataSource = dt;
}
and this is my interface
