代码
2 protected void TransmitFile()
3 {
4
5 string strFileName = "a.jpg";
6 Response.ContentType = "application/x-zip-compressed";
7 //Response.ContentEncoding = System.Text.Encoding.GetEncoding("gb2312");
8 string filename =DateTime.Now.ToShortDateString() + strFileName;
9 //BLL.Config.PART_EM_UPLOAD_DOC 为路径 ("D:/EMUploadDoc/")
10 Response.AddHeader("Content-Disposition", "attachment;filename=" +Server.UrlPathEncode(strFileName));
11 //Server.UrlPathEncode()解决文件名的乱码问题.
12
13 Response.TransmitFile(filename);
14 }
15 //WriteFile实现下载
16 protected void WriteFile()
17 {
18
19 string fileName = "aa.txt";//客户端保存的文件名
20 string filePath = Server.MapPath("DownLoad/"+fileName+"");//路径
21 FileInfo fileInfo = new FileInfo(filePath);
22 Response.Clear();
23 Response.ClearContent();
24 Response.ClearHeaders();
25 Response.AddHeader("Content-Disposition", "attachment;filename=" + fileName);
26 Response.AddHeader("Content-Length", fileInfo.Length.ToString());
27 Response.AddHeader("Content-Transfer-Encoding", "binary");
28 Response.ContentType = "application/octet-stream";
29 Response.ContentEncoding = System.Text.Encoding.GetEncoding("gb2312");
30 Response.WriteFile(fileInfo.FullName);
31 Response.Flush();
32 Response.End();
33 }
34 //WriteFile分块下载
35 protected void WriteFile_M()
36 {
37 string fileName = "a.jpg";//客户端保存的文件名
38 string filePath = Server.MapPath("DownLoad/a.jpg");//路径
39 System.IO.FileInfo fileInfo = new System.IO.FileInfo(filePath);
40 if (fileInfo.Exists == true)
41 {
42 const long ChunkSize = 102400;//100K 每次读取文件,只读取100K,这样可以缓解服务器的压力
43 byte[] buffer = new byte[ChunkSize];
44 Response.Clear();
45 System.IO.FileStream iStream = System.IO.File.OpenRead(filePath);
46 long dataLengthToRead = iStream.Length;//获取下载的文件总大小
47 Response.ContentType = "application/octet-stream";
48 Response.AddHeader("Content-Disposition", "attachment; filename=" + HttpUtility.UrlEncode(fileName));
49 while (dataLengthToRead > 0 && Response.IsClientConnected)
50 {
51 int lengthRead = iStream.Read(buffer, 0, Convert.ToInt32(ChunkSize));//读取的大小
52 Response.OutputStream.Write(buffer, 0, lengthRead);
53 Response.Flush();
54 dataLengthToRead = dataLengthToRead - lengthRead;
55 }
56 Response.Close();
57 }
58 }
59 protected void file_Io()
60 {
61 string fileName = "a.jpg";
62 string filePath = Server.MapPath("DownLoad/"+fileName+"");
63 //以字符流的形式下载文件
64 FileStream fs = new FileStream(filePath, FileMode.Open);
65 byte[] bytes = new byte[(int)fs.Length];
66 fs.Read(bytes, 0, bytes.Length);
67 fs.Close();
68 Response.ContentType = "application/octet-stream";
69 //通知浏览器下载文件而不是打开
70 Response.AddHeader("Content-Disposition", "attachment; filename=" + HttpUtility.UrlEncode(fileName, System.Text.Encoding.UTF8));
71 Response.BinaryWrite(bytes);
72 Response.Flush();
73 Response.End();
74 }
75
<add extension=".html" type="System.Web.Compilation.PageBuildProvider" />
如不加这句 会导致原有的html静态页面出现错误!
一。C#/.net方面:
1.怎样防止匿名用户进入admin文件夹。
2.简述下request["a"],request.From["a"],request.QueryString["a"]作用和区别?
3.列举ADO.NET中的五个主要对象,并简单描述?
4. 为什么我们要使用泛型呢?或者List<T>和ArrayList有什么区别?
5.请说说Response.Redirect和Server.Transfer有什么区别?能说说它们的实现原理吗?
二。JS方面
写出一个遍历页面所有checkbox的函数?
三。SQL方面(都是比较常见的)
1.写出一条Sql语句:取出表A中第31到第40记录(SQLServer,以自动增长的ID作为主键,注意:ID可能不是连续的。
2.另外一道题目的要求是查询表A中存在ID重复三次以上的记录?
3。表a中有一字段email 存储用户注册邮箱(如xx@126.com)用一条SQL语句统计邮箱分布,效果如下
邮箱类型 数量
126.com 30
4.表b中有一字段存储用户申请记录的ID(ID如A1):如A1+A2+A3(表示用户申请了3个)
查出申请3个以上的用户(用存储过程)
四。XML方面
xml文件:
books.xml
<?xml version="1.0" encoding="gb2312"?>
<books>
<book id="1">
<name>goodbook</name>
<price>50</price>
</book>
<book id="2">
<name>badbook</name>
<price>50</price>
</book>
<book id="2">
<name>badbook</name>
<price>40</price>
</book>
</books>
写出获取price>=50的数量语句?
以上均为在北京面试过程遇到的题目,希望对正在求职中的你有所帮助,欢迎大家也踊跃上传自己的面试题目,相互交流!



