Manually editing content of datatable row
Posted on 2006-06-28
i have added a dataset, tableadapter and bindingsource to a form using vb2005 visual designer.
i have some textboxes bound to datatables on the dataset.
what i want to know is, can i manually edit the content of the bindingsource current row of data for a specified column?
in other words, the bindingsource is connected to a table on the access database, and each row has a lot of columns. in the form i use a binding navigator which scrolls through the rows when i click on the arrow and fills the textboxes with the data accordingly. i want to change manually, in code, the content of column "DATE" for example, for a given row position the navigatior is currently in.
i want my manual changes to be updated to the database when i .endedit the bindinsource and call update on the tableadapter.