private void re(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 RegistrationNumber From Student";
//SqlCommand cmd = new SqlCommand("SELECT * FROM Customer", conn);
SqlCommand cmd02 = new SqlCommand(cmd2, conn1);
SqlDataReader sd = cmd02.ExecuteReader();
while (sd.Read())
{
cboStdId.Items.Add(sd[0]);
}
////Load Tiltles of Assessment
String assess = "SELECT Title From Assessment";
//SqlCommand cmd = new SqlCommand("SELECT * FROM Customer", conn);
SqlCommand sqlcmd = new SqlCommand(assess, conn1);
SqlDataReader sqldata = sqlcmd.ExecuteReader();
while (sqldata.Read())
{
cboAssessment.Items.Add(sqldata[0]);
}
/// Load Details into Rubriclvlcomobox
String rubriclvl = "SELECT Details From RubricLevel";
//SqlCommand cmd = new SqlCommand("SELECT * FROM Customer", conn);
SqlCommand sqlcommand = new SqlCommand(rubriclvl, conn1);
SqlDataReader sqldataread = sqlcommand.ExecuteReader();
while (sqldataread.Read())
{
cboRubriclvl.Items.Add(sqldataread[0]);
}
StudentResult stdResult = new StudentResult();
dgvStdres.DataSource = stdResult.Showdata();
dgvStdres.Columns.Add(stdResult.Editbtn());
dgvStdres.Columns.Add(stdResult.Deletebtn());
}
private void btnUpdate_Click(object sender, EventArgs e)
{
StudentResult stdResult = new StudentResult();
dgvStdres.DataSource = stdResult.Showdata();
}