各位高手:
我遇到一个问题,在ListBox多选的前提下,将listbox中选中的项作为条件作sql语句
foreach (ListItem li in lbx_dep.Items)
{
if (li.Selected)
{
query_sql = "select bsm,xh,sjly,gslx,gsms,reason from cq_shjg where bsm='" + li.Value.ToString() + "'";
}
}
但这样取出来的只有一条记录的值,我怎么才能把全部选中的条目全取出来呀?请大家帮忙,这条sql我该如何写?
我遇到一个问题,在ListBox多选的前提下,将listbox中选中的项作为条件作sql语句
foreach (ListItem li in lbx_dep.Items)
{
if (li.Selected)
{
query_sql = "select bsm,xh,sjly,gslx,gsms,reason from cq_shjg where bsm='" + li.Value.ToString() + "'";
}
}
但这样取出来的只有一条记录的值,我怎么才能把全部选中的条目全取出来呀?请大家帮忙,这条sql我该如何写?
{
string str="";
if (li.Selected)
{
str +=li.value.ToString();
}
}
query_sql = "select bsm,xh,sjly,gslx,gsms,reason from cq_shjg where bsm='" + str.ToString() + "'";
str +=","+li.value.ToString();
}
str = str.Length==0?str.Substring(1):str;
query_sql =....
手误,不好意思!
foreach (ListItem li in this.ListBox1.Items)
{ if (li.Selected)
{
sb.Append("'"+li.Value+"',");
}
}
string query_sql = "select bsm,xh,sjly,gslx,gsms,reason from cq_shjg where bsm in ("+sb.ToString().TrimEnd(",".ToCharArray()) + ")";
{
string str="";
if (li.Selected)
{
if (str!="")
str +=","+li.value.ToString();
else
str=li.value.ToString();
}
}
query_sql = "select bsm,xh,sjly,gslx,gsms,reason from cq_shjg where bsm in "+str.Split(",");
foreach (ListItem li in this.ListBox1.Items)
{ if (li.Selected)
{
sb.Append("'"+li.Value+"',");
}
}
string query_sql = "select bsm,xh,sjly,gslx,gsms,reason from cq_shjg where bsm in ("+sb.ToString().TrimEnd(",".ToCharArray()) + ")";
===================bbs.shoucao.cn======================== QQ群:13827630 ,论坛bbs.shoucao.cn更会有想不到的收获 幸运草为大家提供控件源码下载,开源项目收集。===================bbs.shoucao.cn========================