asp.net拼接 sqlserver 的in条件语句

[MR丶CHAN]

RT

select * from  test where code in 
('1','10','104','108','109','11','110','112','12','122')

用程序怎么拼出后面的in条件 求指教

[ParanoidKing]

System.Text.StringBuilder sb = new System.Text.StringBuilder();
foreach(int c in code)
{
    sb.AppendFormat("'{0}',", c);
}
sb.Remove(sb.Length-1);
string condition = sb.ToString();

[MR丶CHAN]

[Quote=引用 1 楼 的回复:]

C# code

System.Text.StringBuilder sb = new System.Text.StringBuilder();
foreach(int c in code)
{
sb.AppendFormat("'{0}',", c);
}
sb.Remove(sb.Length-1);
string condition = sb.ToString();
[/Quote]

code是从别的数据里查出来的，是一串字符 string code="1,10,11,104";

[ParanoidKing]

这种问题自己可以处理吧，我只是给你写个思路。把字符串转成数组就可以了啊
string[] code1 = code.Split(',');
foreach(string c in code1)
{
...
}
后面一样

[dalmeeme]

		string code = "1,10,11,104";
		string sqlStr = string.Format("select * from  test where code in ({0})", Regex.Replace(code, @"[^,]+", "'$0'"));
		Response.Write(sqlStr);

output：

select * from test where code in ('1','10','11','104')

[xiedwxy0625]

[Quote=引用 4 楼 的回复:]

C# code
string code = "1,10,11,104";
string sqlStr = string.Format("select * from test where code in ({0})", Regex.Replace(code, @"[^,]+", "'$0'"));
Response.Write(sqlStr);
……
[/Quote]

正确的，可以借鉴

[风一样的大叔]

[Quote=引用 4 楼 的回复:]

C# code
string code = "1,10,11,104";
string sqlStr = string.Format("select * from test where code in ({0})", Regex.Replace(code, @"[^,]+", "'$0'"));
Response.Write(sqlStr);
……
[/Quote]这个很简单

[康康]

把值接成列表
list<string> listaaa=null;
listaaa.add(x);listaaa.add(y);
然后 select * from test where code in listaaa;

刻我以前用过这种方法。