Update table with textbox.DataBindings

Giovanni Medico

Hello. I'm trying to figure out how to view the data and update it.

The problem is that it does not update

ds = new DataSet("Tab_Clienti");

da1 = new SqlDataAdapter("SELECT * FROM Tab_Clienti", Utility.ConnSQL);

//da1.TableMappings.Add("Table", "Tab_Clienti");

da1.Fill(ds, "Tab_Clienti");

txtRagione.DataBindings.Add(new Binding("Text", ds, "Tab_Clienti.Ragione", false, DataSourceUpdateMode.OnPropertyChanged ));

up to here everything is ok, I see the data

edit textbox and click button

da1.UpdateCommand = new SqlCommandBuilder(da1).GetUpdateCommand();

da1.Update(ds,"Tab_Clienti");

update does not work

4 Replies

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

Giovanni Medico8y ago
private void button2_Click(object sender, EventArgs e)

{

txtRagione.DataBindings[0].WriteValue();

da1.UpdateCommand = new SqlCommandBuilder(da1).GetUpdateCommand();

da1.Update(ds.Tables[0]);

MessageBox.Show(ds.Tables[0].Rows[0].RowState.ToString()); "not modified"

}

in this way?
+1
Disha Raval8y ago
The DataBinding doesn't usually write the value until after the control starts to lose focus. Since you are updating the TextBox programmatically, the DataBinding doesn't know there is something to update.

The way you wrote your code, you would have to call the WriteValue() method yourself (assuming only 1 databinding exists on the TextBox):

txtRagione.DataBindings.Add(new Binding("Text", ds, "Tab_Clienti.Ragione", false, DataSourceUpdateMode.OnPropertyChanged ));
txtRagione.DataBindings[0].WriteValue();
+1
Giovanni Medico8y ago
I did and test it as you advice me but still problem persist.
could you send me a working code?
+1
Disha Raval8y ago
https://www.codeproject.com/Questions/676117/Fail-to-Update-DataBase-using-TextBox-Binding-to-a
+1