I have created an insert statement using parameters
from a dataset that has been passed into this function.
When I add the command to the dataAdapter, all the
columns are matched up with source columns correctly,
but when it does the actual update to teh
database....whatever the first record was in the table
i'm about to insert... it repeats the first row on top of all
the other rows.
ie. if there was one column in the datatable before
updating.. it'd have these records.
then when i do dataadapter.update, this is what
appears in the DB
Anyone have any ideas?
This is the InsertCommand:
INSERT INTO t_35(DATA_ITEM, RESOURCE_NAME,
OPR_DATE, INTERVAL_NUM, VALUE, StatID) VALUES
(@DATA_ITEM, @RESOURCE_NAME, @OPR_DATE,
@INTERVAL_NUM, @VALUE, @StatID)