string ss=1|11|1; 将这些分解出来写成sql语句 像sql="select * form ss where s="+ ss +""
还是看不懂.string ss = "1|11|1"; 然后要求生成的SQL语句是什么样的?
我看大概是这样 把ss="1|2|3"解析成ss="1 or s=2 or s=3"不知道是不是这样的意思~ 下面提供答案 :)
class Test { static void Main() { string s = "1|2|3"; s = s.Replace("|", ","); string sql = string.Format("SELECT * FROM ss WHERE s IN ({0})", s); System.Console.WriteLine(sql); } }/* 程序输出: SELECT * FROM ss WHERE s IN (1,2,3) */
string[] str = str2.Split(',');
string strSql = "select * from " + str[0] +"where " + str[1];
将这些分解出来写成sql语句
像sql="select * form ss where s="+ ss +""
然后要求生成的SQL语句是什么样的?
把ss="1|2|3"解析成ss="1 or s=2 or s=3"不知道是不是这样的意思~
下面提供答案 :)
{
static void Main()
{
string s = "1|2|3";
s = s.Replace("|", ",");
string sql = string.Format("SELECT * FROM ss WHERE s IN ({0})", s);
System.Console.WriteLine(sql);
}
}/* 程序输出:
SELECT * FROM ss WHERE s IN (1,2,3)
*/