Update table with textbox.DataBindings

Question

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

Giovanni Medico · Answer

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?

Disha Raval · Answer

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();

Giovanni Medico · Answer

I did and test it as you advice me but still problem persist. could you send me a working code?

Disha Raval · Answer

https://www.codeproject.com/Questions/676117/Fail-to-Update-DataBase-using-TextBox-Binding-to-a