Passing datatable to a stored procedure

by

You can use a Table Valued Parameter as of SQL Server 2008 / .NET 3.5….

Check out the guide on MSDN

Also, as there other options available, I have a comparisonof 3 approaches of passing multiple values (single field) to a sproc (TVP vs XML vs CSV)

More Related Contents:

  1. Taking lot of time to read from SQL Server using c#
  2. I want to insert a record in DB and then need to return a row
  3. How do parameterized queries help against SQL injection?
  4. What is the syntax for an inner join in LINQ to SQL?
  5. How do I clean SqlDependency from SQL Server memory?
  6. Is it necessary to manually close and dispose of SqlDataReader?
  7. SQL WHERE clause matching values with trailing spaces
  8. DropdownList DataSource
  9. Entity Framework/SQL2008 – How to Automatically Update LastModified fields for Entities?
  10. Entity Framework/Linq to SQL: Skip & Take
  11. Does using parameterized SqlCommand make my program immune to SQL injection?
  12. Executing query with parameters
  13. C# Version Of SQL LIKE
  14. Use linq to generate direct update without select
  15. SqlConnection.Close() inside using statement
  16. Syncing SQL Server 2008 Databases over HTTP using WCF & Sync Framework
  17. Retrieve an object from entityframework without ONE field
  18. Join and Include in Entity Framework
  19. Table name and table field on SqlParameter C#?
  20. Get affected rows on ExecuteNonQuery
  21. Sql Bulk Copy/Insert in C#
  22. Calling SQL Defined function in C#
  23. Check if a SQL table exists
  24. When is it better to write “ad hoc sql” vs stored procedures [duplicate]
  25. Issues Doing a String Comparison in LINQ
  26. Use SQL Server time datatype in C#.NET application?
  27. 3 Digit currency code to currency symbol
  28. Generating sql code programmatically
  29. Do we have transactions in MS-Access?
  30. Is SqlConnection.Close() need inside a Using statement?

Leave a Comment