麦田

不积跬步无以至千里.

  博客园 :: 首页 :: 博问 :: 闪存 :: 新随笔 :: 联系 :: 订阅 订阅 :: 管理 ::

2012年11月27日

摘要: /// <summary> /// 验证邮件格式 /// </summary> /// <param name="email">邮件地址</param> /// <returns>是否匹配</returns> public bool Checkemail(String email) { String strExp = @"\w+([-+.]\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*"; Regex r = new R... 阅读全文
posted @ 2012-11-27 16:14 一些记录 阅读(621) 评论(0) 推荐(0)

摘要: --每页3条 第一页select * from (select *,row_number() over(order by pid desc) as num from Photos) as twhere num between 1 and 3 order by pid desc --每页3条 第二页select * from (select *,row_number() over(order by pid desc) as num from Photos) as twhere num between 4 and 6 order by pid desc --每页3条 第三页select * fr. 阅读全文
posted @ 2012-11-27 16:01 一些记录 阅读(232) 评论(0) 推荐(0)

摘要: SqlConnection con = new SqlConnection("连接字符串");SqlCommand cmd = new SqlCommand("SelectManStudent", con);SqlParameter parm = new SqlParameter("@Sex", SqlDbType.NVarChar);parm.Value = '男';//此处传性别cmd.Parameters.Add(parm);cmd.CommandType = CommandType.StoredProcedur 阅读全文
posted @ 2012-11-27 15:58 一些记录 阅读(191) 评论(0) 推荐(0)