Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- protected void Button1_Click(object sender, EventArgs e)
- {
- Response.Clear();
- Response.Buffer = true;
- Response.ClearContent();
- Response.ClearHeaders();
- Response.Charset = "";
- string FileName = "Vithal" + DateTime.Now + ".xls";
- StringWriter strwritter = new StringWriter();
- HtmlTextWriter htmltextwrtter = new HtmlTextWriter(strwritter);
- Response.Cache.SetCacheability(HttpCacheability.NoCache);
- Response.ContentType = "application/vnd.ms-excel";
- Response.AddHeader("Content-Disposition", "attachment;filename=" + FileName);
- GridView1.GridLines = GridLines.Both;
- GridView1.HeaderStyle.Font.Bold = true;
- GridView1.RenderControl(htmltextwrtter);
- Response.Write(strwritter.ToString());
- Response.End();
- }
- protected void Page_Load(object sender, EventArgs e)
- {
- if (Session["Functie"].ToString() != "Admin")
- {
- Response.Redirect("ErrorNoAcces.aspx");
- }
- List<String> list1 = new List<string>();
- SqlConnection sqlcon = new SqlConnection();
- sqlcon.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionStringDB"].ToString();
- SqlCommand CMDcursusen = new SqlCommand();
- SqlCommand CMDTotaal = new SqlCommand();
- SqlCommand CMDNaam = new SqlCommand();
- CMDNaam.Connection = sqlcon;
- CMDcursusen.Connection = sqlcon;
- CMDTotaal.Connection = sqlcon;
- CMDcursusen.CommandText = "SELECT DISTINCT CursusID FROM TblInschrijving";
- CMDNaam.CommandText = "SELECT Naam FROM TblCursus WHERE CursusID=@param";
- sqlcon.Open();
- SqlDataReader dr = CMDcursusen.ExecuteReader();
- while (dr.Read())
- {
- list1.Add(dr[0].ToString());
- }
- dr.Close();
- for (int i = 0;i < list1.Count;i++)
- {
- CMDTotaal.CommandText = "SELECT COUNT(Personeelsnummer) FROM TblInschrijving WHERE CursusID=@param";
- CMDTotaal.Parameters.Add("@param", list1[i]);
- CMDNaam.Parameters.Add("@param", list1[i]);
- Chart2.Series["Series"].Points.AddXY(CMDNaam.ExecuteScalar(), CMDTotaal.ExecuteScalar());
- Chart3.Series["Series"].Points.AddXY(CMDNaam.ExecuteScalar(), CMDTotaal.ExecuteScalar());
- CMDTotaal.Parameters.Clear();
- CMDNaam.Parameters.Clear();
- }
- sqlcon.Close();
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement