摘要: /// <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 麦田HH 阅读(596) 评论(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 麦田HH 阅读(221) 评论(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 麦田HH 阅读(184) 评论(0) 推荐(0) 编辑