Update MySql Database

Question

Hi I am using MySql Database; I retrieved data from database and populate data to text field and I have made some modification on it. And I try to store changes to DataTable by using data.GetChanges() command; it is retrieving null value! If I am changing the record position I am getting the data changes by using same command. I think I have to execute some command before running GetChanges(). Please help me on this issue Thanks & Regards Thahir

Thahir Pattanathel · Answer

I am getting changes in DataTable changes = data.GetChanges(); only after change the position of the record. Thanks & Regards Thahir

Muralidharan Deenathayalan · Answer

Are you able to see the modified records in the save button event. DataTable changes = data.GetChanges(); Add a break point in the above line and see the modified records are available in data table.

Thahir Pattanathel · Answer

Yes I have called data.AcceptChanges() after update. namespace App014 { public partial class Form1 : Form { private MySqlConnection conn; private DataTable data; private MySqlDataAdapter da; private MySqlCommandBuilder cb; public Form1() { InitializeComponent(); ConnectDB(); } private void ConnectDB() { if (conn != null) conn.Close(); string connStr = server=localhost;user id=root; password=xxxxx; database=eTest; try { conn = new MySqlConnection(connStr); conn.Open(); data = new DataTable(); da = new MySqlDataAdapter(SELECT codename FROM USERMASTER conn); cb = new MySqlCommandBuilder(da); da.Fill(data); lstUser.DataSource = data; lstUser.DisplayMember = name; lstUser.ValueMember = code; txtCode.DataBindings.Add(new System.Windows.Forms.Binding(Text data code)); txtName.DataBindings.Add(new System.Windows.Forms.Binding(Text data name)); } catch (MySqlException ex) { MessageBox.Show(Error connecting to the server:  + ex.Message); } } private void UpdateData() { DataTable changes = data.GetChanges(); if (changes != null) { da.Update(changes); data.AcceptChanges(); } else { MessageBox.Show(No Changes found); } } private void btnSave_Click(object sender EventArgs e) { UpdateData(); } } }

Suthish Nair · Answer

You must call datatable.AcceptChanges() method after updating datatable/dataset.

Muralidharan Deenathayalan · Answer

How you've modified the datarow ? Have you called called  datarow.BeginEdit(); //do the modification datatow.EndEdit();