Please check like are you getting the Values or not?

If your query fine then please see change something like

Please check like are you getting the Values or not?
If your query fine then please see change something like

using (MySqlDataReader rdr = command.ExecuteReader())
                    {
//But here you will see only last records.So just add all the records in some list or array variable and then add that temp variable to gridview.
                        while (rdr.Read())
                        {
                            transactionGridView.DataSource = rdr.GetString(rdr.GetOrdinal("Your table column names");
                            transactionGridView.DataBind();
                            transactionGridView.Visible = true;
                        }
                    }

You should add columns to the Gridview or use AutogeneratedColumns property to true to view.



Refer



http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.gridview.columns(v=vs.110).aspx[^]

You should add columns to the Gridview or use AutogeneratedColumns property to true to view.

Refer

http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.gridview.columns(v=vs.110).aspx[^]