Hello
I have a strong typed dataset, and when the add btn on the toolbar is
clicked I do the following - which basiscally defines the strongly typed
row, creates a new one & adds it to the dataset datarowcollection.
drow As ds_studies.sp_retrieve_studiesRow
drow = ds_studies.sp_retrieve_studies.Newsp_retrieve_studiesRow
ds_studies.EnforceConstraints = False
ds_studies.sp_retrieve_studies.Addsp_retrieve_studiesRow(drow)
The user finds a blank screen and proceeds on filling values into the
textbox controls / combo boxes etc. When the user clicks on the save button,
I do the dataset update and all the usual stuff like checking for a
successful update / retrieving the newly added row.
My problem: when I reach the line of code in the save btn i.e.
dataadapter.Update(dataset),
I expect to have my adapter.InsertCommand.Parameter Collection filled with
the user entered values:
The parameters look right, the source column in each of them is the colum
specified in the table mappings
However none of the parm values are filled in. I dont think I should be
filling in these values programatically. For your info my datasource is a
stored proc and the parms are exactly mapped to what the proc requires.
If anyone can shed some light on this, I'd appreciate it.
Thanks,
Nisha