string selectedLeaveTypes = "";
foreach (ListItem item in chkLeaveType.Items)
{
if (item.Selected)
{
selectedLeaveTypes = selectedLeaveTypes + "'" + item.Value + "',";
}
}
selectedLeaveTypes = "(" +selectedLeaveTypes+ ")";
DataRow[] rows = dt.Select("LeaveType IN '" + selectedLeaveTypes + "'");
语法错误:必须通过逗号将关键字之后的项目分开并包含在括号中。
您在单引号中添加了SelecteLeaveType。删除它们
DataRow[] rows = dt.Select("LeaveType IN " + selectedLeaveTypes);
单个引号将您的整个变量值转换为单个大字符串。
您还需要删除变量
中的最终逗号selectedLeaveTypes = selectedLeaveTypes.TrimEnd(new char[] {','});
我还建议您删除该大字符串串联并使用最终字符串的List<string>
。
List<string> values = new List<string>()
foreach (ListItem item in chkLeaveType.Items)
{
if (item.Selected)
values.Add("'" + item.Value + "'");
}
DataRow[] rows = null;
// Consider that you should also handle the no selection status
if(values.Count == 0)
rows = dt.Select(); // ??
else
rows = dt.Select("LeaveType IN (" +
string.Join(",", values.ToArray() + ")");
var selectedLeaveTypes = "("+String.Join(",", chkLeaveType.Items.Where(item => item.Selected).Select(item => $"'{item.Value}'").ToArray())+")";
DataRow[] rows = dt.Select($"LeaveType IN {selectedLeaveTypes}");