08 2011 档案

excel 导入SQL
摘要:一、在程序中,用 ADO.NET。代码如下: //连接串 string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties=Excel 8.0;Data Source=" + [EXCEL文件,含路径] + ";"; OleDbConnection conn = new OleDbConnection(strConn); conn.Open(); DataTable dtSchema = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Table 阅读全文

posted @ 2011-08-24 09:35 缘来 阅读(203) 评论(0) 推荐(0)

身份证号码验证
摘要:<head runat="server"> <title>无标题页</title> <script type='text/javascript' src='JS.js'></script></head><body> <form id="form1" runat="server"> <div> 请输入身份证号码: <input name='card_no' type=' 阅读全文

posted @ 2011-08-08 14:01 缘来 阅读(680) 评论(0) 推荐(0)

正则表达式集锦
摘要:if (Regex.IsMatch(string input, string pattern)) stringphone=@"^(13[0-9]|15[0-9]|18[0|2|5|6|7|8|9])\d{8}$"; //手机号码 string email = @"\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*";//E_mail stringcardID1s = @"^[1-9]\d{7}((0\d)|(1[0-2]))(([0|1|2]\d)|3[0-1])\d{3}$";//15位 阅读全文

posted @ 2011-08-03 14:41 缘来 阅读(154) 评论(0) 推荐(0)

滚动显示图片
摘要:<div id="www_qpsh_com" style="overflow:hidden;height:278px;width:949px; margin-left:50px;"><table cellspacing="0" cellpadding="0" style="width: 680px; border :0px;"><tr><td id="www_qpsh_com1" ><table style="b 阅读全文

posted @ 2011-08-02 12:42 缘来 阅读(175) 评论(0) 推荐(0)

javascript 获取焦距触发按钮事件
摘要:<script type="text/javascript"> document.onkeydown=function(e) { e=e?e:window.event; var keyCode=e.which?e.which:e.keyCode; if(keyCode==13) { if(document.getElementById("tbxName").value == "") { document.getElementById("tbxName").focus(); } else if(docum 阅读全文

posted @ 2011-08-01 12:52 缘来 阅读(336) 评论(0) 推荐(0)

导航