gridview is not showing values

See more:

C#

C#4.0

hi,

my gridview is not showing data,
i checked with breakpoints, datatable is showing data but gridview is not showing,.query is correct, runed on Mysql workbench.it's winforms application.

<pre lang="c#"> using (MySqlConnection con = new MySqlConnection(ConnectionString))
            {
                String query = "select * from transaction where DATE(paid_date)BETWEEN '" + fromdate + "'AND'" + todate + "' AND(customer_id='" + customer + "' OR card_id='" + card + "')";
                con.Open();
                MySqlDataAdapter da = new MySqlDataAdapter(query, con);
                DataTable dt = new DataTable();
                da.Fill(dt);
                dataGridView1.DataSource = dt;
                //dataGridView1.DataBind();