摘要：1 TOP这是一个大家经常问到的问题，例如在SQLSERVER中可以使用如下语句来取得记录集中的前十条记录：SELECT TOP 10 * FROM [index] ORDER BY indexid DESC;但是这条SQL语句在SQLite中是无法执行的，应该改为：SELECT * FROM [index] ORDER BY indexid DESC limit 0,10;其中limit 0,10表示从第0条记录开始，往后一共读取10条2创建视图（Create View）SQLite在创建多表视图的时候有一个BUG，问题如下：CREATE VIEW watch_single AS SELEC 阅读全文

摘要：C#如何在webBrowser1控件通过TagName,Name查//防止页面多次刷新页面执行if(num==1){stringGetUserName=System.Configuration.ConfigurationSettings.AppSettings["Y2000UserName"].ToString();stringGetUserPassword=System.Configuration.ConfigurationSettings.AppSettings["Y2000UserPassword"].ToString();inta=1;intal 阅读全文

摘要：publicstaticintDateToTimestamp(DateTimedate){DateTimeorigin=newDateTime(1970,1,1,0,0,0,0);TimeSpandiff=date-origin;inttimestamp=(int)Math.Floor(diff.TotalSeconds);returntimestamp;}publicstaticDateTimeTimestampToDate(doubletimestamp){DateTimeorigin=newDateTime(1970,1,1,0,0,0,0);DateTimedate=origin.Ad 阅读全文

摘要：Html TO Ubb and Ubb TO Htmlfunctionpattern(str){//str=str.replace(/(\r\n|\n|\r)/ig,'');str=str.replace(/<br[^>]*>/ig,'\n');str=str.replace(/<p[^>\/]*\/>/ig,'\n');str=str.replace(/\[code\](.+?)\[\/code\]/ig,function($1,$2){returnphpcode($2);});str=str.replace 阅读全文