Problem updating dataset.

microsoft.public.dotnet.framework.adonet

22 Feb 2006 7:16 AM

Nickl

I am having difficulty updating values in a dataset when they have comboboxes
bound to them.

The trouble is in the following code;

Dim rowContract as datarow

rowContract = DsSalesContractEdit.pSelectSalesContractBasic.Rows(0) ' the
dataset only has one row
rowContract.BeginEdit()
'the error occurs on the next line
rowContract.Item("SeasonID") = Me.cboSeason.SelectedValue

When I try to modify the column "SeasonID" I get an error saying that
"Column SeasonID is read only". This occurs for all the fields bound to combo
boxes. Other textbox fields in the same section of code are working fine.

The code used to bind combo box is;
cboSeason.DataSource = DsSalesContractEdit.pSelecttblSeason
            cboSeason.DisplayMember = "Season"
            cboSeason.ValueMember = "SeasonID"
            cboSeason.DataBindings.Add("SelectedValue",
DsSalesContractEdit.pSelectSalesContractBasic, "SeasonID")

My dataset is strongly typed, and my insert code works fine. Can anyone help
with this issue.

Thanks in advance

Nick