C#

<asp:GridView ID="GridResumoTotal" runat="server" Height="2px"
Width="100%" AutoGenerateColumns="true" >
</asp:GridView>

protected void Page_Load(object sender, EventArgs e)
{

if (!IsPostBack)
{
//dataTable para guarda dados temporario
dtb = CriaDataTable();
Session["mDatatable"] = dtb;
GridResumoTotal.DataSource = ((DataTable)Session["mDatatable"]).DefaultView;
GridResumoTotal.DataBind();
}

//criar um DataTable temporário
private DataTable CriaDataTable()
{
DataTable mDataTable = new DataTable();
DataColumn mDataColumn;

mDataColumn = new DataColumn();
mDataColumn.DataType = Type.GetType("System.String");
mDataColumn.ColumnName = "MODALIDADE";
mDataTable.Columns.Add(mDataColumn);

mDataColumn = new DataColumn();
mDataColumn.DataType = Type.GetType("System.String");
mDataColumn.ColumnName = "QTD_OBJ_16";
mDataTable.Columns.Add(mDataColumn);

mDataColumn = new DataColumn();
mDataColumn.DataType = Type.GetType("System.String");
mDataColumn.ColumnName = "QTD_OBJ_17";
mDataTable.Columns.Add(mDataColumn);

return mDataTable;
}

private void incluirNoDataTable(string modalidade, string qtd_obj16, string qtd_obj_17, DataTable mTable)
{
DataRow linha;
linha = mTable.NewRow();
//gera o número GUID
//linha["CODIGO"] = Guid.NewGuid().ToString();
linha["MODALIDADE"] = modalidade;
linha["QTD_OBJ_16"] = qtd_obj16;
linha["QTD_OBJ_17"] = qtd_obj_17;
mTable.Rows.Add(linha);
}


GridResumoTotal.Columns.Clear();
incluirNoDataTable("TOTAL GERAL DIA : ", footer.Cells[16].Text,footer.Cells[17].Text, (DataTable)Session["mDatatable"]);
GridResumoTotal.DataSource = ((DataTable)Session["mDatatable"]).DefaultView;
GridResumoTotal.DataBind();

myCon.Open();

                        SqlCommand com3 = new SqlCommand("checkRole", myCon);
                        com3.CommandType = CommandType.StoredProcedure;
                        com3.Parameters.AddWithValue("@uName", TBoxUName.Text);
                        String role = com3.ExecuteScalar().ToString();

                        myCon.Close();



                        if (role == "user")
                        {

                            Response.Write("Users Page");

                            //Response.Write(role);

                        }

                        else
                        {

                            //Response.Write(role);
                            Response.Write("Admins Page");

                        }