private void FillGrid()
{
try
{
objdt = new DataTable();
members = new clsmanagemeb();
members.Action = "Fetch";
objdt = members.FetchGrid();
if (objdt.Rows.Count > 0)
{
GVMembers.DataSource = objdt;
GVMembers.DataBind();
}
else
{
GVMembers.DataSource = null;
GVMembers.DataBind();
}
}
catch (Exception ex)
{
throw ex;
}
ShowMessageCredit();
//GVMembers.DataSource = Library.getDataset("Select * from M_User Order by UserID desc");
//GVMembers.DataBind();
}
protected void Exportexcel_Click(object sender, ImageClickEventArgs e)
{
Response.ClearContent();
Response.Buffer = true;
Response.AddHeader("content-disposition", string.Format("attachment; filename={0}", "Customers.xls"));
Response.ContentType = "application/ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
GVMembers.AllowPaging = false;
GVMembers.DataBind();
//Change the Header Row back to white color
GVMembers.HeaderRow.Style.Add("background-color", "#FFFFFF");
//Applying stlye to gridview header cells
for (int i = 0; i < GVMembers.HeaderRow.Cells.Count; i++)
{
GVMembers.HeaderRow.Cells[i].Style.Add("background-color", "#507CD1");
}
int j = 1;
//This loop is used to apply stlye to cells based on particular row
foreach (GridViewRow gvrow in GVMembers.Rows)
{
gvrow.BackColor = Color.White;
if (j <= GVMembers.Rows.Count)
{
if (j % 2 != 0)
{
for (int k = 0; k < gvrow.Cells.Count; k++)
{
gvrow.Cells[k].Style.Add("background-color", "#EFF3FB");
}
}
}
j++;
}
GVMembers.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();
}
