protected void Page_Load(object sender, EventArgs e) { try { if (!IsPostBack && !IsCallback) { int QuestionnaireID = 0; securityAgent = new CryptoProvider(); if (Request.QueryString.Count > 0) { QuestionnaireID = int.Parse(securityAgent.decryptText(Request.QueryString["QID"].Replace(' ', '+'))); //QuestionnaireID = int.Parse(Request.QueryString["QID"]); ViewState["CurrentQuestionnaire"] = QuestionnaireID; } LoadQuestionnaireList(); AnswerListGridView.DataBind(); if (QuestionnaireID > 0) { ConfigGridView.DataBind(); QuestionsGridView.DataBind(); } } } catch (Exception ex) { CommonHelpers.writeLogToFile("Page_Load: EditQuestionnaire.aspx", ex.Message); } }
protected void Page_Load(object sender, EventArgs e) { //get connection string from web config. string connectionString = ConfigurationManager.ConnectionStrings["TestConnection"].ConnectionString; //Create sql Connection and open it using (SqlConnection connection = new SqlConnection(connectionString)) { //other way connection.ConnectionString = connectionString; connection.Open(); //select all from testQUestion table; SqlCommand command = new SqlCommand("SELECT * FROM TestQuestion", connection); //store the data temporary SqlDataReader reader = command.ExecuteReader(); //has colums and rows DataTable dt = new DataTable(); dt.Columns.Add("ID", typeof(int)); //create column headers based on data and fill it with data from the reader dt.Load(reader); //Display into a grid view UI QuestionsGridView.DataSource = dt; QuestionsGridView.DataBind(); }// will call dispose on my connection here, which will close my db connection }
protected void ConfigGridView_CustomCallback(object sender, DevExpress.Web.ASPxGridViewCustomCallbackEventArgs e) { ListEditItem listItem = cmbQuestionnaireList.SelectedItem; txtQuestionnaireName.Text = listItem.Text; RefreshForm(); ConfigGridView.DataBind(); QuestionsGridView.DataBind(); }
protected void cmbQuestionnaireList_SelectedIndexChanged(object sender, EventArgs e) { ListEditItem listItem = cmbQuestionnaireList.SelectedItem; txtQuestionnaireName.Text = listItem.Text; RefreshForm(); ConfigGridView.DataBind(); QuestionsGridView.DataBind(); }
protected void QuestionsGridView_RowDeleting(object sender, DevExpress.Web.Data.ASPxDataDeletingEventArgs e) { e.Cancel = true; try { DBAgent = new DataAccessProvider(DataAccessProvider.ParamType.ServerCredentials, ConfigurationManager.AppSettings["DBServerName"], ConfigurationManager.AppSettings["DBUserName"], ConfigurationManager.AppSettings["DBPassword"]); DBAgent.AddParameter("@ParamQuestionnaireID", cmbQuestionnaireList.SelectedItem.Value); DBAgent.AddParameter("@ParamQID", e.Keys[0]); DBAgent.AddParameter("@ParamLoginID", Session["LoginID"]); DBAgent.ExecuteNonQuery("dbo.spDeleteQuestionForQuestionnaire"); QuestionsGridView.DataBind(); } catch (Exception ex) { CommonHelpers.writeLogToFile("QuestionsGridView_DataBinding: EditQuestionnaire.aspx", ex.Message); } }
protected void cmdSaveQuestion_Click(object sender, EventArgs e) { try { int QuestionID = 0; DBAgent = new DataAccessProvider(DataAccessProvider.ParamType.ServerCredentials, ConfigurationManager.AppSettings["DBServerName"], ConfigurationManager.AppSettings["DBUserName"], ConfigurationManager.AppSettings["DBPassword"]); DBAgent.AddParameter("@ParamQuestionText", txtQuestion.Text); object o = DBAgent.ExecuteScalar("dbo.spAddQuestion"); if (o != null) { QuestionID = int.Parse(o.ToString()); if (QuestionID > 0) { int AnswerSortOrder = 1; foreach (ListEditItem li in lbSelectedAnswers.Items) { DBAgent.ClearParams(); DBAgent.AddParameter("@ParamQuestionID", QuestionID); DBAgent.AddParameter("@ParamAnswerID", li.Value); DBAgent.AddParameter("@ParamAnswerSortOrder", AnswerSortOrder); DBAgent.ExecuteNonQuery("dbo.spAddQuestionAnswerMapping"); AnswerSortOrder++; } DBAgent.ClearParams(); DBAgent.AddParameter("@ParamQuestionnaireID", cmbQuestionnaireList.SelectedItem.Value); DBAgent.AddParameter("@ParamQuestionID", QuestionID); DBAgent.ExecuteNonQuery("dbo.spAddQuestionnaireQuestionMapping"); QuestionsGridView.DataBind(); RefreshForm(); } } QuestionsGridView.DataBind(); } catch (Exception ex) { CommonHelpers.writeLogToFile("cmdSaveQuestion_Click: EditQuestionnaire.aspx", ex.Message); } }
protected void BindQuestionsGrid() { QuestionsGridView.DataSource = HccApp.MembershipServices.UserQuestions.FindAll(); QuestionsGridView.DataKeyNames = new[] { "bvin" }; QuestionsGridView.DataBind(); }
protected void cmbQuestionnaireList_SelectedIndexChanged(object sender, EventArgs e) { QuestionsGridView.DataBind(); }