private void button2_Click(object sender, EventArgs e) { obj = (Student)comboBox1.SelectedItem; textBox6.Text = obj.stu_name; textBox7.Text = obj.stu_id; textBox8.Text = obj.stu_department; textBox9.Text = obj.stu_semester; textBox10.Text = obj.stu_section; }
private void button3_Click(object sender, EventArgs e) { obj = (Student)comboBox1.SelectedItem; obj.stu_name = textBox6.Text; obj.stu_id = textBox7.Text; obj.stu_department = textBox8.Text; obj.stu_semester = textBox9.Text; obj.stu_section = textBox10.Text; }
private void button1_Click(object sender, EventArgs e) { obj = new Student(); obj.stu_name = textBox1.Text; obj.stu_id = textBox2.Text; obj.stu_department = textBox3.Text; obj.stu_semester = textBox4.Text; obj.stu_section = textBox5.Text; comboBox1.Items.Add(obj); }
public static List<Student> getStudent () { List<Student> studentList = new List<Student>(); string sqlString = "SELECT * FROM STUDENT"; SqlCommand sqlCommand = new SqlCommand(sqlString, sqlConnection); try { sqlConnection.Open(); SqlDataReader sqlDataReader = sqlCommand.ExecuteReader(); while (sqlDataReader.Read()) { Student student = new Student(); student.studentId = (int)sqlDataReader["Id"]; student.studentName = sqlDataReader["Name"].ToString(); student.studentDepartment = sqlDataReader["Department"].ToString(); student.studentCgpa = (double)sqlDataReader["CGPA"]; student.studentGender = (Boolean)sqlDataReader["Gender"]; studentList.Add(student); } sqlDataReader.Close(); } catch (SqlException ex) { throw ex; } finally { sqlConnection.Close(); } return studentList; }