摘要：string str="abc\"";Regex.Replace(str,@"[\""]+", ""); 阅读全文

摘要：function Ajax(url) { var xmlhttp; if (url.indexOf("?") > 0) { url = url + "&NowDateTimeSign=" + new Date().getTime(); } else { url = url + "?NowDateTimeSign=" + new Date().getTime(); } if (window.ActiveXObject) { xmlhttp = new ActiveXObject('Microsoft.XMLHTTP 阅读全文

摘要：create function fn_split(@c varchar(2000),@split varchar(2)) returns @t table(col varchar(20)) as begin while(charindex(@split,@c)<>0) begin insert @t(col) values (substring(@c,1,charindex(@split,@c)-1)) set @c = stuff(@c,1,charindex(@split,@c),'') end insert @t(col) values (@c) return 阅读全文

摘要：declare @akey varchar(255)set @akey = 'userid'-- 在所有存储过程中查找关键字,关键字不区分大小写declare @aname as varchar(700)declare @atext as varchar(8000)declare @acolid as intdeclare @pos as intdeclare @start as intdeclare @end as intdeclare @shorttext as varchar(255)create table #temp_proctext (oid int IDENTIT 阅读全文

摘要：string connectionstring="server=.;uid=sa;pwd=sa;database=test";SqlBulkCopy sbc = new SqlBulkCopy(Guide.GetConnectionString(SPType.SP_R), SqlBulkCopyOptions.UseInternalTransaction); sbc.BulkCopyTimeout = 5000; sbc.NotifyAfter = dt.Rows.Count; try { //tb_RealShippingFee 向那张表里面写数据 sbc.Destina 阅读全文

摘要：public DataTable DataReaderToTable(MySqlDataReader dr) { DataTable dt = new DataTable(); DataTable schemaTb = dr.GetSchemaTable();//得到SqlDataReader的结构，相当于表的结构一样，在这里表的结构信息也被存储成了一个信息表。这个信息表相当于两列多行，第一列存储数据结果表的列名称，第二列存储数据结果表对应列的类型。想象一下我们在设计SqlServer数据库的时候得表结构 try { foreach (DataRow sdr in schemaTb.Rows) 阅读全文