/// <summary> /// Load Data from DataBase /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void AssessCompo_Load(object sender, EventArgs e) { String conURL1 = "Data Source = DESKTOP-RPO4Q5R\\PARVEEN; Initial Catalog =ProjectB; User ID = mohsin; Password = mohsin123; MultipleActiveResultSets = True"; //String conURL = "Data Source = (local); Initial Catalog = MedicalEncyclopedia; Integrated Security = True; MultipleActiveResultSets = True"; SqlConnection conn1 = new SqlConnection(conURL1); conn1.Open(); String cmd2 = "SELECT Details From Rubric"; //SqlCommand cmd = new SqlCommand("SELECT * FROM Customer", conn); SqlCommand cmd02 = new SqlCommand(cmd2, conn1); SqlDataReader sd = cmd02.ExecuteReader(); while (sd.Read()) { cboRubricId.Items.Add(sd[0]); } AssessmentComponent assessComp = new AssessmentComponent(); dgvAssessmentComponent.DataSource = assessComp.Showdata(); dgvAssessmentComponent.Columns.Add(assessComp.Editbtn()); dgvAssessmentComponent.Columns.Add(assessComp.Deletebtn()); }
private void btnUpdate_Click(object sender, EventArgs e) { AssessmentComponent assessComp = new AssessmentComponent(); dgvAssessmentComponent.DataSource = assessComp.Showdata(); }