去掉字符串末位的标点

[a5015576]

string sendID = categoryID.ToString() + ",";
用户选择一个或多个categoryID,然后输出,我想把最后的一个逗号去掉,其它的留下,我用
sendID = sendID.Substring(0, sendID.LastIndexOf(","));结果全都去掉了.
例:用户选择13579的选项,输出应该为:1,3,5,7,9
而现在我的输出为1,3,5,7,9,

还有另一个问题,SQL查询语句
dbcom_send = db.GetSqlStringCommand("select Tel from TS_DOWN where downID in "("'@sendID'")" '");
是不是得加括号?

[笑道江湖情]

str=str.TrimEnd(',');

[小童]

s.Substring(0,s.Length - 1)

[快溜]

sendID = sendID.Substring(0, sendID.length-1);
"select Tel from TS_DOWN where charindex(downID+',',@sendID+',')>0"

[小童]

downID in (1,2,3,4)

[子夜__]

Substring(0, sendID.LastIndexOf(","))

这里的0是起始位置。


string str = "1,3,5,7,9,";
Response.Write(str.Substring(0, str.Length - 1));

[zhenze0]

sendID = sendID.Substring(0, sendID.LastIndexOf(",")-1)


第二个
得加括号，好像不用加单引号吧

[消失的尘芥]

str.Length - 1为最后一个字符

[shiyuyao1987]

 if (sendID.EndsWith(","))
            {
                sendID = sendID.Substring(0, sendID.Length - 1);
            }

charindex(','+cast(downID as varchar)+',',','+@sendID+',')>0

[qq346127416]

TrimEnd(',')最省事

[wlf535944903]

[Quote=引用 9 楼 qq346127416 的回复:]
TrimEnd(',')最省事
[/Quote]
+1
直接这样就行了啊

[回头是岸]

[Quote=引用 9 楼 qq346127416 的回复:]
TrimEnd(',')最省事
[/Quote]

[qq346127416]

string sql = string.Format("select Tel from TS_DOWN where downID in ({0})",sendID);

[IE11下面经常卡到爆]

[Quote=引用 1 楼 tao145 的回复:]
str=str.TrimEnd(',');
[/Quote]

++

[cm_boy]

TrimEnd(',')最省事