pass dataset to database, C#

treefrog90876

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!

5 Replies

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

treefrog9087622y ago
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.
+1
treefrog9087622y ago
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.
+1
juliet_zl22y ago
Have you used the textbox's DataBindings.Add() method to link up with the column of your database, yet?
+1
treefrog9087622y ago
This is not a web program, it is a windows application.
+1
crend_king22y ago
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.
+1