Update BD Sqlserver when changing in datagridview instantly

Question

Hi friends.

I put a datagridview in a form. I loaded this datagrid with data from SQL Server. I wanted that when I changed a data in the grid, this data would be changed in the database without programming. Is it possible or do I have to put an "Update" button and schedule this update?

Below is the code that populates the gridview.

			String^ connectionString = "Data Source=NOTEBOOK\\SQLEXPRESS;Initial Catalog=LOTOFACIL;Integrated Security=SSPI;Trusted_Connection=True;";


			SqlConnection^ connection = gcnew SqlConnection(connectionString);


			connection->Open();


			String^ query = "SELECT * from Numeros";


			SqlCommand^ command = gcnew SqlCommand(query, connection);


			SqlDataAdapter^ dataAdapter = gcnew SqlDataAdapter(command);


			DataTable^ dataTable = gcnew DataTable();


			dataAdapter->Fill(dataTable);


			bindingSource1 = gcnew System::Windows::Forms::BindingSource();
			bindingSource1->DataSource = dataTable;


			dataGridView1->DataSource = bindingSource1;


			connection->Close();

Answer 1

Hi, José Carlos

You have to add an update button:
A primary key is needed in DB table .Change dataAdapter and dataTable to class member Click event sample:

SqlCommandBuilder^ commandBuilder = gcnew SqlCommandBuilder(dataAdapter);
	dataAdapter->UpdateCommand = commandBuilder->GetUpdateCommand();
	dataAdapter->Update(dataTable);

Best regards,

Minxin Yu

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hello Minxin Yu.

Thank you very much for your attention.

A question. Do I keep the same gridview completion code that I posted above and in the "Update" button click event do I put the code you sent me?

Is that all? Or do I have to change the gridview filling code?

José Carlos