- 博客(4)
- 资源 (6)
- 收藏
- 关注
转载 动态SQL
Sample1:/* Variable Declaration */DECLARE @EmpID AS SMALLINTDECLARE @SQLQuery AS NVARCHAR(500)/* Build and Execute a Transact-SQL String with a single parameter value Using EXECUTE Command */SET @
2009-11-26 20:58:00 388
原创 File Download Tips for asp.net
use http header protected void Page_Load(object sender, EventArgs e) { string format = Convert.ToString(ViewData["format"]); Response.AddHeader("Content-D
2009-11-23 22:37:00 497
原创 SQL:如何把多行查询结果,作为一行返回
CREATE FUNCTION dbo.UF_GetInvoiceSerials( @bizCode VARCHAR(10)) RETURNS VARCHAR(100)ASBEGIN DECLARE @ret AS VARCHAR(1000) SELECT @ret=Coalesce(@ret + , ,) + CASE e.ID
2009-11-23 22:33:00 3299
原创 一段不太难写的简单条件绑定表达式
Eval("Workflow_StateName").ToString().Trim() == "待入账" ?string.Format("打印报销单 ",DataBinder.Eval(Container.DataItem, "BusinessCode")) : "N/A"%> Eval("Workflow_StateName").ToString().Trim() == "待入账"
2009-11-14 15:08:00 425
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人