datagridview, stored procedure, and multiple rows
I want to use a stored procedure to insert/edit/delete records in a dgv. I am used to handling one row at a time with a sproc. However, I do like the tableadapter.update being able to handle multiple records. I have been doing some digging around and the only thing I can find about using sprocs and dgv is looping through the rows, exec the sproc for each row. I don't want to use the update method because I have to generate a unique ID for the user, and I worry about conflicts. For instance, I could use the dvg DefaultValuesNeeded event, but multiple users will have the app open at one time, and here they tend to leave things open around here without committing thier work. Anyway, my question is: is there a way to pass multiple rows to a sproc in .net (without looping through the rows). I can't seem to find examples if they exist.
thanks.
