DataView.RowFilter 问题

[yungboy]

DataView 中有多列，按照多列进行筛选

例如：第一列是时间，第二列是地点
用DataView 进行筛选
view.RowFilter="'"+str+"'<ttime and ttime<'"+end+"'or ttime='"+str+"'and cid2 = '"+this.drpManufacuter.SelectedValue+"'";其中ttime ,cid2 为列名，str,end 为字符串变量表示时间，this.drpManufacuter.SelectedValue为一个下拉列表的选种项，这样只能把能满足时间的行过虑掉'。and cid2 = '"+this.drpManufacuter.SelectedValue+"'" 不起作用了

[DeltaCat]

view.RowFilter="('"+str+"'<ttime and ttime<'"+end+"' or ttime='"+str+"') and cid2 = '"+this.drpManufacuter.SelectedValue+"'";

[godblessyU]

你先将this.drpManufacuter.SelectedValue替换成一个固定的值，然后运行程序，跟踪信息，如果通过，说明是this.drpManufacuter.SelectedValue的值有问题～～

[BoroSoft]

StringBuilder sbFilter = new StringBuilder();
sbFilter.AppendFormat(" ttime>'{0}' and ttime<'{1}' and cid2 ={2}",str,end,this.drpManufacuter.SelectedValue);
view.RowFilter = sbFilter.ToString();

[hawkalw]

= "('" + str + "'< ttime and ttime <'" + end + "' or ttime = '" + str + "') and cid2 = '" + drpManufacuter.SelectedValue + "'";

[yufenfeila]

right:

= "('" + str + "'< ttime and ttime <'" + end + "' or ttime = '" + str + "') and cid2 = '" + drpManufacuter.SelectedValue + "'";