我怎么能提供一个列表< INT>到SQL参数？ [英] How can I supply a List<int> to a SQL parameter?

问题描述

我有类似下面的SQL语句：

I have a SQL statement like the following:

...
const string sql = @"UPDATE PLATYPUS
SET DUCKBILLID = :NEWDUCKBILLID
WHERE PLATYPUSID IN (:ListOfInts)";
...
ocmd.Parameters.Add("ListOfInts", ??WhatNow??);

我如何提供整数的逗号分隔的列表，这可能是任何（合理*）号值

How can I provide the comma separated list of ints, which could be any (reasonable*) number of values

• 将在这种情况下我一个，一对夫妇打的意思是合理的。

推荐答案

更新：作为拉塞指出，你不能达到什么克莱尝试使用下面的方法做。虽然这并处于昏迷状态通过分离它不会按预期执行的数字列表。不幸的是，我不能删除，因为它是公认的答案

UPDATE: As Lasse points out you can't achieve what Clay is trying to do using the method below. While this does pass in a coma separated list of numbers it isn't going to execute as expected. Unfortunately I can't delete this since it's the accepted answer.

尝试是这样的：

ocmd.Parameters.Add("ListOfInts", String.Join(",",myList.ToArray());

的

的的string.join 方法将数组中的所有元素，并将它们之间的指定字符。

The String.Join method takes all elements in an array and places the specified character between them.

这篇关于我怎么能提供一个列表< INT>到SQL参数？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！