摘要:
string sql = "select * from [product] where 1=1"; //商品名称不为空 if (shopName != "") { sql += " and [proName]='" + shopName + "'"; } //商品编号不为空 ...
阅读全文
posted @ 2008-05-24 16:25
freexiaoyu
阅读(2360)
推荐(1)
编辑
摘要:
select datediff(hh,'2008-05-24 13:25:16.857',GetDate()) as 小时 from [user] where UserName'123'
阅读全文
posted @ 2008-05-24 13:57
freexiaoyu
阅读(495)
推荐(0)
编辑
摘要:
DateTime dt = Convert.ToDateTime(this.TextBox1.Text); DateTime de = Convert.ToDateTime(this.TextBox2.Text); System.TimeSpan ts = dt.Subtract(de); this.Label1.Text = "天" + ts...
阅读全文
posted @ 2008-05-24 11:34
freexiaoyu
阅读(2916)
推荐(0)
编辑
摘要:
#region 事件:设定一级类别初始值 protected void DropClassType_DataBound(object sender, EventArgs e) { DropClassType.Items.Insert(0, new ListItem(" ", " ")); DropClassType.Text = " "; }...
阅读全文
posted @ 2008-05-24 11:33
freexiaoyu
阅读(428)
推荐(0)
编辑