一点点进步

str=str.replace(/\"/g,"");//正则去除字符串中的双引号

//用正则取地址栏参数
        function GetQueryString(name) {
            var reg = new RegExp("(^|&)" + name + "=([^&]*)(&|$)");
            var r = window.location.search.substr(1).match(reg);
            if (r != null) return unescape(r[2]); return null;
        }

//限制文本框只能输入double类型数据

//限制文本框只能输入整形

//只能输入数字(正整数)
function chkPrice(obj) {
obj.value = obj.value.replace(/[^\d]/g, "");
}

1.Server.MapPath("../treejquery/demo/treegrid_data.aspx") //Server.MapPath里面是放文件的相对路径

2.文件流的操作

            FileStream fs = new FileStream(Server.MapPath("../treejquery/demo/treegrid_data.aspx"), FileMode.OpenOrCreate);//文件流
            //编码格式 System.Text.Encoding.GetEncoding("GB2312")一般不容易出现乱码问题
            Byte[] info = System.Text.Encoding.GetEncoding("GB2312").GetBytes(hidjson.Value);//string与byte[]相互间转换
            fs.Write(info, 0, info.Length); //将文件内容写入文件
            fs.Flush();//刷新文件清除缓存流
            fs.Close();//关闭

3.var _html=document.getElementById("testexcel").outerHTML; //获取包含当前操作的html代码
$("#testexcel").html() //只能获取当前操作的子节点的html

//向DataSet中添加多个DataTable
4.
DataSet ds=new DataSet();
DataTable dt1 =new DataTable();
dt1.TableName = "new";
ds.Tables.Add(dt1.Copy());
DataTable dt2=new DataTable();
dt2.TableName="new2";
ds.Tables.Add(dt2.Copy());

5.distinct sqlserver数据库不重复数据关键字

6.string AllSubSort = "asdf123><dddddd126"; //正则取字符串中的数字并用逗号隔开
string strRet = "";
string pattern = "\\d+";

            MatchCollection matchs = Regex.Matches(AllSubSort, pattern);
            if (matchs != null)
            {
                foreach (Match match in matchs)
                {
                    if (match != null)
                        strRet += match.Groups[0].ToString() + ",";// +match.Groups["key"].Value;
                }
            }
            string[] ar = strRet.Split(new char[] { ',' });
            this.TextBox1.Text = strRet;

7.XML对数据的操作并将table转换为dataset

str = "<?xml version=\"1.0\" standalone=\"yes\"?>" + "<table>" + str + "</table>"; //清洗
XmlDocument doc = new XmlDocument();
doc.LoadXml(str);
XmlNodeList nodes = doc.SelectNodes("//tr");

for (int j = 0; j < nodes.Count; j++)
                {
                    XmlNode node = nodes[j];
                    for (int i = 0; i < node.ChildNodes.Count; i++) //列的循环,为每个列指定名称
                    {
                        XmlNode n = doc.CreateNode(XmlNodeType.Element, "col" + i.ToString(), "");
                        n.InnerXml = node.ChildNodes[i].InnerText;
                        node.ReplaceChild(n, node.ChildNodes[i]);
                    }
                }

                //导入Dataset
                DataSet ds = ds = new DataSet();
                StringReader tr = new StringReader(doc.InnerXml);
                ds.ReadXml(tr);
                DataTable dt = ds.Tables[0];

8. //XML格式字符串替换
public static string ReplaceFontSpan(string s)
        {
            Regex r = new Regex("<head>.*?</head>");
            s = r.Replace(s, "");
            r = new Regex("</?font.*?>");
            s = r.Replace(s, "");
            r = new Regex("</?span.*?>");
            s = r.Replace(s, "");
            r = new Regex("</?a.*?>");
            s = r.Replace(s, "");
            r = new Regex("&nbsp");
            s = r.Replace(s, "");
            r = new Regex("</?tbody.*?>");
            s = r.Replace(s, "");
            r = new Regex("</?table.*?>");
            s = r.Replace(s, "");
            return s;
        }
9.http://www.cainiao8.com/web/js_note/js_regular_expression_blueidea.html    正则表达式牛逼

10./// <summary>
        /// 转换中文excel名称，防止乱码，兼容IE和火狐
        /// </summary>
        /// <param name="fileName">中文名称</param>
        /// <returns></returns>
        public static string GetToExcelName(string fileName)
        {
            string UserAgent = HttpContext.Current.Request.ServerVariables["http_user_agent"].ToLower();
            if (UserAgent.IndexOf("firefox") == -1)
                fileName = HttpUtility.UrlEncode(fileName, System.Text.Encoding.UTF8);
            return fileName;
        }

11.附带下载的文件操作
private void csvfile(string table, string excelname, string _zfcs)         {
      string name=GetSaveFilePath();
      string path = Server.MapPath("\\upload") + name + ".csv";
      FileStream file = new FileStream(path, FileMode.Create);//创建文件流
      Byte[] info = System.Text.Encoding.GetEncoding(_zfcs).GetBytes(table);
      file.Write(info, 0, info.Length);//文件内容写入文件流
      file.Flush();
      file.Close();
      file.Dispose();
      long size = info.Length;
      Response.Clear();
     Response.ContentType = "application/octet-stream"; //"application/octet-stream";//octet-stream
     Response.AppendHeader("Content-Disposition", "attachment;filename=" + GetToExcelName(excelname) + ".csv");
     Response.AppendHeader("Content-Length", size.ToString());
     Response.AppendHeader("Content-Transfer-Encoding", "binary");
     Response.ContentEncoding = System.Text.Encoding.UTF8;
    Response.WriteFile(path, 0, info.Length);
     Response.Flush();
    Response.End();
}

12. javascript 动态生成form表单以及隐藏域
function Excelbut( divid,tag,sheetname,excelname,kz,zfcs ){ //excel
     var _wtb='',_html='';
     var wtb=GetTableData(divid);//解析table中的colspan与rospan，还原成colspan=2为 <td>1</td> <td>2</td>
    wtb=wtb.split('☆');
    _wtb=wtb[0];
    _html=wtb[1];
    var form = P_createElement('form', {
        method: 'post',
         action:'http://export.yikeba.com/ToEXCELpage.aspx',
         enctype: 'multipart/form-data'   }, {
         display: 'none'   }, document.body); //_html

    P_each(['hidhtml','excelname','sheetname','hidkz','tag','zfcs','wantable'], function (name) {
          P_createElement('input', {
             type: 'hidden',
             name: name,
             value: {
             hidhtml:_html, //原始table中colspan=2
             excelname:excelname, //'导出应付列表',
             sheetname: sheetname, //'名称1|',
             hidkz:kz, //'', //是否允许转化特殊格式 "true"代表要进行特殊格式化比如DateTime类型倒出来就是日期格式
             tag:tag, //导出文件参数默认为空为空时候就是xls 另一种是csv
             zfcs:zfcs, //字符参数默认为空为空时候就是utf-8 另一种是gb2312
             wantable:_wtb //解析table中的colspan与rospan，还原成colspan=2为 <td>1</td> <td>2</td>
}[name]    }, null, form);   });

// submit
form.submit();

// clean up
P_discardElement(form);
}

//将存在colspan与rowspan的table还原成完整的colspan=1 和 rowspan=1
        function ReCreateTable(_id){
      var _tab=$("#"+_id).html();
   var s=$("#"+_id).find("tr th").length;
            $("#"+_id+ " tr").each(function(trindex,tritem){
       //var j=0;

                $(tritem).find("td").each(function(tdindex,tditem){
                      var rowspanCount=$(tditem).attr("rowspan");　　
                      var colspanCount=$(tditem).attr("colspan");

                      var value=$(tditem).html();
       if($(tditem).find("input[type=text]").val()!=undefined){value=$(tditem).find("input[type='text']").val();$(tditem).html("").html(value);}
       if($(tditem).find("select").val()!=undefined){value=$(tditem).find("select").val();$(tditem).html("").html(value);}
                       var newtd="<td>"+value+"</td>";
                      if(rowspanCount>1){
                        var parent=$(tditem).parent("tr")[0];
                        if(colspanCount==undefined){colspanCount=1}
                        while(rowspanCount>1){
                           var index=$(tditem).index();
                for(var i=0;i<colspanCount;i++){
                $(parent).next().find("td:eq("+(index)+")").before(newtd);
             }
             parent=$(parent).next();
             rowspanCount--;
                        }
                        $(tditem).attr("rowspan",1);
                      }
                      if(colspanCount>1){
                        while(colspanCount>1){
                            $(tditem).after(newtd);
                            colspanCount--;
                        }
                        $(tditem).attr("colspan",1);
                      }
                });

    $(tritem).find("td:eq("+(s-1)+")").html("");//为什么没有更改嘞？
    $(tritem).find("th:eq("+(s-1)+")").html("");
            });
   var _newtab=$("#"+_id).html();
   $("#"+_id).html("");
   $("#"+_id).html(_tab);
   if(_id.indexOf("Table")!=-1){$("#"+_id).removeAttr("id");}//移除属性id
   return _newtab;
        }

//针对于IE浏览器对table去掉双引号的问题用正则表达式加双引号

_html=_html.replace(zSaved,z[i]);}}}

return _html;}

13.数据库

create proc ogn_save_mz ( @ognaid varchar(20), @ognflightinfo text, @ognadderss varchar(100), @ognoutinform text, @ognmarks text, @right char(1) ) as SET XACT_ABORT ON --强制出错全部回滚 BEGIN TRAN --内容主体

--出错处理 IF @@ERROR<>0 GOTO errhandle---->發生錯誤直接跳轉到後面，不發生錯誤提交 COMMIT TRAN set @right=1 RETURN errhandle: IF @@ERROR<>0 BEGIN ROLLBACK TRAN set @right=0 END RETURN GO

14.
使浏览器不会在本地缓存结果，response.setHeader("Cache-Control","no-cache");response.setHeader("pragma","no-cache");

15.让文本框只能输入数字(包含小数)

function chkLast(obj) {
    // 如果出现非法字符就截取掉
    if (obj.value.substr((obj.value.length - 1), 1) == '.')
        obj.value = obj.value.substr(0, (obj.value.length - 1));
}
用法：<input type='text' name='Quentity' id='Quentity' style='50px;' onkeyup=\"chkPrice(this);\" onblur=\"chkLast(this)\" onpaste=\"javascript: return false;\" value='" + count + "' />(onpaste=\"javascript: return false;\" 禁止使用粘贴,屏蔽右键)