How do I translate a List into a SqlParameter for a Sql In statement? [duplicate]

by

You could try something like this:

string sql = "SELECT dscr FROM system_settings WHERE setting IN ({0})";
string[] paramArray = settingList.Select((x, i) => "@settings" + i).ToArray();
cmd.CommandText = string.Format(sql, string.Join(",", paramArray));

for (int i = 0; i < settingList.Count; ++i)
{
    cmd.Parameters.Add(new SqlParameter("@settings" + i, settingList[i]));
}

More Related Contents:

  1. How can I add user-supplied input to an SQL statement?
  2. How to use DbContext.Database.SqlQuery(sql, params) with stored procedure? EF Code First CTP5
  3. Pass table valued parameter using ADO.NET
  4. When should “SqlDbType” and “size” be used when adding SqlCommand Parameters?
  5. Under what circumstances is an SqlConnection automatically enlisted in an ambient TransactionScope Transaction?
  6. Is it necessary to manually close and dispose of SqlDataReader?
  7. How to save image in database using C# [closed]
  8. SqlBulkCopy from a List
  9. Is SqlCommand.Dispose() required if associated SqlConnection will be disposed?
  10. Insert into C# with SQLCommand
  11. How to run multiple SQL commands in a single SQL connection?
  12. How to fill Dataset with multiple tables?
  13. ExecuteNonQuery returning -1 when using sql COUNT despite the query string
  14. Add WHERE clauses to SQL dynamically / programmatically
  15. Check if a SQL table exists
  16. Enabling Foreign key constraints in SQLite
  17. C# SQL insert command
  18. How do I extract data from a DataTable?
  19. How can I Pass a Table Name to SqlCommand?
  20. How to give ADO.NET Parameters
  21. Do we have transactions in MS-Access?
  22. how to get date difference between two dates using DateDiff Excluding the weekends [duplicate]
  23. C# Data Connections Best Practice?
  24. Calling stored procedure with return value
  25. Difference with Parameters.Add and Parameters.AddWithValue
  26. Code to validate SQL Scripts
  27. Application can’t scaffold items
  28. ALTER TABLE DROP COLUMN failed because one or more objects access this column
  29. Anonymous type result from sql query execution entity framework
  30. Calling a SQL User-defined function in a LINQ query

Leave a Comment