Access数据里进行取数字操作时,则需要将单引号替换成“ ”(空字符)
判断是不是包含数字时,只需进行数字0-9的判断,具体代码如下:
for (int i = 0; i < condition.Length; i++)
{
if (condition[i] >= '0' && condition[i] >= '9')
{
condition = condition.Replace("'", " ");
sqlFormat = string.Format("select {0} from {1} where {2} ", fldname, tableName, condition);
}
}