09 2012 档案

摘要:今天遇到个问题. 首先插入一个DataTime格式的数据: string sql="insert into [table] (date_time) values('" + date_time.ToString() + "'"; 执行如上命令.插入没有报告错误.但是,我又用一条命令读取时: string sql="select * from [table]; ..... IDataReader dr=cmd.ExecuteReader(); ... object obj=dr["data_time"];//在这 阅读全文
posted @ 2012-09-25 16:40 +-/\-+ 阅读(345) 评论(0) 推荐(0)
摘要:using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Xml;namespace WEB{ /// <summary> /// Handler1 的摘要说明 /// </summary> public class Handler1 : IHttpHandler { public void ProcessRequest(HttpContext context) { context.Re... 阅读全文
posted @ 2012-09-21 14:49 +-/\-+ 阅读(1353) 评论(0) 推荐(0)
摘要:select top(10) * from T1 where Id >= (select MAX(Id) from (select top(20) * from T1 order by Id) as t) 阅读全文
posted @ 2012-09-07 17:18 +-/\-+ 阅读(1006) 评论(0) 推荐(0)