updating datagridview

[auwi987]

hello guys how can i update datagridview to display the newly added data to the database

here is my sample code for adding data to the database

MySqlCommand cmdAdd = new MySqlCommand("INSERT INTO tblelemdetails (STUD_ID,LNAME,FMNAME,AGE,ADDRESS,BDAY,BPLACE,RELIGION,CITIZEN,CITY,LSCHOOL,LSCHOOLADD,SCHOOLYEAR,GENDER,LEVEL) VALUES('" + Ids.ToString() + "','" + txtLName.Text + "','" + fnamer + "','" + txtAge.Text + "','" + txtHAddress.Text + "','" + bdayer + "','" + txtPOBirth.Text + "','" + txtReligion.Text + "','" + txtCitizen.Text + "','" + txtCity.Text + "','" + txtLSchool.Text + "','" + txtLSchoolAdd.Text + "','" + txtSY.Text + "','" + cmbGender.Text + "','" + cmbYrLvl.Text + "')", db_con.DbConn);
                cmdAdd.Transaction = mytrans;
                cmdAdd.ExecuteNonQuery();
                cmdAdd.Dispose();
                mytrans.Commit();
                MessageBox.Show("Data Has Been Succesfully Added","Important Note",MessageBoxButtons.OK,MessageBoxIcon.Exclamation);
                Clear();
                db_con.DbConn.Close();

pls need some help and thanks

[thines01]

You will either need to re-select the data from the database OR put the inserted rows into a class or other container (like a GridViewRow) that is the same shape as your GridView and add it to the GridView.

[auwi987]

is it posible to repopulate the datagridview?

[ChrisHunter]

yes just do datagridview1.clear() then do what you did to populate it the first time round. i think that works . . .

[auwi987]

@chrisHunter, i applied repopulate the datagridview but it doesn't work what strategy do i need to do?

here my file enrollment_system folder and the and try to help me from frmEEdit thanks
https://skydrive.live.com/#cid=7E08C7AB11D99D40

[ChrisHunter]

i applied repopulate the datagridview but it doesn't work.

Does this mean you tried the .Clear() method of the data grid view and following that used the populated the grid view the same way you had in the originally ?

[auwi987]

yup, i already used that kind of approach but it does not update the datagridview?