protected void Button1_Click1(object sender, EventArgs e) { using (newentities myentities = new newentities()) { var feed = from f in myentities.feedbacks select new { EMPLOYEE_NUMBER=f.empno, EMPLOYEE_NAME=f.name, SUGGESTIONS_GIVEN=f.suggestions,BEST_TECHNOLOGY= f.besttechno }; GridView1.Visible = true; GridView1.DataSource = feed; GridView1.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { using (newentities myentities = new newentities()) { var a1= from f in myentities.feedbacks group f by 1 into g select new { AVERAGE_RESPONSE_TIME=g.Average(f=> f.q1), AVERAGE_SOFTWARE_UPTIME=g.Average(f => f.q2), AVERAGE_HARDWARE_UPTIME = g.Average(f => f.q3), }; GridView2.DataSource = a1; GridView2.DataBind(); var b1 = from f in myentities.feedbacks group f by 1 into g select new { AVERAGE_LAN_PERFORMANCE = g.Average(f => f.q4), AVERAGE_TELE_PERFORMANCE = g.Average(f => f.q5), AVERAGE_WIFI_PERFORMANCE = g.Average(f => f.q6), }; GridView3.DataSource = b1; GridView3.DataBind(); var c1 = from f in myentities.feedbacks group f by 1 into g select new { AVERAGE_SIGNAL_BOOSTER = g.Average(f => f.q7), AVERAGE_PROCUREMENT = g.Average(f => f.q8), AVERAGE_UPDATION = g.Average(f => f.q9), }; GridView4.DataSource = c1; GridView4.DataBind(); var d1 = from f in myentities.feedbacks group f by 1 into g select new { AVERAGE_AVCONFERENCING = g.Average(f => f.q10), AVERAGE_IMPORTANCE_GIVEN = g.Average(f => f.q11), AVERAGE_MAINTENANCE = g.Average(f => f.q12) }; GridView5.DataSource = d1; GridView5.DataBind(); GridView1.Visible = false; } }