摘要:
/// <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... 阅读全文
摘要:
--每页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. 阅读全文
摘要:
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 阅读全文