John Baird
Coatesville, Pennsylvania, United States
>>Hi, Dmitry, in SQL 2008 you can now pass an ADO.NET datatable to a stored proc.
>>
>>I don't know about a datarow (haven't tried it)...but worst case is you'd need to create a 1-row datatable.
>
>Hi Kevin,
>I am using SQL 2005 for the project I am working on (per customer's spec). I guess I will have to 'manually' create a dataset/datatabe of 1 row and pass it to the stored procedure. Another idea I have is to create a ArrayList of pairs (column name and value) and pass it to the stored procedure. This way I can create somewhat a generic procedure for updating. But I don't know if ArrayList type can be read by stored procedure.
>
>Thank you.
We only take the changes, bundle it into a datatable and update ... I believe the process also uses diffgrams..
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only