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.
513
514
515
then when i do dataadapter.update, this is what appears in the DB
513
513
513.
Anyone have any ideas?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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.
513
514
515
then when i do dataadapter.update, this is what appears in the DB
513
513
513.
Anyone have any ideas?