vs2013秘钥
Visual Studio Ultimate 2013 KEY(密钥):BWG7X-J98B3-W34RT-33B3R-JVYW9
Visual Studio Premium 2013 KEY(密钥):FBJVC-3CMTX-D8DVP-RTQCT-92494
Visual Studio Professional 2013 KEY(密钥): XDM3T-W3T3V-MGJWK-8BFVD-GVPKY
Team Foundation Server 2013 KEY(密钥):MHG9J-HHHX9-WWPQP-D8T7H-7KCQG
like参数化查询
like查询根据个人习惯将通配符写到参数值中或在SQL拼接都可,两种方法执行效果一样
参考
Sql Server参数化查询之where in和like实现详解http://www.cnblogs.com/lzrabbit/archive/2012/04/22/2465313.html#like
//将 % 写到参数值中
comm.CommandText = "select * from Users(nolock) where UserName like @UserName";
comm.Parameters.Add(new SqlParameter("@UserName", SqlDbType.VarChar, 200) { Value = "rabbit%" });
//SQL中拼接 %
comm.CommandText = "select * from Users(nolock) where UserName like @UserName+'%'";
comm.Parameters.Add(new SqlParameter("@UserName", SqlDbType.VarChar, 200) { Value = "rabbit%" });
js获取服务器控件d
var c = document.getElementById("ddpsfs").value;
button按钮绑定前台验证事件
btbuy.Attributes.Add("onclick ", "return check();");
前台
function check() {
try {
if (document.getElementById("ddpsfs").value == "0") {
alert("Please fill in the Delivery(请选择配送方式)");
return false;
}
if (document.getElementById("inconsignee").value == "") {
alert("Please fill in the consignee (请填写收货人)");
return false;
}
if (document.getElementById("intel").value == "") {
alert("Please fill in the Tel (请填写联系电话)");
return false;
}
if (document.getElementById("inadd").value == "") {
alert("Please fill in the Address(请填写配送地址)");
return false;
}
if (document.getElementById("inquantity").value == "") {
alert("Please fill in the Quantity(请填写购买数量)");
return false;
}
} catch (err) {
alert("Exception(系统异常)");
return false;
}
return true;
}