protected void ENRDropDownList_OnSelectedIndexChanged(Object sender, EventArgs e)
{
caption.Text = "Comparison of Fall Enrollment Numbers - " + ENRDropDownList.SelectedItem;
Session["term"] = ENRDropDownList.SelectedValue;
MyGridView1.DataBind();
MyGridView2.DataBind();
MyGridView3.DataBind();
MyGridView4.DataBind();
MyGridView5.DataBind();
MyGridView6.DataBind();
MyGridView7.DataBind();
MyGridView8.DataBind();
MyGridView9.DataBind();
MyGridView10.DataBind();
MyGridView11.DataBind();
string dropValue = ENRDropDownList.SelectedItem.Text;
string drop = ENRDropDownList.SelectedItem.Value.Remove(4, 1);
int previousvalue = Convert.ToInt32(drop) - 2;
//For Last_Term
MyGridView1.Columns[1].HeaderText = "Fall " + Convert.ToString(previousvalue);
MyGridView2.Columns[1].HeaderText = "Fall " + Convert.ToString(previousvalue);
MyGridView3.Columns[1].HeaderText = "Fall " + Convert.ToString(previousvalue);
MyGridView4.Columns[1].HeaderText = "Fall " + Convert.ToString(previousvalue);
MyGridView5.Columns[1].HeaderText = "Fall " + Convert.ToString(previousvalue);
MyGridView6.Columns[1].HeaderText = "Fall " + Convert.ToString(previousvalue);
MyGridView7.Columns[1].HeaderText = "Fall " + Convert.ToString(previousvalue);
MyGridView8.Columns[1].HeaderText = "Fall " + Convert.ToString(previousvalue);
MyGridView9.Columns[1].HeaderText = "Fall " + Convert.ToString(previousvalue);
MyGridView10.Columns[1].HeaderText = "Fall " + Convert.ToString(previousvalue);
MyGridView11.Columns[1].HeaderText = "Fall " + Convert.ToString(previousvalue);
//For Current_Term
MyGridView1.Columns[2].HeaderText = dropValue;
MyGridView2.Columns[2].HeaderText = dropValue;
MyGridView3.Columns[2].HeaderText = dropValue;
MyGridView4.Columns[2].HeaderText = dropValue;
MyGridView5.Columns[2].HeaderText = dropValue;
MyGridView6.Columns[2].HeaderText = dropValue;
MyGridView7.Columns[2].HeaderText = dropValue;
MyGridView8.Columns[2].HeaderText = dropValue;
MyGridView9.Columns[2].HeaderText = dropValue;
MyGridView10.Columns[2].HeaderText = dropValue;
MyGridView11.Columns[2].HeaderText = dropValue;
}
private void getHTMLGridView()
{
string attachment = "attachment; filename=" + Path.GetFileName(Request.PhysicalPath).Substring(0, Path.GetFileName(Request.PhysicalPath).Length - 5) + "_" + ENRDropDownList.SelectedItem + ".doc";
Response.ClearContent();
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.AddHeader("content-disposition", attachment);
Response.ContentType = "application/vnd.word";
StringWriter stw = new StringWriter();
HtmlTextWriter htextw = new HtmlTextWriter(stw);
String cellcount = MyGridView1.Rows[0].Cells.Count.ToString();
string header = "<div><table align='center' style='font-weight:bold; font-family:Verdana; font-size:14px; line-height:18px;' width= '";
header += MyGridView1.Width.ToString() + "'><tr><td align='center' style='letter-spacing: 0.2em;' colspan='";
header += cellcount + "'>TEXAS TECH UNIVERSITY</td></tr>";
header += "<tr><td align='center' colspan='";
header += cellcount + "'>" + caption.Text.ToUpper() + "</td></tr>";
header += "<tr><td align='center' colspan='";
header += cellcount + "'>DEPARTMENT OF INSTITUTIONAL RESEARCH</td></tr><tr><td align='center' style='font-size:11px;' colspan='";
header += cellcount + "'>(Uncertified Data)</td></tr><tr><td colspan='";
header += cellcount + "'><br></td></tr><tr><td align='center' colspan='";
header += cellcount + "'><br>" + gvCaptionN.Text.ToString() + "</td></tr><tr><td colspan='";
header += cellcount + "'></td></tr></table></div>";
Response.Output.Write(header);
MyGridView1.DataBind();
MyGridView1.RenderControl(htextw);
stw.WriteLine("<br><div><table align='center' style='font-weight:bold; font-family:Verdana; font-size:14px; line-height:18px;' width= '" + MyGridView2.Width.ToString() + "'><tr><td align='center' colspan='" + cellcount + "'>" + gvCaptionA.Text.ToString() + "</td></tr></table></div>");
MyGridView2.DataBind();
MyGridView2.RenderControl(htextw);
stw.WriteLine("<br><div><table align='center' style='font-weight:bold; font-family:Verdana; font-size:14px; line-height:18px;' width= '" + MyGridView3.Width.ToString() + "'><tr><td align='center' colspan='" + cellcount + "'>" + gvCaptionP.Text.ToString() + "</td></tr></table></div>");
MyGridView3.DataBind();
MyGridView3.RenderControl(htextw);
stw.WriteLine("<br><div><table align='center' style='font-weight:bold; font-family:Verdana; font-size:14px; line-height:18px;' width= '" + MyGridView4.Width.ToString() + "'><tr><td align='center' colspan='" + cellcount + "'>" + gvCaptionR.Text.ToString() + "</td></tr></table></div>");
MyGridView4.DataBind();
MyGridView4.RenderControl(htextw);
stw.WriteLine("<br><div><table align='center' style='font-weight:bold; font-family:Verdana; font-size:14px; line-height:18px;' width= '" + MyGridView5.Width.ToString() + "'><tr><td align='center' colspan='" + cellcount + "'>" + gvCaptionU.Text.ToString() + "</td></tr></table></div>");
MyGridView5.DataBind();
MyGridView5.RenderControl(htextw);
stw.WriteLine("<br><div><table align='center' style='font-weight:bold; font-family:Verdana; font-size:14px; line-height:18px;' width= '" + MyGridView6.Width.ToString() + "'><tr><td align='center' colspan='" + cellcount + "'>" + gvCaptionG.Text.ToString() + "</td></tr></table></div>");
MyGridView6.DataBind();
MyGridView6.RenderControl(htextw);
stw.WriteLine("<br><div><table align='center' style='font-weight:bold; font-family:Verdana; font-size:14px; line-height:18px;' width= '" + MyGridView7.Width.ToString() + "'><tr><td align='center' colspan='" + cellcount + "'>" + gvCaptionT.Text.ToString() + "</td></tr></table></div>");
MyGridView7.DataBind();
MyGridView7.RenderControl(htextw);
stw.WriteLine("<br><div><table align='center' style='font-weight:bold; font-family:Verdana; font-size:14px; line-height:18px;' width= '" + MyGridView8.Width.ToString() + "'><tr><td align='center' colspan='" + cellcount + "'>" + gvCaptionD.Text.ToString() + "</td></tr></table></div>");
MyGridView8.DataBind();
MyGridView8.RenderControl(htextw);
stw.WriteLine("<br><div><table align='center' style='font-weight:bold; font-family:Verdana; font-size:14px; line-height:18px;' width= '" + MyGridView9.Width.ToString() + "'><tr><td align='center' colspan='" + cellcount + "'>" + gvCaptionS.Text.ToString() + "</td></tr></table></div>");
MyGridView9.DataBind();
MyGridView9.RenderControl(htextw);
stw.WriteLine("<br><div><table align='center' style='font-weight:bold; font-family:Verdana; font-size:14px; line-height:18px;' width= '" + MyGridView10.Width.ToString() + "'><tr><td align='center' colspan='" + cellcount + "'>" + gvCaptionH.Text.ToString() + "</td></tr></table></div>");
MyGridView10.DataBind();
MyGridView10.RenderControl(htextw);
stw.WriteLine("<br><div><table align='center' style='font-weight:bold; font-family:Verdana; font-size:14px; line-height:18px;' width= '" + MyGridView11.Width.ToString() + "'><tr><td align='center' colspan='" + cellcount + "'>" + gvCaptionO.Text.ToString() + "</td></tr></table></div>");
MyGridView11.DataBind();
MyGridView11.RenderControl(htextw);
Response.Output.Write(stw.ToString());
Response.End();
}