只是在于积累

silverlight

 http://www.msdnwebcast.com/webcast/2098.aspx

http://www.cnblogs.com/gaoweipeng/archive/2009/04/07/1430750.html

 

 

http://www.yesky.com/imagesnew/software/tsql/ts_sys_00_690z.htm

http://hi.baidu.com/fujunhua258/blog/item/2e57d254c036a2153b2935df.html

http://bbs.blueidea.com/viewthread.php?tid=2948279

 

net【oracle】

解决一次执行多条数据

http://www.oracle.com/technology/global/cn/sample_code/tech/windows/odpnet/howto/arraybind/index.html

http://blog.163.com/jasonama@126/blog/static/8375969200932223991/

 1. “”字符转义：

string s="select t1.target_id,0 as \"30-50\"  from mggpsdata.g20100227 t1 where t1.target_id='123'";

 

2.一个空格引发的血案

       select target_date,target_speed,speed_limit from (
        select t1.target_date, t1.target_speed,(case 
                                          when t1.target_speed between 10 and 15 then '10-15'                                
                                          when t1.target_speed between 80 and 100 then '80-100'
                                          when t1.target_speed between 120 and 150 then '120-150'                                   
                                          end)speed_limit
                    from MGGPSDATA.g20100226  t1   where t1.target_id='89251BF84BBF47C6AC1FE36F85C0195A' 
                   ) where speed_limit<> '     '

之前，写的speed_limit<> ' '查出来为0.【应该有50条数据】。整了半天是''之间没有空格所致

 

3.rownum 分页的时候作用很大

 

像张红莲大大地学习.....

 

4.一个0引发的血案...

 http://www.cnblogs.com/haojianwei/archive/2010/03/02/1676707.html

5.  .net 中文传值乱码解决方式【20100621】

  webconfig文件中

 <system.web>节点下添加：

  <globalization requestEncoding="gb2312" responseEncoding="gb2312"/>

 

 

6.[20100624]

服务器积极拒绝

查看webconfig配置中的wcf引用路径（可能和引用服务器配置路径不同，改成当前引用路径）

7. this.btnCancle.Attributes.Add("onclick", "window.opener=null;window.close();");

8.[20100701]

 function checkSIM(simTextBox) {
           // var simCheck = /^(((13[0-9]{1})|159|(15[0-9]{1}))+\d{8})$/;
            var simCheck = /^(((13[0-9]{1})|159|(15[0-9]{1})|(18[0-9]{1}))+\d{8})$/;
            var sim = document.getElementById(simTextBox).value;
            if (sim.length > 0) {
                if (isNaN(sim)) {
                    alert("SIM卡必须是全数字");
                    document.getElementById(simTextBox).focus();
                    return;
                }
                if (sim.length < 11) {
                    alert("SIM卡长度为11位！");
                    document.getElementById(simTextBox).focus();
                    return;
                }
                if (!simCheck.test(sim)) {
                    alert("非法手机号！");
                    document.getElementById(simTextBox).focus();
                    return;
                }
            }
        }

 右击文件夹-属性-安全-添加-添加-立即查找-选择Network Service-确定-完全控制-确定

 

20100724

1。gridview 绑定后改变表头

 this.gvShow.HeaderRow.Cells[5].Text = DateTime.Parse(this.txtTimeFrom.Text).ToString("MM.dd")

 

20100728

用户丢失session问题

solutions：

one  page【eg：A.aspx】 to  extend System.Web.UI.Page，and  the page override  the             On_Load method of   UI.Page 。THE LAST, ALL PAGE TO EXTEND THE A PAGE.

 

20100729

设置magrin，padding，border为0,依然有间隙,

solution:border="0" cellspacing="0" cellpadding="0"

 

20100809

js关闭窗口

1.打开新窗口的时候关闭自身【单个页面】：

  window.open('http://10.52.88.102:8008/login.aspx?username=' + name + '&password=' + pwd);
                        window.opener = null;
                        window.open("", "_self");
                        window.close();

2.打开新窗口的时候关闭自身【Iframest框架】

     window.parent.close();

 

转载于:https://www.cnblogs.com/liuwanlin/archive/2010/08/10/1796368.html