遇到点麻烦,大家帮看一下
string strDate1="";
string strSql=string.Format("select * from (select * ,convert(varchar(20),(select top 1 StartDate from Fee where Fee.UserId=BaseInfo.id order by id desc),111) as StartDate ,convert(varchar(20),(select top 1 endDate from Fee where Fee.UserId=BaseInfo.id order by id desc),111) as endDate,(select top 1 InvoiceNum from Fee where Fee.UserId=BaseInfo.id order by id desc) as InvoiceNum from BaseInfo) as c where c.UserType={0} and c.{1}",intType,strDate1);
strDate1=string.Format("BDate>='{0}' and c.BDate<='{1}'",startDate,endDate);DataSet ds=SqlHelper.ExecuteDataset(strSql);
设断点的时候,strDate1为“BDate>='2000' and c.BDate<='2050'”
但是ds里的strSql却总是“c.”后面都是空的,不知道问题在哪里,哪位高手指教?
string strDate1="";
string strSql=string.Format("select * from (select * ,convert(varchar(20),(select top 1 StartDate from Fee where Fee.UserId=BaseInfo.id order by id desc),111) as StartDate ,convert(varchar(20),(select top 1 endDate from Fee where Fee.UserId=BaseInfo.id order by id desc),111) as endDate,(select top 1 InvoiceNum from Fee where Fee.UserId=BaseInfo.id order by id desc) as InvoiceNum from BaseInfo) as c where c.UserType={0} and c.{1}",intType,strDate1);
strDate1=string.Format("BDate>='{0}' and c.BDate<='{1}'",startDate,endDate);DataSet ds=SqlHelper.ExecuteDataset(strSql);
设断点的时候,strDate1为“BDate>='2000' and c.BDate<='2050'”
但是ds里的strSql却总是“c.”后面都是空的,不知道问题在哪里,哪位高手指教?
解决方案 »
- BULK INSERT 大批量插入时如果只碰到少量错误,怎么能让db.ExecuteCommand(mycmd)不报错?
- 如何把 字符串值从”sxxxs.zip“ 变为”sxxxs.csv“
- 定义换行字符串时,报语法错误,怎么解决?
- 正则表达式截取问题
- 请问URL中存在2个"//"是怎么搞的??
- 如何读取EXCEL文件并转化为HTML代码
- 简易FLASH平台,支持动画拖拽的编程如何实现?
- 你的几分钟,会让祖国更强大!!!
- 如何在C#类中使用cookies
- 一个asp程序员的迷茫,路在何方,是.NET,还是JAVA ????????
- 请人做私单,我接了N个.NET的私单有兴趣的朋友加我QQ54460334
- 如何判断一个 string 中是否含有小数点"."
放到string strDate1="";的后面试试。
string strDate1="";
strDate1=string.Format("BDate>='{0}' and c.BDate<='{1}'",startDate,endDate);string strSql=string.Format("select * from (select * ,convert(varchar(20),(select top 1 StartDate from Fee where Fee.UserId=BaseInfo.id order by id desc),111) as StartDate ,convert(varchar(20),(select top 1 endDate from Fee where Fee.UserId=BaseInfo.id order by id desc),111) as endDate,(select top 1 InvoiceNum from Fee where Fee.UserId=BaseInfo.id order by id desc) as InvoiceNum from BaseInfo) as c where c.UserType={0} and c.{1}",intType,strDate1);
DataSet ds=SqlHelper.ExecuteDataset(strSql);