Update source data from Dataset ***Urgent*** !
Posted on 2004-10-09
I already have a dataset filled by few data adapters.
I am trying to add a record to a certain table's column and update the source database from dataset.
The source database is done in access (in case it might help)
table in dataset: prj
columns in table: prjNo(key, autonumber), prjName(string), prjFinished(yes/no)
When i try to update by using the following commands, a messagebox pops up saying "Parameter ?_1 has no default value"
I also tried to update by using this command but it does not actually update the database:
Private Sub mnuFilePrjNew_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles mnuFilePrjNew.Click
Dim myRow As DataRow = ds.prj.NewRow
myRow(ds.prj.prjNameColumn) = "newly added project name"
Catch ex As Exception