public List <BringStudentData> GetallStudentTextBox(string regno) { List <BringStudentData> allStudent = new List <BringStudentData>(); using (SqlConnection connection = new SqlConnection(connectionString)) { SqlCommand cmd = new SqlCommand(); cmd.CommandText = "SELECT * FROM tbl_Student WHERE RegestretionNumber = @RegestretionNumber"; cmd.Parameters.AddWithValue("@RegestretionNumber", regno); cmd.Connection = connection; connection.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { BringStudentData aStudentData = new BringStudentData(); aStudentData.GetValue(reader["StudentID"].ToString(), reader["StudentName"].ToString(), reader["MobileNumber"].ToString(), reader["EmailAddress"].ToString(), reader["DepartmentID"].ToString(), reader["RegestretionNumber"].ToString()); allStudent.Add(aStudentData); } reader.Close(); connection.Close(); return(allStudent); } }
protected void ddlupdateDelete_SelectedIndexChanged(object sender, EventArgs e) { GetClear(); saveButton.Enabled = false; BringStudentData bringStudent = new BringStudentData(); bringStudent = (aBringStudentData.AStudentData(ddlupdateDelete.SelectedValue)); studentNameTextBox.Text = bringStudent.StudentName; mobileNumberTextBox.Text = bringStudent.MobileNumber; emailAddressTextBox.Text = bringStudent.Email; registrationNumberTextBox.Text = bringStudent.RegNO; ddlDepartment.SelectedValue = bringStudent.DepartmentId; }