Why can't my insertcommand get parameters automatically

qwer000

I don't see any code to add lines in your code
newrow just generates a new row
rows.add (row)
Did you really add the rows to the DataSet, you did not add the new rows to the ROWS collection, not in the DATASET, update a bird

lawrencearab

I re-posted the code with add in the back.

lawrencearab

In the re-pasted code, I used the tableadapter generated during the binding. I can check in the breakpoint that my adapter can get parameters, but I can't insert the parameters into the database.

614310

Try to take out the ID column in the instance of DataAdapter. When inserting a new row, manually set an ID and then update it. Pay attention to tracking the ID in the DataSet