Update database with values in DataGridView using C#

Question

How can I update the values in the database with the values in the DataGridRow when the button is clicked?

To be precise i want to change the text of column from "En cours" to "PRET" when i click the button

public void ajoutercolonne()
{
    DataGridViewButtonColumn btn = new DataGridViewButtonColumn();
    btn.Name = "Validation";
    btn.Text = "Prêt";
    btn.UseColumnTextForButtonValue = true;
    dataGridView2.Columns.Add(btn);
}

Does this answer your question? Updating Database Using Datagridview — William Xifaras
– William Xifaras, Commented Nov 25, 2019 at 15:07

mxmissile · Accepted Answer · 2019-11-25 15:34:51Z

0

Use a ado.net request tu update here is a example:

  SqlConnection conn = new SqlConnection("Server=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\Database.mdf;Trusted_Connection=True; 
       User Instance=yes");
  conn.Open();
  string sql2 = "UPDATE student SET moneyspent = " + ?????? + " WHERE id=" + studentIndex + ";";
  SqlCommand myCommand2 = new. 
  SqlCommand(sql2, conn);

See slso here: https://www.c-sharpcorner.com/UploadFile/718fc8/save-delete-search-and-update-record-in-ado-net/

edited Nov 25, 2019 at 15:34

mxmissile

11.7k6 gold badges57 silver badges85 bronze badges

answered Nov 25, 2019 at 15:22

Micha

9206 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

mxmissile Over a year ago

Wide open to sql injection, do not do this.

Collectives™ on Stack Overflow

Update database with values in DataGridView using C#

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related