Databases
StackOverflow2013
Postsdbo
POhow to update rows list of a datagridview after adding new row to a table
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POhow to update rows list of a datagridview after adding new row to a table
    primarykey
    data
    text
    <p>I have a datagridview filled with a table collection on the load event of the form, i have also a form filled by the user and that add new row to the table onclick event, i would like to update the datagridview after adding new row to the table, i use a sqladapter binded to a bindingdatasource. this is the code </p> <pre><code> private void button1_Click(object sender, EventArgs e) { connection.Open(); string nv = textBox7.Text.Trim().Replace(',', '.'); // string sql=""; sql = "INSERT INTO Employe(id_cnss, nom, prenom, adresse, tel,email,mt_heur_travail, titre) VALUES('"+textBox1.Text.ToString().Trim()+"','"+textBox2.Text.ToString().Trim()+"','"+textBox3.Text.ToString().Trim()+"','"+richTextBox1.Text.ToString().Trim()+"','"+textBox4.Text.ToString().Trim()+"','"+textBox5.Text.ToString().Trim()+"',"+nv+",'"+textBox6.Text.Trim()+"')"; // sql = "UPDATE Employe SET id_cnss ='" + + "' , nom ='" + + "', prenom ='" + + "', adresse ='" + + "', tel ='" + + "', email ='" + + "', mt_heur_travail =" + + ", titre ='" + + "' where id_cnss=" + index; c = new SqlCommand(sql, connection); c.CommandText = sql; // IAsyncResult res; int ex = c.ExecuteNonQuery(); if (ex != null) { MessageBox.Show("employé ajouté"); //dataGridView1.Rows.Clear(); //DataTable table = (DataTable)dataGridView1.DataMember; adapter = new SqlDataAdapter("select * from employe where id_emp=IDENT_CURRENT('EMPLOYE')", connection); adapter.Fill(dTable); //adapter.Update(dTable); dataGridView1.Refresh(); } connection.Close(); } </code></pre> <p>this code add all the rows of the table to the datagridview but i need only to add the latest row added to the database brievely, when the user click under add, </p> <p>i would like that the new row will be added to the datagridview And thank you in advance</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. UStarek
    1. UStarek
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COIt isn't clear what your problem is here. Are you asking why new rows from the database do not show up in the datagridview? Or how to add rows added to the datagridview to the database? Something else?
      singulars
      1. POhow to update rows list of a datagridview after adding new row to a table
      1. USDavid Hall
    2. COi'm asking why new row from database (added onclick event) is not either added to the datagridview. adapter.fill(dtable) add all rows of the database but i need only adding the new row
      singulars
      1. POhow to update rows list of a datagridview after adding new row to a table
      1. UStarek
    3. COThanks for the edit - so it appears that your problem is that when you add rows to the datasource using the second form, the datagridview does not reflect these changes, even when using the .Refresh() command? I don't think you can comment right now (due to low reputation), so perhaps just update your question. If this is your problem then it is easy to solve.
      singulars
      1. POhow to update rows list of a datagridview after adding new row to a table
      1. USDavid Hall
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload