Advertisement
Guest User

Untitled

a guest
Apr 27th, 2017
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.68 KB | None | 0 0
  1. protected void Button1_Click(object sender, EventArgs e)
  2. {
  3. Response.Clear();
  4. Response.Buffer = true;
  5. Response.ClearContent();
  6. Response.ClearHeaders();
  7. Response.Charset = "";
  8. string FileName = "Vithal" + DateTime.Now + ".xls";
  9. StringWriter strwritter = new StringWriter();
  10. HtmlTextWriter htmltextwrtter = new HtmlTextWriter(strwritter);
  11. Response.Cache.SetCacheability(HttpCacheability.NoCache);
  12. Response.ContentType = "application/vnd.ms-excel";
  13. Response.AddHeader("Content-Disposition", "attachment;filename=" + FileName);
  14. GridView1.GridLines = GridLines.Both;
  15. GridView1.HeaderStyle.Font.Bold = true;
  16. GridView1.RenderControl(htmltextwrtter);
  17. Response.Write(strwritter.ToString());
  18. Response.End();
  19. }
  20.  
  21.  
  22.  
  23.  
  24.  
  25. protected void Page_Load(object sender, EventArgs e)
  26. {
  27.  
  28. if (Session["Functie"].ToString() != "Admin")
  29. {
  30. Response.Redirect("ErrorNoAcces.aspx");
  31. }
  32. List<String> list1 = new List<string>();
  33. SqlConnection sqlcon = new SqlConnection();
  34. sqlcon.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionStringDB"].ToString();
  35. SqlCommand CMDcursusen = new SqlCommand();
  36. SqlCommand CMDTotaal = new SqlCommand();
  37. SqlCommand CMDNaam = new SqlCommand();
  38. CMDNaam.Connection = sqlcon;
  39. CMDcursusen.Connection = sqlcon;
  40. CMDTotaal.Connection = sqlcon;
  41. CMDcursusen.CommandText = "SELECT DISTINCT CursusID FROM TblInschrijving";
  42. CMDNaam.CommandText = "SELECT Naam FROM TblCursus WHERE CursusID=@param";
  43. sqlcon.Open();
  44. SqlDataReader dr = CMDcursusen.ExecuteReader();
  45. while (dr.Read())
  46. {
  47. list1.Add(dr[0].ToString());
  48. }
  49. dr.Close();
  50. for (int i = 0;i < list1.Count;i++)
  51. {
  52. CMDTotaal.CommandText = "SELECT COUNT(Personeelsnummer) FROM TblInschrijving WHERE CursusID=@param";
  53. CMDTotaal.Parameters.Add("@param", list1[i]);
  54. CMDNaam.Parameters.Add("@param", list1[i]);
  55. Chart2.Series["Series"].Points.AddXY(CMDNaam.ExecuteScalar(), CMDTotaal.ExecuteScalar());
  56. Chart3.Series["Series"].Points.AddXY(CMDNaam.ExecuteScalar(), CMDTotaal.ExecuteScalar());
  57. CMDTotaal.Parameters.Clear();
  58. CMDNaam.Parameters.Clear();
  59. }
  60. sqlcon.Close();
  61. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement