lucacodorean

Untitled

Nov 18th, 2019
190
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 0.90 KB | None | 0 0
  1.    void update()
  2.         {
  3.             succes_update = false;
  4.             OleDbConnection connect = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0; Data source=soft.accdb;");
  5.             connect.Open();
  6.             OleDbCommand command = new OleDbCommand();
  7.             command.Connection = connect;
  8.             command.CommandText = "update query1 SET nume=@nume, autor=@autor, nrnreg=@nrneg, tip=@tip, status=@status WHERE nume=@nume;";
  9.             command.Parameters.AddWithValue("nume", cbCarte.SelectedText);
  10.             command.Parameters.AddWithValue("autor", txtNumeA.Text);
  11.             command.Parameters.AddWithValue("nrneg", txtReg.Text);
  12.             command.Parameters.AddWithValue("tip", txtTip.Text);
  13.             command.Parameters.AddWithValue("status", txtInchiriata.Text);
  14.             command.ExecuteNonQuery();
  15.             connect.Close();
  16.             succes_update = true;
  17.         }
Advertisement
Add Comment
Please, Sign In to add comment