ADO.net Arrays of Parameters

Go back to: Code Samples

sql = "INSERT INTO employees VALUES (?, ?, ?)";
cmd.CommandText = sql;
cmd.ArrayBindCount = 10;
cmd.Prepare();
cmd.Parameters[0].Value = idArray;
cmd.Parameters[1].Value = nameArray;
cmd.Parameters[2].Value = salaryArray;
cmd.ExecuteNonQuery();

Like what you see? Share and Enjoy:

Buy the Book

This book is for software architects, IT staff, DBAs, and developers to use in their daily work to predict, diagnose, and solve performance issues in their database applications.

ADO.net Arrays of Parameters

Buy the Book

Get Connected

Corporate Sponsor

News and Announcements...

Brent Ozar – SQL Server DBA, "What’s On My Bookshelf?" September 28, 2009

ebizQ, “Data Access in SOA Environments,” Sept. 9, 2009

Enterprise Systems Journal, “Achieving Optimal Database Application Performance: Benchmark Tips and Techniques,” Sept. 8, 2009

Desicritics.org, Biz/Tech, "Book Review, The Data Access Handbook - Achieving optimal database application performance and scalability," July 5, 2009

TechRepublic, Programming and Development, “Book review: The Data Access Handbook offers database performance tips,” June 16th, 2009

Developer Snippets, “Data Access Handbook provides solutions to applications run faster and stronger,” May 16, 2009

SQLServerCentral.com, “The Data Access Handbook – Sample Chapter,” May 15, 2009

IT Knowledge Exchange “IT Bookworm: “Tuning Database Applications for Performance,” May 14, 2009

Dr. Dobb’s Journal, “This Week’s Developers Reading List,” May 7, 2009

Sybase Blog, “I’d Rather Play Golf: Book Review on The Data Access Handbook,” April 21, 2009