1、javascript(substr,indexOf):
var bhtml=window.document.body.innerHTML;
var strstart="<!--startprint-->";
var strend="<!--endprint-->";
var phtml=bhtml.substr(bhtml.indexOf(strstart)+17);
var ehtml=phtml.substr(0,phtml.indexOf(strend));
window.document.body.innerHTML=ehtml;
window.print();
2、DownloadFile(string A,string B);//A指要下载的URL,B指要将下载的资源保存到本机的什么位置
例:new WebClient().DownloadFile("http://www.baidu.com","D:\\test.html");需要引入using System.Web.Net
3、C# 3.5
using System.Linq;
Main函数中:
List<Sales> lsales=new List<Sales>()
{
new Sales(Num="A01",Performance=198,Score=97},
new Sales{ Num="A02",Performance=90,Score=103},
new Sales{ Num="A02",Performance=76,Score=78},
new Sales{ Num="A03",Performance=123,Score=100},
new Sales{ Num="A04",Performance=77,Score=87},
new Sales{ Num="A05",Performance=10,Score=54},
new Sales{Num="A06",Performance=81,Score=104},
new Sales{Num="A07",Performance=110,Score=87},
new Sales{ Num="A08",Performance=45,Score=41},
new Sales{Num="A09",Performance=123,Score=99},
new Sales{ Num="A10",Performance=140,Score=88},
new Sales{ Num="A11",Performance=109,Score=98}
};
var avr=lsales.Average(s=>s.Performance);
foreach(var sl in from s in lsales where s.Performance>avr orderby s.Performance descending select s)
{ console.WriteLine(sl.num+" "+sl.performance+" "+score);}
Sales类:
class Sales
{
string num;
private string Num
{ get {return num};
set { num=value};
}
int performance;
public int Performance
{
get { return performance; }
set { performance = value; }
}
int score;
public int Score
{
get { return score; }
set { score = value; }
}
}
4、如果打开的项目出现:在应用程序级别之外使用注册为 allowDefinition='MachineToApplication' 的节是错误......
则需要从“打开项目/解决方案”中打开,则没有出现类似的问题。
5、注册表的启动程序项路径:HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Run
6、递归:
Main函数:
getprint(1);
getprint函数:
private static void getprint(int a)
{ Console.WriteLine(b);
b++;
if(b<=200)
getprint(b);
else
Console.ReadLine();
}
7、var[] lpinage=new[] {"Page_1.aspx", "Page_10.aspx", "Page_100.aspx", "Page_11.aspx", "Page_111.aspx"};
lpinage=lpinage.OrderBy(s=>int.parse(Regex.match(s,@"\d+").value)).ToArray();
foreach(var sl in lpinage)
{ Console.WriteLine(sl);}
Console.ReadLine();
8、private static string RepeatString(string str,int repeatCount)
{ var source=str.ToCharArray();
var dest=new[source.length*repeatCount];
for(int i=0;i<dest.length;i++)
{ Buffer.BlockCopy(source,0,dest,source.length*i*2,source.length*2); }//char在C#中占用两个字符
retrun new string(dest);
}
9、判断是否是汉字:
string str="欢迎光临 abc";
for(int i=0;i<str.Length;i++)//使用ASCII编码进行判断
{ if((int)str[i]>127)
Console.WriteLine("是汉字");
else
Console.WriteLine("不是汉字");
}
//使用UNICODE编码判断是否是汉字
string str="欢迎光临 abc";
for(int i=0;i<str.Length;i++)
{ if(Regex.IsMatch(str,@"[\4e00-\u9fbb]+{1}"))
Console.WriteLine("是汉字");
else
Console.WriteLine("不是汉字");
}
10、产生一个int数组,长度为100,并且随机加入1-100,不能重复
int[] arr=new int[100];
ArrayList mylist=new ArrayList();
Random rad=new Random();
while(mylist.count<100)
{ int num=rad.Next(1,101);
if(mylist.Contains(num))
mylist.Add(num);
}
for(int i=0;i<100;i++)
{arr[i]=(int)mylist[i];}
11、SQL Server连接以sa身份登录时出现错误:无法连接到LY,用户'sa'登录失败(Microsoft SQL Server,错误:4064),
解决方法:使用本机服务器,Windows身份验证进行登录,然后点击“安全性”---"登录名"----sa----"属性"---修改“默认数据库为:master”则可以成功登录。
12、SQL Server函数:
left:select left('abcdefg',3); -----输出结果:abc
charindex:select charindex('cd','abcdefg'); -----输出结果:3
select charindex('ac','abcdefg');-----输出结果:0
stuff: select stuff('abcde',1,2,'mmmm');--------输出结果:mmmmcde
13、SQL获取现在时间:select convert(nvarchar(12),getdate(),108); ----例如输入的结果:09:20:45
14、select GetDate()-1
15、去除空格:select rtrim(' Missplie ');----输出结果为: Missplie;
select ltrim(' Missplie ');----输出结果为:Missplie ;
。
16、Geography表 | Store_Information表
Region_Name Store_Name | Store_Name Sales Txn_Date
East Boston | Los Angeles 1500 1999-01-05
East New York | San Diego 250 1999-01-05
West Los Angeles | Los Angeles 300 1999-01-05
West San Diego | Boston 700 1999-01-05
(一)地区的销售情况 select A1.Region_Name,sum(A2.Sales) from Geography A1,Store_Information A2 where A1.Store_Name=A2.Store_Information group by A1.Region_Name
(二)门店的销售情况 select A1.Store_Name,sum(A2.Sales) from Geography A1 left outer join Store_Information A2 on A1.Store_Name=A2.Store_Name group by A1.Store_Name
(三)联集:UNION ALL/UNION 交集:intersect 例:select Txn_Date from B1 intersect select Txn_Date from B2 (即:两张表有相同数据的输出显示)
(四)substring(‘Boston’,1,3);----输出结果:Bos
(五)创建视图:Create view ”viewName“ as "SQL语句";
Create view V_Region_Sales as Select A1.Region_Name from Geography A1
17、string text=@"9009903090629063";
string[] list=Regex.Split(text,@"(?<\G\w{4})(?!$)");
string res="";
for(int i=0;i<list.Length;i++)
{res+=list[i]+",";} 则输出的结果是:9009,9030,9062,9063,
18、Expires属性指定在浏览器上缓存存储的页距过期还有多少时间
Response.Expires=0; ---表示立即过期
Response.expiresabsolute=Now()-1;
//
Response.Expires=1; ---表示还有1分钟过期
///
让网页不缓存
Response.expires=0
Response.expiresabsolute=Now()-1
Response.addHeader "pragma","no-cache"
Response.addHeader "cache-control","private"
Response.CacheControl="no-cache"
19、asp读取数据库信息:
<%dim rs,sql
set rs=server.createobject("adodb.recordset") ----创建createobjet
if request.QueryString("ID")="" or not IsNumeric(request.QueryString("ID")) then
sql="select top 1 * from LiangJiangCMS_About where ViewFlag"&Language&" and not ChildFlag order by Sequence asc"
else
sql="select * from LiangJiangCMS_About where ViewFlag"&Language& and ID=12;
end if
rs.open sql,conn,1,3
if rs.eof Then%>
暂无相关信息
<%
Else
if ViewNoRight(rs("GroupID"),rs("Exclusive")) then%>
<%=rs("Content"&Language)%>
<%=end if%>
%>
20、样式(行下虚线显示): <tr style="background:url(Images/bg2.gif) repeat-x left bottom;">......</tr>