110,538
社区成员
发帖
与我相关
我的任务
分享
time1 = dateTimePicker1.Text.Trim();
time2 = dateTimePicker2.Text.Trim();
string strAchievemen=@"
SELECT md , dm ,
reyj ,
reyjc ,
zyj
FROM MX
WHERE elcode = '0'
AND CONVERT(VARCHAR(10), tjrq, 120) >= '"+time1+"'
AND CONVERT(VARCHAR(10), tjrq, 120) <= '"+time2+"'
AND reyjc = dm
UNION ALL
SELECT md ,
dm ,
reyj ,
reyjc ,
zyj
FROM MXZXBGBF
WHERE elcode = '0'
AND CONVERT(VARCHAR(10), tjrq, 120) >='"+time1+"'
AND CONVERT(VARCHAR(10), tjrq, 120) <= '"+time2+"' ";
//string.Format好像必须写一行才行
string strAchievemen=string.Format ( "
SELECT md , dm ,
reyj ,
reyjc ,
zyj
FROM MX
WHERE elcode = '0'
AND CONVERT(VARCHAR(10), tjrq, 120) >= '{0}'
AND CONVERT(VARCHAR(10), tjrq, 120) <= '{1}'
AND reyjc = dm
UNION ALL
SELECT md ,
dm ,
reyj ,
reyjc ,
zyj
FROM MXZXBGBF
WHERE elcode = '0'
AND CONVERT(VARCHAR(10), tjrq, 120) >='{0}'
AND CONVERT(VARCHAR(10), tjrq, 120) <= '{1}' ",time1,time2);
string sql = "select column1,column2.... " //拼接时没行末尾或者开始带个空格
+ "from table1 t1,table t2... "
+ "where t1.id = t2.id .... " //where条件自己看情况断行即可
+ "and t1.name = '"+strName+"' "
+ "order by id desc ";
string strAchievemen = @"
SELECT md , dm ,
reyj ,
reyjc ,
zyj
FROM MX
WHERE elcode = '0'
AND CONVERT(VARCHAR(10), tjrq, 120) >= '" + time1 + @"'
AND CONVERT(VARCHAR(10), tjrq, 120) <= '" + time2 + @"'
AND reyjc = dm
UNION ALL
SELECT md ,
dm ,
reyj ,
reyjc ,
zyj
FROM MXZXBGBF
WHERE elcode = '0'
AND CONVERT(VARCHAR(10), tjrq, 120) >='" + time1 + @"'
AND CONVERT(VARCHAR(10), tjrq, 120) <= '" + time2 + @"' ";
一开始你会给字符串常量加 @
为什么到后来却又不会加了呢?
不加 @ 是不允许有换行的