public void BindStudentData(int StudentId) { using (SqlCommand cmd = new SqlCommand("FetchStudentData", db.DbConnect())) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@id", StudentId); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { StudentImage.ImageUrl = rdr["avatar"].ToString(); StudentDeptName.Text = student.FetchStudentNameById(rdr["dept_id"].ToString()); lblStudentFullName.Text = rdr["first_name"].ToString() + " " + rdr["last_name"].ToString(); StudentSem.Text = rdr["sem_id"].ToString(); } } }
public string FetchStudentNameById(string StudentId) { int StudIdInt = Convert.ToInt16(StudentId); return(student.FetchStudentNameById(StudIdInt)); }