Multiple insert in single roundtrip with Sqlcommand, Possible???
-
My application has one web form where admin can add as many users as desired and at the end when he press SaveChanges I want to add all of them to database, There should be some way to pass arrays to stored procedure..I am looking for it or something similar to this.... Any Ideas!!! Thanks in advance... MaulikCE
-
My application has one web form where admin can add as many users as desired and at the end when he press SaveChanges I want to add all of them to database, There should be some way to pass arrays to stored procedure..I am looking for it or something similar to this.... Any Ideas!!! Thanks in advance... MaulikCE
No, you can't pass an array. What you should do is open your connection and loop through array of users. Set the new parameter value and execute. Why would you need to pass an array? "People who never make mistakes, never do anything." My blog http://toddsnotsoamazinglife.blogspot.com/
-
No, you can't pass an array. What you should do is open your connection and loop through array of users. Set the new parameter value and execute. Why would you need to pass an array? "People who never make mistakes, never do anything." My blog http://toddsnotsoamazinglife.blogspot.com/
ToddHileHoffer wrote: Why would you need to pass an array? I've had many occasions where I want to pass an array into a stored procedure so that it can perform all the actions in one pass rather than take serveral calls to the server.
My: Blog | Photos | Next SQL Presentation WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More
-
My application has one web form where admin can add as many users as desired and at the end when he press SaveChanges I want to add all of them to database, There should be some way to pass arrays to stored procedure..I am looking for it or something similar to this.... Any Ideas!!! Thanks in advance... MaulikCE
-
My application has one web form where admin can add as many users as desired and at the end when he press SaveChanges I want to add all of them to database, There should be some way to pass arrays to stored procedure..I am looking for it or something similar to this.... Any Ideas!!! Thanks in advance... MaulikCE