/// <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();
}
