// Adding Assessment Component MEnu private void btnAddAssessmentComponent_Click(object sender, EventArgs e) { //Showing Added RUbric Details in combobox And Adding this against this rubric SqlConnection Connection = new SqlConnection(constr); Connection.Open(); if (Connection.State == ConnectionState.Open) { string query = "select Id,Details from dbo.Rubric"; SqlDataAdapter t = new SqlDataAdapter(query, Connection); DataTable dtatbl = new DataTable(); t.Fill(dtatbl); cmboboxRubricDetails.DataSource = dtatbl; cmboboxRubricDetails.DisplayMember = "Details"; cmboboxRubricDetails.ValueMember = "id"; } Connection.Close(); //Showing Added Assessment Titles in combobox And Adding this against this Assessment SqlConnection Connection1 = new SqlConnection(constr); Connection1.Open(); if (Connection1.State == ConnectionState.Open) { string query = "select Id,Title from dbo.Assessment"; SqlDataAdapter t = new SqlDataAdapter(query, Connection1); DataTable dtatbl = new DataTable(); t.Fill(dtatbl); combboxListOfAssessment.DataSource = dtatbl; combboxListOfAssessment.DisplayMember = "Title"; combboxListOfAssessment.ValueMember = "id"; } Connection1.Close(); ListOfAddedAssessmentComponentDataGridView.Hide(); lblTitle.Hide(); txtTitle.Hide(); lblDateCreated.Hide(); dtpDateCreated.Hide(); lblTotalMarks.Hide(); txtTotalMarks.Hide(); lblTotalWeightage.Hide(); txtTotalWeightage.Hide(); btnADD.Hide(); ListOfAddedAssessmentsDataGridView.Hide(); lblName.Show(); txtName.Show(); lblRubricDetails.Show(); cmboboxRubricDetails.Show(); lblAssessments.Show(); combboxListOfAssessment.Show(); lblTotalMarksAC.Show(); txtTotalMarksAC.Show(); lblDateCreatedAC.Show(); dtpDateCreatedAC.Show(); btnADDComponent.Show(); }
//Showing Ad Assessment Menu private void btnAddAssessment_Click_1(object sender, EventArgs e) { ListOfAddedAssessmentComponentDataGridView.Hide(); lblTitle.Show(); txtTitle.Show(); lblDateCreated.Show(); dtpDateCreated.Show(); lblTotalMarks.Show(); txtTotalMarks.Show(); lblTotalWeightage.Show(); txtTotalWeightage.Show(); btnADD.Show(); ListOfAddedAssessmentsDataGridView.Hide(); lblName.Hide(); txtName.Hide(); lblRubricDetails.Hide(); cmboboxRubricDetails.Hide(); lblAssessments.Hide(); combboxListOfAssessment.Hide(); lblTotalMarksAC.Hide(); txtTotalMarksAC.Hide(); lblDateCreatedAC.Hide(); dtpDateCreatedAC.Hide(); btnADDComponent.Hide(); }
//Showing List Of Added Assessments By datagridview and Hiding other Things Except this private void btnListOfAddedAssessment_Click(object sender, EventArgs e) { ListOfAddedAssessmentComponentDataGridView.Hide(); lblTitle.Hide(); txtTitle.Hide(); lblDateCreated.Hide(); dtpDateCreated.Hide(); lblTotalMarks.Hide(); txtTotalMarks.Hide(); lblTotalWeightage.Hide(); txtTotalWeightage.Hide(); btnADD.Hide(); lblName.Hide(); txtName.Hide(); lblRubricDetails.Hide(); cmboboxRubricDetails.Hide(); lblAssessments.Hide(); combboxListOfAssessment.Hide(); lblTotalMarksAC.Hide(); txtTotalMarksAC.Hide(); lblDateCreatedAC.Hide(); dtpDateCreatedAC.Hide(); btnADDComponent.Hide(); ListOfAddedAssessmentsDataGridView.Show(); using (SqlConnection con = new SqlConnection(constr)) { using (SqlCommand cmd = new SqlCommand("SELECT * FROM dbo.Assessment", con)) { cmd.CommandType = CommandType.Text; using (SqlDataAdapter sda = new SqlDataAdapter(cmd)) { using (DataTable dt = new DataTable()) { sda.Fill(dt); ListOfAddedAssessmentsDataGridView.DataSource = dt; } } } } }
//On Load just Showing Add Assessment Menu private void AddAssessmentForm_Load(object sender, EventArgs e) { ListOfAddedAssessmentComponentDataGridView.Hide(); ListOfAddedAssessmentsDataGridView.Hide(); lblName.Hide(); txtName.Hide(); lblRubricDetails.Hide(); cmboboxRubricDetails.Hide(); lblAssessments.Hide(); combboxListOfAssessment.Hide(); lblTotalMarksAC.Hide(); txtTotalMarksAC.Hide(); lblDateCreatedAC.Hide(); dtpDateCreatedAC.Hide(); btnADDComponent.Hide(); }