C
Craig Buchanan
I created a TableAdapter (TA) in my VB 2005 project. I tested it to ensure
that its CRUD functionality is what I expected it to be.
I'm using the TA and its strongly-typed DataTable (DT) in my Wizard.
Initially, I populate the DT using the TA.GetData.
I pass the DT to a ASCX-styled control that 'pivots' (turns years into
columns) the data into a new DataTable (DT2), then binds it (DT2) to a
GridView form. I save the original DT in the viewstate. So far so good.
When I want to save the data, I compare the values in GridView to the DT
that has been retrieve from the viewstate. The DT's rows are modified
accordingly. So far so good.
However, when I attempt to use the TA's Update method, passing the DT, I get
an error about a missing parameter. I'm assuming that the parameter's value
is supplied by the field that has a matching name. I've noticed that each
row has a value in this field.
What am I missing here?
Another oddity, perhaps. If don't make an changes in the pivot grid, there
won't be any changes to the DT. Why is it that the each row's rowstate is
'modified'? Could this be related my the Update issue?
Thanks in advance.
Craig Buchanan
that its CRUD functionality is what I expected it to be.
I'm using the TA and its strongly-typed DataTable (DT) in my Wizard.
Initially, I populate the DT using the TA.GetData.
I pass the DT to a ASCX-styled control that 'pivots' (turns years into
columns) the data into a new DataTable (DT2), then binds it (DT2) to a
GridView form. I save the original DT in the viewstate. So far so good.
When I want to save the data, I compare the values in GridView to the DT
that has been retrieve from the viewstate. The DT's rows are modified
accordingly. So far so good.
However, when I attempt to use the TA's Update method, passing the DT, I get
an error about a missing parameter. I'm assuming that the parameter's value
is supplied by the field that has a matching name. I've noticed that each
row has a value in this field.
What am I missing here?
Another oddity, perhaps. If don't make an changes in the pivot grid, there
won't be any changes to the DT. Why is it that the each row's rowstate is
'modified'? Could this be related my the Update issue?
Thanks in advance.
Craig Buchanan