Update MySql Database

Thahir Pattanathel

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

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

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

Thanks & Regards
Thahir
0
14y ago
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.
0
Thahir Pattanathel14y ago
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 code,name 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();
}
}
}
0
Suthish Nair14y ago
You must call datatable.AcceptChanges() method after updating datatable/dataset.
0
14y ago
How you've modified the datarow ?

Have you called called ,
datarow.BeginEdit();
//do the modification

datatow.EndEdit();
0