js常用正则表达式

手机电话号码:/(^[0-9]{3,4}\-[0-9]{7,8}$)|(^(13\d|15[89])[0-9]{8}$)/;
数字：
[0-9]+$

英文字母：
^[A-Za-z]+$

匹配由数字、26个英文字母或者下划线组成的字符串：
^\w+$

固定电话：
\d{3,4}[-]d{7,8}[-]\d{0,1}
(\d{3}-)?\d{8}|(\d{4}-)(\d{7})

27种格式电话：
(^(\d{2,4}[-_－—]?)?\d{3,8}([-_－—]?\d{3,8})?([-_－—]?\d{1,7})?$)|(^0?1[35]\d{9}$)

字符串长度范围：
(.|\n){3,10}

格式化字符串：
([Number]+right('000000'+cast([ID] as varchar),6))

jxcti: 218.65.113.57

svn
username:vs
password:vs


1.Visual Studio 2008 Professional Edition:
XMQ2Y-4T3V6-XJ48Y-D3K2V-6C4WT （本人亲自测试，确实可用）

2.Visual Studio 2008 Team Test Load Agent:
WPX3J-BXC3W-BPYWP-PJ8CM-F7M8T

3.Visual Studio 2008 Team System:
PYHYP-WXB3B-B2CCM-V9DX9-VDY8T

4.Visual Studio 2008 Team Foundation Server:
WPDW8-M962C-VJX9M-HQB4Q-JVTDM

----------------------------------------------------------
分页SELECT m~n 条记录:
SELECT TOP n-m+1 *
  FROM Table
  WHERE (id NOT IN (SELECT TOP m-1 id FROM Table )) 

Start Row Index = (PageSize * PageIndex) + 1
Maximum Rows
= Count(*) % PageSize or = PageSize
LastPage = Count(*) / PageSize + 1

----------------------------------------------------------
Scott Mitchell 的ASP.NET 2.0数据教程之

Learning C++ as a New Language、《C++ Primer》第四版、《C++编程规范》、《Accelerated C++》和《C++必知必会》

http://bbs.topsage.com/dispbbs.asp?boardID=121&ID=177763

----------------------------------------------------------
划词翻译：
dict.cn

fileupload:
http://leo43.blog.hexun.com/10308565_d.html

http://leo43.blog.hexun.com/10383387_d.html

http://blog.csdn.net/dzz1001/archive/2008/01/09/2031381.aspx

http://www.dezai.cn/Article_Show.asp?ArticleID=15602&ArticlePage=1


select len('中英文abc')      ---结果是6
select datalength('中英文abc')        ---结果是9
select cast('中英文abc' as char(5))     ---结果是“中英”，会自动避免半个汉字出现
select cast('中英文abc' as char(7))     ---结果是“中英文a”，可有效的截取中英文

http://www.microsoft.com/china/community/Column/49.mspx

------------------------------------------------------------
分页gridview pager

http://www.cnblogs.com/jeffery19830101/archive/2008/01/02/1022768.html

<PagerTemplate>
    <asp:Label ID="lblPage" runat="server" Text="Page:" ForeColor="blue"></asp:Label>
    <asp:Label ID="lblCurrentPage" runat="server" Font-Bold="true" Text="<%# ((GridView)Container.NamingContainer).PageIndex + 1 %>"
        ForeColor="red"></asp:Label>/
    <asp:Label ID="lblPageCount" runat="server" Font-Bold="true" Text="<%# ((GridView)Container.NamingContainer).PageCount %>"
        ForeColor="black"></asp:Label>       
    <asp:LinkButton ID="lbtnFirstPage" runat="server" CommandName="Page" CommandArgument="First" Text="First"
        Enabled="<%# ((GridView)Container.NamingContainer).PageIndex != 0 %>"></asp:LinkButton>
    <asp:LinkButton ID="lbtnPreviousPage" runat="server" Enabled="<%# ((GridView)Container.NamingContainer).PageIndex != 0 %>" Text="Prev"
        CommandName="Page" CommandArgument="Prev"></asp:LinkButton>
    <asp:LinkButton ID="lbtnNextPage" runat="server" CommandName="Page" CommandArgument="Next" Text="Next"
        Enabled="<%# ((GridView)Container.NamingContainer).PageIndex != ((GridView)Container.NamingContainer).PageCount - 1 %>"></asp:LinkButton>
    <asp:LinkButton ID="lbtnLastPage" runat="server" CommandName="Page" CommandArgument="Last" Text="Last"
        Enabled="<%# ((GridView)Container.NamingContainer).PageIndex != ((GridView)Container.NamingContainer).PageCount - 1 %>"></asp:LinkButton>       
</PagerTemplate>
<PagerStyle CssClass="GridPager"  HorizontalAlign="Center"/>

-----------------------------------------------------------
HttpUtility.HtmlEncode()
protected void Page_Error(object sender, EventArgs e)
{
    Exception ex = Server.GetLastError();
    if (ex is HttpRequestValidationException)
    {
        Response.Write("请您输入合法字符串。");
        Server.ClearError(); // 如果不ClearError()这个异常会继续传到Application_Error()。
    }
}

http://www.cnblogs.com/panshuiqing/articles/792148.html

http://www.microsoft.com/taiwan/msdn/columns/huang_jhong_cheng/ASP_NET_GridView.htm

-----------------------------------------------------------
"^(([a-zA-Z]:)|(\\{2}\w+)\$?)(\\(\w[\w].*))+(.jpg|.Jpg|.gif|.Gif)$"

-----------------------------------------------------------------
http://www.busfly.cn/CSDN/post/MySQL-show-get-database-info.html

http://blog.sina.com.cn/s/blog_55e15433010007ci.html

文件格式过滤器：
^(([0-9a-zA-Z]:)|(\\{2}\w+)\$?)(\\(\w[\w].*))(.jpg|.JPG)$