select count(*) from (select distinct A.do_objid from C_Work_ObjDo as A, C_Work_ObjDo as B where A.do_objid=B.do_objid and A.do_method='刑拘' and A.do_step < B.do_step and B.do_method='起诉' and A.do_time between '2004-2-1 0:00:00' and '2009-10-1 0:00:00' and B.do_time between '2004-2-1 0:00:00' and '2009-10-1 0:00:00') as T
我想用 StringBuilder strSql = new StringBuilder();
StrSql.AppendFormat();
StrSql.Append();这样的格式来实现上面的sql语句,请问怎么写啊??望大狭们指点~~
我想用 StringBuilder strSql = new StringBuilder();
StrSql.AppendFormat();
StrSql.Append();这样的格式来实现上面的sql语句,请问怎么写啊??望大狭们指点~~
解决方案 »
- C# 会正则表达式的帮我写两个表达式,不胜感激!
- 关于SESSION失效的问题讨论
- 找不到类型或命名空间名称"Foosun"(是不是缺少using 指令或程序集引用?)
- VS2005在生成安装问题,急。。。。。。!!在线等待!
- 求助:如何使用.net写一个ActiveX,要求它可以嵌入word2010文档中而且保存后可以在此正常打开
- c++ 写的dll 导出 函数 xx_send(char* buf,int size),在 c#中怎么用
- 如何通过代理服务器访问Internet上的Sql server
- 大量高分收购C#源码
- Windows 服务程序 引入User32.DLL无效问题
- C# 串口编程
- C#中如何删除文本文件
- 在继承的组件中怎样引用自己,用base好象失败了
MSDN参考:using System;
using System.Text;
using System.Globalization;class Sample
{
static StringBuilder sb = new StringBuilder(); public static void Main()
{
int var1 = 111;
float var2 = 2.22F;
string var3 = "abcd";
object[] var4 = {3, 4.4, 'X'}; Console.WriteLine();
Console.WriteLine("StringBuilder.AppendFormat method:");
sb.AppendFormat("1) {0}", var1);
Show(sb);
sb.AppendFormat("2) {0}, {1}", var1, var2);
Show(sb);
sb.AppendFormat("3) {0}, {1}, {2}", var1, var2, var3);
Show(sb);
sb.AppendFormat("4) {0}, {1}, {2}", var4);
Show(sb);
CultureInfo ci = new CultureInfo("es-ES", true);
sb.AppendFormat(ci, "5) {0}", var2);
Show(sb);
} public static void Show(StringBuilder sbs)
{
Console.WriteLine(sbs.ToString());
sb.Length = 0;
}
}
/*
This example produces the following results:StringBuilder.AppendFormat method:
1) 111
2) 111, 2.22
3) 111, 2.22, abcd
4) 3, 4.4, X
5) 2,22
*/
StrSql.AppendLine("from (select distinct A.do_objid ");
StrSql.AppendLine("from C_Work_ObjDo as A,");
.
.
一直把你的SQl全部放倒里面去
return StrSql.Tostring();不知道是不是楼主要的?
string var1 = "";
string var2 = "";
string var3 = "";
string var4 = "";
string var5 = "";StringBuilder strSql = new StringBuilder(); StrSql.AppendFormat("select count(*) from (select distinct A.do_objid from C_Work_ObjDo as A, C_Work_ObjDo as B where A.do_objid=B.do_objid and A.do_method='{0}' and A.do_step < B.do_step and B.do_method='{1}' and A.do_time between {2} and {3} and B.do_time between {4} and {5}) as T",var0,var1, var2,var3, var4, var5); 一般不这么写吧,至少很少这么写的.常用直接传递参数SqlParameter @a,@b,@c (SqlParameter针对SQLSERVER),然后用strsql = "insert into tb(a,b,c) value (@a,@b,@c)"