Show no record found in ASP.Net GridView with Vertical Columns using C#

Hi I have create one grid and convert header from horizontal to vertidal and dipsplay info.

it is working fine but I need to know how I can change the text fof the vertical coulmn names which are coming from database table also I wanted to show no record found if query return zero record.

private void BindDataTest()
{

    using (SqlConnection con = new SqlConnection(getconn()))
    {
        using (SqlCommand cmd = new SqlCommand())
        {




            cmd.CommandText = "select Test1, Test2, Test3,Test4, Test5 from TestTable where RequestID = " + sID;

            SqlDataAdapter mySqlDataAdapter = new SqlDataAdapter();
            mySqlDataAdapter.SelectCommand = cmd;



            DataSet myDataSet = new DataSet();
            cmd.Connection = con;
            con.Open();


            mySqlDataAdapter.Fill(myDataSet);

            DataSet ds = myDataSet;

            if (ds.Tables.Count > 0)
            {
                DataSet new_ds = FlipDataSet(ds); // Flip the DataSet
                DataView my_DataView = new_ds.Tables[0].DefaultView;
                grdView1.DataSource = my_DataView;

                grdEVCriteria.DataBind();
            }
            else
            {
                grdView1.Visible = false;
                lableGrid.Text = "No record found";
            }

            con.Close();
        }
    }
 


}




public DataSet FlipDataSet(DataSet my_DataSet)
{
    DataSet ds = new DataSet();
    foreach (DataTable dt in my_DataSet.Tables)
    {
        DataTable table = new DataTable();
        for (int i = 0; i <= dt.Rows.Count; i++)
        {
            table.Columns.Add(Convert.ToString(i));
        }
        DataRow r = null;
        for (int k = 0; k < dt.Columns.Count; k++)
        {
            r = table.NewRow();
            r[0] = dt.Columns[k].ToString();
            for (int j = 1; j <= dt.Rows.Count; j++)
                r[j] = dt.Rows[j - 1][k];
            table.Rows.Add(r);
        }
        ds.Tables.Add(table);
    }

    return ds;
}

<asp:GridView ID="grdView1" runat="server" EmptyDataText="No records Found"
    CssClass="test" ShowHeader="false">

    <EmptyDataTemplate>No Record Available</EmptyDataTemplate>
</asp:GridView>
<asp:Label ID="lableGrid" runat="server" Text=""></asp:Label>