protected void Page_Load(object sender, EventArgs e) { SurveyQ tdList = new SurveyQ(); SurveyQDAO tdDAO = new SurveyQDAO(); List <SurveyQ> surveyList = new List <SurveyQ>(); surveyList = tdDAO.getSurveyID(); GridView1.DataSource = surveyList; GridView1.DataBind(); BtnSurvey.Visible = false; if (GridView1.Rows.Count < 1) { Label1.Text = "<h1 style='text-align:center;'>There are no Surveys at the moment. Create a Survey below!</h1>"; BtnSurvey.Visible = true; GridView1.Enabled = false; } else { Label1.Text = "<h2> Current List of Surveys </h2>"; } }
protected void Click_Delete(object sender, GridViewDeleteEventArgs e) { string DBConnect = ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString; SqlConnection myConn = new SqlConnection(DBConnect); string Id = GridView1.Rows[e.RowIndex].Cells[0].Text; int result; myConn.Open(); SqlCommand cmd = new SqlCommand("DELETE FROM SurveyQns WHERE SurveyQID ='" + Id + "'", myConn); result = cmd.ExecuteNonQuery(); myConn.Close(); if (result == 1) { SurveyQ surveyObj = new SurveyQ(); SurveyQDAO tdDAO = new SurveyQDAO(); List <SurveyQ> tdList = new List <SurveyQ>(); tdList = tdDAO.getSurveyID(); GridView1.DataSource = tdList; GridView1.DataBind(); } }