pass dataset to database C#

Question

I have a text control bound to a table in my dataset. The problem is that when I make a change in the text box my dataset does not recognize the changes. I would like to be able to type in a change in the text box, and have it call: getchanges then dataAdapter.update(table), and then acceptchanges. If I am going about this wrong please let me know. I also have about 25 fields to update so I am trying to prevent hand typing each textbox. I would like to just commit the changes on a click. Thanks for your help!

treefrog90876 · Answer

I just placed a data grid on my form which I chose the DataSource to be my dataset.table. When I called my update method it recognized the changes (I used the haschanges function)and it made the changes to the database. It also updated my text box with the new value after the update -> accept changes.

treefrog90876 · Answer

yep. I used the databindings property to choose the correct column to bind the text box to for a particular table in my dataset. I looked at the code and the add method is generated for me specifying my dataset and table.column for me.

juliet_zl · Answer

Have you used the textbox's DataBindings.Add() method to link up with the column of your database yet?

treefrog90876 · Answer

This is not a web program it is a windows application.

crend_king · Answer

After you changed the textBox did you submit the form? If you do not submit the form the changes could not be recognized I think. If you submitted then write your codes in the textBox.TextChanged procedure. They will work.

pass dataset to database, C#