1.监听文本框值改变事件:
1 .用onchange() 表示使当前元素失去焦点onblur才能激活该事件
2 .用 onpropertychange() 当属性值改变时,通过该方法即时捕获
2.js日期添加指定天数
![](https://i-blog.csdnimg.cn/blog_migrate/81178cc93a2a3bb5048d90d76e7ec935.gif)
function addDaysTodate(mydate,days)
{
mydate.setDate(mydate.getDate() + days);
return mydate;
}
调用方法1:addDaysTodate( new Date(), 3 ); // 指定当前日期添加3天
调用方法2:addDaysTodate( new Date(Year,(month - 1 ),day), 3 ); // 指定的年月日添加3天
3.js 循环读取table中的值
var arr = document.getElementById( " tableid " );
for (var i = 0 ;i < arr.rows.length;i ++ ){
alert(arr.rows[i].cells[ 0 ].innerHTML); // 获取第0行0列值
}
4.sql server 修改数据库名称
exec sp_renamedb ' oldname ' ' newname '
5.div 单行文字垂直居中
设置它的实际高度height和所在行的高度line - height相等即可
div{height:30px;line - height:30px;overflow:hidden}
6. asp.net 时间比较
判断是否相等 Convert.ToDateTime( " 07/07/12 " ).CompareTo(DateTime.Now.ToString( " YY-MM-dd " ))
判断大小 if (DateTime.Now < DateTime.Now.AddDays( 3 )) // 判断当前时间与3天后时间比较
7.最简单三张表联合查询
select a.name b.id c.age from 表a as a ,表b as b ,表c as c where a = b and b = c
8.asp.net 最简单使用Cookie
设Cookie值 Response.Cookies[ " name " ].Value = " 值 " ;
取出Cookie值string s = Request.Cookies[ " name " ].Value.ToString();
9.asp.net 给datatable添加一行新数据
DataTable dt = server. get (); // 从数据库是查询
DataRow row = dt.newRow(); // 新建一行
row[ 0 ] = " 0 " ;row[ 1 ] = " 1 " ; // 填充数据
dt.Rows.Add(row); // 添加到dt中
10.js 生成table
![](https://i-blog.csdnimg.cn/blog_migrate/81178cc93a2a3bb5048d90d76e7ec935.gif)
var globalArrays = new Array();
function addTable(t,pre,sd,type,num,start,typeid,supp,rohs,proDate,size,allowRetCount){
var newItem; // 保存table值,便于后台操作
var table = document.getElementById( " tcontent " );
var oBody = table.tBodies[ 0 ];var rowIndex = oBody.rows.length;
oBody.insertRow(rowIndex);
if (t % 2 == 0 ) // 给奇偶行添加样式{ oBody.rows[rowIndex].className="odd";}
else { oBody.rows[rowIndex].className = " enen " ;} // 序号
oBody.rows[rowIndex].insertCell( 0 );
oBody.rows[rowIndex].cells[ 0 ].appendChild(document.createTextNode(t + 1 ));
oBody.rows[rowIndex].cells[ 0 ].noWrap = true ;newItem = (t + 1 ); // 条码
oBody.rows[rowIndex].insertCell( 1 );
var v = pre + " - " + (parseInt(start) + t);
oBody.rows[rowIndex].cells[ 1 ].appendChild(document.createTextNode(v));
oBody.rows[rowIndex].cells[ 1 ].noWrap = true ;newItem = newItem + " , " + v; // 类型
oBody.rows[rowIndex].insertCell( 2 );
oBody.rows[rowIndex].cells[ 2 ].appendChild(document.createTextNode(type));
oBody.rows[rowIndex].cells[ 2 ].noWrap = true ;newItem = newItem + " , " + type; // 批号
oBody.rows[rowIndex].insertCell( 3 );
oBody.rows[rowIndex].cells[ 3 ].appendChild(document.createTextNode(num));
oBody.rows[rowIndex].cells[ 3 ].noWrap = true ; newItem = newItem + " , " + num; // 保质日期5oBody.rows[rowIndex].insertCell(4);
oBody.rows[rowIndex].cells[ 4 ].appendChild(document.createTextNode(sd));
oBody.rows[rowIndex].cells[ 4 ].noWrap = true ; newItem = newItem + " , " + sd;
newItem = newItem + " , " + typeid + " , " + supp + " , " + rohs + " , " + proDate + " , " + size + " , " + allowRetCount;globalArrays.push(newItem);
}
11.JS清空table
![](https://i-blog.csdnimg.cn/blog_migrate/81178cc93a2a3bb5048d90d76e7ec935.gif)
function clear(){
var table = document.getElementById( " tid " );
var oBody = table.tBodies[ 0 ];
var leng = oBody.rows.length;
for (var i = leng;i >= 1 ;i -- ){
// 注意table下标是从0开始,且0行是title,所以不能删除 ,而且还要倒着删除
table.deleteRow[i];
}