private void load_dataGridView_student() { try { Cursor.Current = Cursors.WaitCursor; BindingSource bindingsource = new BindingSource(); List <DBstudent> rec = DBstudent.GetData(); foreach (DBstudent data in rec) { bindingsource.Add(data); } this.dataGridView_student.Refresh(); this.dataGridView_student.AutoGenerateColumns = false; this.dataGridView_student.DataSource = bindingsource; this.dataGridView_student.ClearSelection(); Cursor.Current = Cursors.Default; } catch (Exception ex) { ex.ToString(); } }
private void buttonS_Click(object sender, EventArgs e) { enAbleButton(); if (isAdd) { DBstudent add = new DBstudent(textBoxF.Text, textBoxL.Text, textBoxM.Text); add.Add(); load_dataGridView_student(); MessageBox.Show("Added successfuly"); } }
public static List <DBstudent> GetData() { List <DBstudent> data = new List <DBstudent>(); MySqlConnection con = DBConnection.ConnectDatabase(); try { MySqlCommand cmd = new MySqlCommand("SELECT * FROM " + tablename, con); MySqlDataReader reader = cmd.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { DBstudent rawData = new DBstudent(); rawData.Id = reader.GetInt32(0); rawData.firstName = reader.GetString(1); rawData.lastName = reader.GetString(2); rawData.middleName = reader.GetString(3); data.Add(rawData); } } reader.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { con.Close(); } return(data); }