【孟宪会之精彩世界】之.NET开发者园地

ASP.NET 导出带格式的 Word 文档

Wed, 16 May 2012 10:42:17 GMT

可直接拷贝运行下面的代码测试

ASPX 代码


<%@ Page Language="C#" AutoEventWireup="true" %>



<script runat="server">



  protected void Page_Load(object sender, EventArgs e)

  {

    Repeater1.DataSource = new String[] { "测", "孟宪会" };

    Repeater1.DataBind();

  }



  protected void Button1_Click(object sender, EventArgs e)

  {

    String ExportFileName = "孟宪会导出 Word 测试";

    if (Request.Browser.Browser.IndexOf("MSIE") > -1)

    {

      ExportFileName = HttpUtility.UrlEncode(ExportFileName, System.Text.UnicodeEncoding.GetEncoding("GB2312"));

    }

    ExportFileName += ".doc";

    Response.Clear();

    Response.BufferOutput = true;

    Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");

    Response.Charset = "GB2312";

    Response.AppendHeader("Content-Disposition", "attachment;filename=" + ExportFileName);

    Response.ContentType = "application/ms-word";

    Page.EnableViewState = false;

   

    System.IO.StringWriter stringWriter = new System.IO.StringWriter();

    HtmlTextWriter textWriter = new HtmlTextWriter(stringWriter);

    Literal header = new Literal();

    header.Text = "<h2>文章标题</h2>";

    Header.Controls.Add(header);

    Header.RenderControl(textWriter);

    this.Repeater1.RenderControl(textWriter);

    Response.Write("<html xmlns:v='urn:schemas-microsoft-com:vml' xmlns:o='urn:schemas-microsoft-com:office:office' xmlns:w='urn:schemas-microsoft-com:office:word' xmlns:m='http://schemas.microsoft.com/office/2004/12/omml' xmlns='http://www.w3.org/TR/REC-html40'><head></head><body lang=ZH-CN>" + stringWriter.ToString());

    Response.End();

    Response.Flush();

  }

  public override void VerifyRenderingInServerForm(System.Web.UI.Control control)

  {

  }

</script>

<html xmlns="http://www.w3.org/1999/xhtml">

<head id="Head1" runat="server">

  <title></title>

</head>

<body>

  <form id="form1" runat="server">

  <asp:Repeater ID="Repeater1" runat="server">

    <HeaderTemplate>

      <table cellspacing="1" cellpadding="3" width="96%" align="center" border="1">

    </HeaderTemplate>

    <FooterTemplate>

      </table></FooterTemplate>

    <ItemTemplate>

      <tr><td>测试啦</td><td>This is a 测试啊</td><td>

        <%#Container.DataItem%></td></tr>

    </ItemTemplate>

  </asp:Repeater>

  <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="导出成Word文档" />

  </form>

</body>

</html>

HttpWebRequest GET HTTPS 页面出现 IOException: 由于远程方已关闭传输流，身份验证失败。错误的解决方法

Tue, 17 Apr 2012 12:57:14 GMT

再使用 HttpWebRequest 请求 https 协议的页面时，默认情况下会出现 “IOException: 由于远程方已关闭传输流，身份验证失败。的错误”，网上也有一些方法，说是使用

C# 代码


ServicePointManager.ServerCertificateValidationCallback = delegate { return true; };

可以解决问题，但有时候，使用这个仍是不行的，需要加

C# 代码


ServicePointManager.SecurityProtocol = SecurityProtocolType.Ssl3;

设置ServicePointManager 对象管理的 ServicePoint 对象所使用的安全协议，它是一个枚举值。下面是一个完整的例子

C# 代码


string url = "https://data.cathaylife.cn/servlet/HttpDispatcher/KAA0_0100/prompt?newTxRequest=true&syscode=DA&subcode=KAA0";    

HttpWebRequest myRequest = (HttpWebRequest)WebRequest.Create(url);    

myRequest.Method = "GET";

myRequest.Proxy = null;

myRequest.UserAgent = "Mozilla/5.0 (Windows NT 6.1; WOW64; rv:11.0) Gecko/20100101 Firefox/11.0";

myRequest.Headers.Add("Accept-Language", "zh-cn,en-us;q=0.8,zh-hk;q=0.6,ja;q=0.4,zh;q=0.2");

myRequest.Accept = "text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8";

//ServicePointManager.ServerCertificateValidationCallback = delegate { return true; }; //这行没用

ServicePointManager.SecurityProtocol = SecurityProtocolType.Ssl3;

HttpWebResponse myResponse = (HttpWebResponse)myRequest.GetResponse();

Response.Write(new System.IO.StreamReader(myResponse.GetResponseStream(),Encoding.GetEncoding("GB2312")).ReadToEnd());

解决 ASP.NET TreeView 断线问题

Fri, 13 Apr 2012 10:13:30 GMT

默认情况下，ASp.NET TreeView 设置 ShowLines="True" 后，产生的树在浏览器中查看，出现断线的问题，可以通过设置

CSS 代码


  <style type="text/css">

    #TreeView1 td div{height: 20px !important;}

  </style>

解决在IE中的断线问题，但在Firefox中，还是不能解决，在Firefox中还需要把DTD改成

HTML 代码


<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

才可以。

使用 HttpWebRequest 下载经过重定向的文件

Wed, 11 Apr 2012 09:31:03 GMT

使用 req.AllowAutoRedirect = true; 可以直接下载到文件，但不能得到文件名，通过使用req.AllowAutoRedirect = false;得到响应的Location，从而可以得到所请求的真实地址，也就可以得到文件名了。下面的代码可以进行下载到真实的文件名。需要注意的是，后面的req.AllowAutoRedirect = true;必须设置为 true，如果设置为false，则不能下载到完整的文件。

C# 代码


string Cookie = String.Empty;

String url = "http://search.patentstar.com.cn/cprs2010/Docdb/GetBns.aspx?PNo=APP201180002436";

String refer = url.Substring(0, url.LastIndexOf("/") + 1);

System.Net.HttpWebRequest req = System.Net.HttpWebRequest.Create(url) as System.Net.HttpWebRequest;

req.AllowAutoRedirect = false;

req.Referer = refer;

req.UserAgent = "Mozilla/5.0 (Windows; U; Windows NT 6.1; zh-CN; rv:1.9.2.13) Gecko/20101203 Firefox/3.6.13";

System.Net.HttpWebResponse res = req.GetResponse() as System.Net.HttpWebResponse;

System.Net.WebHeaderCollection headers = res.Headers;

String newUrl = "";

if ((res.StatusCode == System.Net.HttpStatusCode.Found) ||

  (res.StatusCode == System.Net.HttpStatusCode.Redirect) ||

  (res.StatusCode == System.Net.HttpStatusCode.Moved) ||

  (res.StatusCode == System.Net.HttpStatusCode.MovedPermanently))

{

  newUrl = headers["Location"];

  newUrl = newUrl.Trim();

}



if (headers["Set-Cookie"] != null)

{

  Cookie = headers["Set-Cookie"];

}



NameValueCollection collHeader = new NameValueCollection();

if (Cookie.Length > 0)

{

  collHeader.Add("Cookie", Cookie);

}

res.Close();

req = null;

    

String fileName = newUrl.Substring(newUrl.LastIndexOf("/") + 1);

req = System.Net.HttpWebRequest.Create(newUrl) as System.Net.HttpWebRequest;

req.AllowAutoRedirect = true;

req.Referer = url;

req.UserAgent = "Mozilla/5.0 (Windows; U; Windows NT 6.1; zh-CN; rv:1.9.2.13) Gecko/20101203 Firefox/3.6.13";

res = req.GetResponse() as System.Net.HttpWebResponse;

            

System.IO.Stream stream = res.GetResponseStream();

byte[] buffer = new byte[32 * 1024];

int bytesProcessed = 0;

System.IO.FileStream fs = System.IO.File.Create(Server.MapPath(fileName));

int bytesRead;

do

{

  bytesRead = stream.Read(buffer, 0, buffer.Length);

  fs.Write(buffer, 0, bytesRead);

  bytesProcessed += bytesRead;

}

while (bytesRead > 0);

fs.Flush();

fs.Close();

res.Close();

Response.Write("文件 " + fileName +  " 已经下载完成。");

使用 GridView 显示进度图片和进度文字的例子

Thu, 05 Apr 2012 15:35:12 GMT

本文主要实例采用CSS将文字显示在图片上的技术。直接复制下面的代码，粘贴成测试文件，直接浏览器即可。

ASPX 代码


<%@ Page Language="C#" EnableViewState="false" %>



<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<script runat="server">

  protected void Page_Load(object sender, EventArgs e)

  {

    if (!Page.IsPostBack)

    {

      System.Data.DataTable dt = new System.Data.DataTable();

      System.Data.DataRow dr;

      

      //测试用显示字段

      dt.Columns.Add(new System.Data.DataColumn("1月", typeof(System.String)));

      dt.Columns.Add(new System.Data.DataColumn("2月", typeof(System.String)));

      dt.Columns.Add(new System.Data.DataColumn("3月", typeof(System.String)));

      //测试用进度数据

      String[] x = { "10%", "20%", "50%", "80%", "90%", "100%" };

      Random r = new Random();

      for (int i = 0; i < 8; i++)

      {

        dr = dt.NewRow();

        dr[0] = x[r.Next(0, x.Length)];

        dr[1] = x[r.Next(0, x.Length)];

        dr[2] = x[r.Next(0, x.Length)];

        dt.Rows.Add(dr);

      }

      GridView1.DataSource = dt;

      GridView1.DataBind();

    }

  }

</script>

<html xmlns="http://www.w3.org/1999/xhtml">

<head id="Head1" runat="server">

<title>使用 GridView 显示进度图片和进度文字的例子</title>

</head>

<body>

  <form id="form1" runat="server">

  <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false">

    <Columns>

      <asp:TemplateField HeaderText="1月">

        <ItemTemplate>

        <div style="position: relative; width: 200px;"><img alt="" src="http://livedocs.adobe.com/flex/3_cn/langref/images/createGradientBox-2.jpg" width="<%#Eval("1月") %>" height="20" /><br />

          <div style="width: 200px; position: absolute; z-index: 100; top: 0px; text-align: center;"><%#Eval("1月")%></div>

        </div>

        </ItemTemplate>

      </asp:TemplateField>

      <asp:TemplateField HeaderText="2月">

        <ItemTemplate>

        <div style="position: relative; width: 200px;"><img alt="" src="http://livedocs.adobe.com/flex/3_cn/langref/images/createGradientBox-2.jpg" width="<%#Eval("2月") %>" height="20" /><br />

          <div style="width: 200px; position: absolute; z-index: 100; top: 0px; text-align: center;"><%#Eval("2月")%></div>

        </div>

        </ItemTemplate>

      </asp:TemplateField>

      <asp:TemplateField HeaderText="3月">

        <ItemTemplate>

        <div style="position: relative; width: 200px;"><img alt="" src="http://livedocs.adobe.com/flex/3_cn/langref/images/createGradientBox-2.jpg" width="<%#Eval("3月") %>" height="20" /><br />

          <div style="width: 200px; position: absolute; z-index: 100; top: 0px; text-align: center;"><%#Eval("3月")%></div>

        </div>

        </ItemTemplate>

      </asp:TemplateField>

    </Columns>

  </asp:GridView>

  </form>

</body>

</html>

C# 解析任意格式的数字字符串

Sat, 31 Mar 2012 15:25:17 GMT

在.NET中， NumberFormatInfo 类是用来设置数字格式的，有了这个类，我们就可以正确解析任意格式的数字字符串。NumberGroupSeparator 属性用来获取或设置在数值中对小数点左边数字进行分组的字符串。NumberDecimalSeparator 属性获取或设置在数值中用作小数点分隔符的字符串。下面是几个例子，通过运行例子，就可以明白其工作原理了。

C# 代码


//NumberGroupSeparator : 获取或设置在数值中对小数点左边数字进行分组的字符串。

//NumberDecimalSeparator : 获取或设置在数值中用作小数点分隔符的字符串。

String num1 = "123,456,789";

String num2 = "123|456|789";

String num3 = "123.456.789";

String num4 = "123,456.789";

String num5 = "123.456,789";

System.Globalization.NumberFormatInfo nfi = new System.Globalization.NumberFormatInfo();

nfi.NumberGroupSeparator = ",";

int x1 = int.Parse(num1, System.Globalization.NumberStyles.AllowThousands, nfi);

nfi.NumberGroupSeparator = "|";

int x2 = int.Parse(num2, System.Globalization.NumberStyles.AllowThousands, nfi);

nfi.NumberGroupSeparator = ".";

int x3 = int.Parse(num3, System.Globalization.NumberStyles.AllowThousands, nfi);

nfi.NumberGroupSeparator = ",";

nfi.NumberDecimalSeparator = ".";

Decimal x4 = Decimal.Parse(num4,nfi);

nfi.NumberGroupSeparator = ".";

nfi.NumberDecimalSeparator = ",";

Decimal x5 = Decimal.Parse(num5, nfi);

Response.Write("<li>" + x1);

Response.Write("<li>" + x2);

Response.Write("<li>" + x3);

Response.Write("<li>" + x4);

Response.Write("<li>" + x5);

得到 MDB 文件中的表名个字段名、字段类型名称

Fri, 30 Mar 2012 13:44:53 GMT

C# 代码


String connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|aspxWeb2.mdb;";

OleDbConnection conn = new OleDbConnection(connectionString);

conn.Open();

DataTable schemaTable;

DataTable dt = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });

for (int i = 0; i < dt.Rows.Count; i++)

{

  String tableName = dt.Rows[i]["TABLE_NAME"].ToString();

  Response.Write("<h1>" + tableName + "</h1>");

  schemaTable = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Columns, new Object[] { null, null, tableName, null });

  for (int j = 0; j < schemaTable.Rows.Count; j++)

  {

    Response.Write("<li>字段名称：" + schemaTable.Rows[j]["COLUMN_NAME"].ToString() + " 类型：" + (OleDbType)schemaTable.Rows[j]["DATA_TYPE"] + "</li>");

  }

}

conn.Close();

一段裁切图片的代码

Thu, 29 Mar 2012 14:14:37 GMT

完整代码如下：

C# 代码


//图片路径

String oldPath = Server.MapPath("~/aaaa.jpg");



//新图片路径

String newPath = System.IO.Path.GetExtension(oldPath);



//设置截取的坐标和大小

int x = 0, y = 10, width = 200, height = 200;



//计算新的文件名，在旧文件名后加_new

newPath = oldPath.Substring(0, oldPath.Length - newPath.Length) + "_new" + newPath;

Response.Write(oldPath);

Response.Write("<br>");

Response.Write(newPath);

Response.Write("<br>");

//定义截取矩形

System.Drawing.Rectangle cropArea = new System.Drawing.Rectangle(x, y, width, height); //要截取的区域大小



//加载图片

System.Drawing.Image img = System.Drawing.Image.FromStream(new System.IO.MemoryStream(System.IO.File.ReadAllBytes(oldPath)));



//判断超出的位置否

if ((img.Width < x + width) || img.Height < y + height)

{

  Response.Write("截取的区域超过了图片本身的高度、宽度.");

  img.Dispose();

  return;

}

//定义Bitmap对象

System.Drawing.Bitmap bmpImage = new System.Drawing.Bitmap(img);



//进行裁剪

System.Drawing.Bitmap bmpCrop = bmpImage.Clone(cropArea, bmpImage.PixelFormat);



//保存成新文件

bmpCrop.Save(newPath);



//释放对象

img.Dispose();

bmpCrop.Dispose();

SQL Server 2012 Express 下载及相关链接

Tue, 27 Mar 2012 16:57:36 GMT

SQL Server 2012 Express 下载及相关链接
http://www.microsoft.com/betaexperience/pd/SQLEXPCTAV2/zhcn/

安装 SQL Server 2012 的硬件和软件要求
http://msdn.microsoft.com/zh-cn/library/bb500459.aspx

SQL Server 2012 各个版本支持的功能对照表
http://msdn.microsoft.com/zh-cn/library/cc645993.aspx

SQL Server 2012 的版本和组件
http://msdn.microsoft.com/zh-cn/library/ms144275.aspx

按 SQL Server 版本划分的计算能力限制
http://msdn.microsoft.com/zh-cn/library/ms143760.aspx

SQL Server 2012 Native Client下载(x86)
http://download.microsoft.com/download/F/E/D/FEDB200F-DE2A-46D8-B661-D019DFE9D470/ENU/x86/sqlncli.msi

SQL Server 2012 Native Client下载(x64)
http://download.microsoft.com/download/F/E/D/FEDB200F-DE2A-46D8-B661-D019DFE9D470/ENU/x64/sqlncli.msi

Request.Cookies 和 Response.Cookies 的区别

Tue, 06 Mar 2012 17:41:47 GMT

.NET中提供了读写Cookie的多种方法，Request.Cookies 是客户端通过 Cookie 标头形式由客户端传输到服务器的 Cookie；Response.Cookies 在服务器上创建并以 Set-Cookie 标头的形式传输到客户端。也就是说，一个是客户端向服务器端发送的来的，一个是服务器发送到客户端的。

第一次创建Cookies的时候，下面的2种读取方法读取到的内容是一样：

C# 代码


HttpCookie hc = new HttpCookie("User2");

hc["UserName"] = "mengxianhui";

Response.Cookies.Add(hc);

    

Response.Cookies["User1"]["UserId"] = "net_lover";

    

Response.Write(Request.Cookies["User1"].Values["UserId"].ToString());

Response.Write(Request.Cookies["User2"].Values["UserName"].ToString());

Response.Write("<hr>");

Response.Write(Response.Cookies["User1"].Values["UserId"].ToString());

Response.Write(Response.Cookies["User2"].Values["UserName"].ToString());

但是，一旦Cookie存在，再使用上面的方法进行读取，结果是有差别的，Response.Cookies可以立即读取到新的Cookie，而Request.Cookies读取到仍是上一次设置的，也就是必须通过客户端向服务器发送请求时才能读取到。为什么会有这样的差别，应该是.NET实现的问题，里面有这么一段：

C# 代码


if (includeResponse && (this.Response != null))

{

    HttpCookieCollection cookies = this.Response.Cookies;

    if (cookies.Count > 0)

    {

        HttpCookie[] dest = new HttpCookie[cookies.Count];

        cookies.CopyTo(dest, 0);

        for (int i = 0; i < dest.Length; i++)

        {

            cookieCollection.AddCookie(dest[i], true);

        }

    }

}

在Cookie不存在时，它应该是读取Response.Cookies里面的Cookie了，所以第一次读取相同，而以后读取不同的原因吧。

另外，Response.Cookies必须是在设置完后读取，不能像Request.Cookies那样随时读取，如在别的页面读取Cookies，下面的方法就是错误的

C# 代码


protected void Page_Load(object sender, EventArgs e)

{

  Response.Write(Response.Cookies["User1"].Values["UserId"].ToString());

  Response.Write(Response.Cookies["User2"].Values["UserName"].ToString());

}

再谈 UNION ALL 和 ORDER BY NEWID 一起使用

Fri, 02 Mar 2012 13:47:19 GMT

当使用UNION ALL或者UNION时，如果按照NewId()随机排序，那么，不能直接写

SQL 代码


SELECT TOP 2 * FROM [Article] Where ArticleId < 100 Order By NewId()

UNION ALL 

SELECT TOP 8 * FROM [Article] Where ArticleId > 200 Order By NewId()

如果这样写，运行时会报告错误：在关键字 'UNION' 附近有语法错误。

需要写成

SQL 代码


SELECT * FROM (SELECT TOP 2 * FROM [Article] Where ArticleId < 100 Order By NewId()) A 

UNION ALL 

SELECT * FROM (SELECT TOP 8 * FROM [Article] Where ArticleId > 200 Order By NewId()) B

但是，这些，在SQL Server 2008里面是正确的，但在SQL Server2000里面，仍然会报告错误：如果语句中包含 UNION 运算符，那么 ORDER BY 子句中的项就必须出现在选择列表中。
在SQL Server 2000里面，需要写成

SQL 代码


SELECT * FROM (SELECT TOP 2 *, NewId() As RandomX FROM [Article] Where ArticleId < 100 Order By RandomX) A 

UNION ALL 

SELECT * FROM (SELECT TOP 8 *, NewId() As RandomX FROM [Article] Where ArticleId > 200 Order By RandomX) B

才可以正常执行。

C# 创建 Hashtable、Dictionary、ArrayList 等对象的简写方法

Mon, 27 Feb 2012 17:43:34 GMT

这个问题也是别人问到的，下面贴出来供大家参考。

C# 代码


  public class Person

  {

    public String Name { set; get; }

    public int Age { set; get; }

    public String Url { set; get; }

  }





  protected void Page_Load(object sender, EventArgs e)

  {

    //Dictionary 的简写形式

    Dictionary<int, String> dict = new Dictionary<int, string>() { { 1, "A" }, { 2, "BB" } };

    foreach (KeyValuePair<int, String> d in dict)

    {

      Response.Write("<li>" + d.Key + " = " + d.Value);

    }



    //Hashtable 的简写形式

    Hashtable myHash = new Hashtable() { { "key1", "AA" }, { "key2", "BB" } };

    foreach (DictionaryEntry d in myHash)

    {

      Response.Write("<li>" + d.Key + " = " + d.Value);

    }



    ArrayList ar = new ArrayList() { "A", "B", "C" };

    foreach (string d in ar)

    {

      Response.Write("<li>" + d);

    }



    //创建普通对象

    Person p = new Person() { Name = "net_lover", Age = 28, Url = "http://dotnet.aspx.cc" };

  }

一段创建IIS6网站、应用程序池、设置ASP.NET版本和应用程序名的代码

Wed, 22 Feb 2012 14:18:34 GMT

贴出来，以便查看。

C# 代码


string ScriptMaps = @".asp,C:\WINDOWS\system32\inetsrv\asp.dll,5,GET,HEAD,POST,TRACE

.cer,C:\WINDOWS\system32\inetsrv\asp.dll,5,GET,HEAD,POST,TRACE

.cdx,C:\WINDOWS\system32\inetsrv\asp.dll,5,GET,HEAD,POST,TRACE

.asa,C:\WINDOWS\system32\inetsrv\asp.dll,5,GET,HEAD,POST,TRACE

.idc,C:\WINDOWS\system32\inetsrv\httpodbc.dll,5,GET,POST

.shtm,C:\WINDOWS\system32\inetsrv\ssinc.dll,5,GET,POST

.shtml,C:\WINDOWS\system32\inetsrv\ssinc.dll,5,GET,POST

.stm,C:\WINDOWS\system32\inetsrv\ssinc.dll,5,GET,POST

.asax,C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll,5,GET,HEAD,POST,DEBUG

.ascx,C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll,5,GET,HEAD,POST,DEBUG

.ashx,C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll,1,GET,HEAD,POST,DEBUG

.asmx,C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll,1,GET,HEAD,POST,DEBUG

.aspx,C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll,1,GET,HEAD,POST,DEBUG

.axd,C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll,1,GET,HEAD,POST,DEBUG

.vsdisco,C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll,1,GET,HEAD,POST,DEBUG

.rem,C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll,1,GET,HEAD,POST,DEBUG

.soap,C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll,1,GET,HEAD,POST,DEBUG

.config,C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll,5,GET,HEAD,POST,DEBUG

.cs,C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll,5,GET,HEAD,POST,DEBUG

.csproj,C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll,5,GET,HEAD,POST,DEBUG

.vb,C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll,5,GET,HEAD,POST,DEBUG

.vbproj,C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll,5,GET,HEAD,POST,DEBUG

.webinfo,C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll,5,GET,HEAD,POST,DEBUG

.licx,C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll,5,GET,HEAD,POST,DEBUG

.resx,C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll,5,GET,HEAD,POST,DEBUG

.resources,C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll,5,GET,HEAD,POST,DEBUG

.xoml,C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll,1,GET,HEAD,POST,DEBUG

.rules,C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll,1,GET,HEAD,POST,DEBUG

.master,C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll,5,GET,HEAD,POST,DEBUG

.skin,C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll,5,GET,HEAD,POST,DEBUG

.compiled,C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll,5,GET,HEAD,POST,DEBUG

.browser,C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll,5,GET,HEAD,POST,DEBUG

.mdb,C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll,5,GET,HEAD,POST,DEBUG

.jsl,C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll,5,GET,HEAD,POST,DEBUG

.vjsproj,C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll,5,GET,HEAD,POST,DEBUG

.sitemap,C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll,5,GET,HEAD,POST,DEBUG

.msgx,C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll,1,GET,HEAD,POST,DEBUG

.ad,C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll,5,GET,HEAD,POST,DEBUG

.dd,C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll,5,GET,HEAD,POST,DEBUG

.ldd,C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll,5,GET,HEAD,POST,DEBUG

.sd,C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll,5,GET,HEAD,POST,DEBUG

.cd,C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll,5,GET,HEAD,POST,DEBUG

.adprototype,C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll,5,GET,HEAD,POST,DEBUG

.lddprototype,C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll,5,GET,HEAD,POST,DEBUG

.sdm,C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll,5,GET,HEAD,POST,DEBUG

.sdmDocument,C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll,5,GET,HEAD,POST,DEBUG

.ldb,C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll,5,GET,HEAD,POST,DEBUG

.svc,C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll,1,GET,HEAD,POST,DEBUG

.mdf,C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll,5,GET,HEAD,POST,DEBUG

.ldf,C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll,5,GET,HEAD,POST,DEBUG

.java,C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll,5,GET,HEAD,POST,DEBUG

.exclude,C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll,5,GET,HEAD,POST,DEBUG

.refresh,C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll,5,GET,HEAD,POST,DEBUG";



String[] ScriptMapsList = System.Text.RegularExpressions.Regex.Split(ScriptMaps, "\r\n");





///注意：这里没有进行进行端口存在的检查

// Access Flags

const int MD_ACCESS_READ = 0x00000001; //Allow read access.

const int MD_ACCESS_SCRIPT = 0x00000200; // Allow script execution.

String appPoolName = "MyPoolName";

DirectoryEntry newpool;

DirectoryEntry apppools = new DirectoryEntry("IIS://localhost/W3SVC/AppPools");

newpool = apppools.Children.Add(appPoolName, "IIsApplicationPool");

newpool.Properties["AppPoolIdentityType"][0] = "2";

newpool.Properties["IdleTimeout"][0] = 0;

newpool.Properties["MaxProcesses"][0] = 5;

newpool.CommitChanges();

//创建网站

DirectoryEntry Service = new DirectoryEntry("IIS://localhost/W3SVC");

DirectoryEntry Server;

int i = 0;

IEnumerator ie = Service.Children.GetEnumerator();



while (ie.MoveNext())

{

    Server = (DirectoryEntry)ie.Current;

    if (Server.SchemaClassName == "IIsWebServer")

    {

        if (Convert.ToInt32(Server.Name) > i)

            i = Convert.ToInt32(Server.Name);

    }

}



i++;





Server = Service.Children.Add(i.ToString(), "IIsWebServer");

Server.Properties["ServerBindings"].Value = ":8551:";

Server.Properties["ServerComment"][0] = "测试网站";

Server.CommitChanges();

DirectoryEntry root = Server.Children.Add("Root", "IIsWebVirtualDir");

root.Properties["Path"][0] = @"C:\b\xx";

root.Properties["AccessFlags"][0] = MD_ACCESS_READ | MD_ACCESS_SCRIPT;

root.Properties["ScriptMaps"].Value = ScriptMapsList;

root.Properties["AspEnableParentPaths"][0] = true;

root.Properties["AppRoot"][0] = "LM/W3SVC/" + i + "/Root";

root.Invoke("AppCreate", true);

root.CommitChanges();

//注意：AppFriendlyName必须放在root.Invoke("AppCreate", true);root.CommitChanges();之后。

root.Properties["AppFriendlyName"][0] = "我的测试网站";

root.CommitChanges();

object[] param = { 0, appPoolName, true };

root.Invoke("AppCreate3", param);

Server.Invoke("start", new object[0]);

Service.CommitChanges();

设置页面中的所有控件的某属性的方法

Wed, 08 Feb 2012 15:14:25 GMT

对于设置页面中所有控件的属性，需要使用递归的方法进行查找，并且可以使用反射去判断属性和设置属性值。代码如下：

ASPX 代码


<%@ Page Language="C#" AutoEventWireup="true" %>

<%@ Import Namespace="System.Reflection" %>

<%@ Import Namespace="System.ComponentModel" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"

"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<script runat="server">

  protected void Button1_Click(object sender, EventArgs e)

  {

    SetControlArrtibute(Page);

  }



  private void SetControlArrtibute(Control ctl)

  {

    Type type = ctl.GetType();

    PropertyInfo[] properties = type.GetProperties();

    Response.Write("<hr>");

    Response.Write(type.ToString());

    Response.Write("<br>");

    foreach (PropertyInfo property in properties)

    {

      // 不是所有的属性都能通过这种方法进行得到？

      if (property.Name == "Text" && property.PropertyType == typeof(String))

      {

        Response.Write("<li>" + property.Name + " = " + GetPropertyValue(ctl, property.Name));

      }

      if (property.Name.Equals("Enabled"))

      {

        Type propertyType = property.PropertyType;

        TypeConverter converter = TypeDescriptor.GetConverter(propertyType);

        Object arg = converter.ConvertFrom("false");

        object[] args = { arg };

        BindingFlags flags = BindingFlags.SetProperty;

        Binder binder = null;

        type.InvokeMember("Enabled", flags, binder, ctl, args);

      }

    }



    if (ctl.HasControls())

    {

      foreach (Control c in ctl.Controls)

      {

        SetControlArrtibute(c);

      }

    }

  }



  private String GetPropertyValue(Control control, String propertyName)

  {

    Type type = control.GetType();

    BindingFlags flags = BindingFlags.GetProperty;

    Binder binder = null;

    object[] args = null;

    object result = type.InvokeMember(propertyName, flags, binder, control, args);

    return Convert.ToString(result);

  }



  protected void Page_Load(object sender, EventArgs e)

  {

    if (!Page.IsPostBack)

    {

      GridView1.DataSource = new String[] { "A", "B" };

      GridView1.DataBind();

    }

  }

</script>

<head id="Head1" runat="server">

  <title></title>

</head>

<body>

  <form id="MengXianhuiForm" runat="server">

  <asp:TextBox ID="TextBox1" runat="server" Text="能输入文字吗"></asp:TextBox>

  <asp:ListBox ID="ListBox1" runat="server">

    <asp:ListItem>AA</asp:ListItem>

    <asp:ListItem>BB</asp:ListItem>

  </asp:ListBox>

  <asp:GridView ID="GridView1" runat="server">

    <Columns>

      <asp:TemplateField>

        <ItemTemplate>

          <asp:TextBox ID="x" runat="server" Text="测试" />

        </ItemTemplate>

      </asp:TemplateField>

    </Columns>

  </asp:GridView>

  <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="设置页面中的所有控件的 Enabled 属性" />

  </form>

</body>

</html>

使用C#创建Access2010或Access2007 accdb 数据库文件

Mon, 16 Jan 2012 10:27:36 GMT

C# 代码


/*

  * 前提条件，你需要先安装Microsoft Access Database Engine 2010 Redistributable 下载地址：

  * http://www.microsoft.com/downloads/zh-cn/details.aspx?familyid=c06b8369-60dd-4b64-a44b-84b371ede16d&displaylang=zh-cn

  * 需要注意的是：下载的版本跟你的程序编译的.NET版本一致，而不是跟操作系统的版本一致。

  * 

  * 需要添加引用 Microsoft ADO Ext. 2.8 for DDL and Security 文件位置：C:\Program Files (x86)\Common Files\System\ado\msadox28.tlb

  * 或者 Microsoft ADO Ext. 6.0 for DDL and Security 文件位置：C:\Program Files (x86)\Common Files\System\ado\msadox.dll

*/



//数据库名称可路径

String accdb = "K:\\xxx.accdb";

if (System.IO.File.Exists(accdb)) System.IO.File.Delete(accdb);

ADOX.Catalog cat = new ADOX.Catalog();

cat.Create("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + accdb);



ADOX.Table tbl = new ADOX.Table();

tbl.ParentCatalog = cat;

tbl.Name = "Table1";



//增加一个自动增长的字段

ADOX.Column col = new ADOX.Column();

col.ParentCatalog = cat;

col.Type = ADOX.DataTypeEnum.adInteger; // 必须先设置字段类型

col.Name = "id";

col.Properties["Jet OLEDB:Allow Zero Length"].Value = false;

col.Properties["AutoIncrement"].Value = true;

tbl.Columns.Append(col, ADOX.DataTypeEnum.adInteger, 0);



//增加一个文本字段

ADOX.Column col2 = new ADOX.Column();

col2.ParentCatalog = cat;

col2.Name = "Description";

col2.Properties["Jet OLEDB:Allow Zero Length"].Value = false;

tbl.Columns.Append(col2, ADOX.DataTypeEnum.adVarChar, 25);



//增加数字字段

ADOX.Column col3 = new ADOX.Column();

col3.ParentCatalog = cat;

col3.Name = "数字";

col3.Type = DataTypeEnum.adDouble;

col3.Properties["Jet OLEDB:Allow Zero Length"].Value = false;

tbl.Columns.Append(col3, ADOX.DataTypeEnum.adDouble, 666);



//增加Ole字段

ADOX.Column col4 = new ADOX.Column();

col4.ParentCatalog = cat;

col4.Name = "Ole类型";

col4.Type = DataTypeEnum.adLongVarBinary;

col4.Properties["Jet OLEDB:Allow Zero Length"].Value = false;

tbl.Columns.Append(col4, ADOX.DataTypeEnum.adLongVarBinary, 0);

//设置主键

tbl.Keys.Append("PrimaryKey", ADOX.KeyTypeEnum.adKeyPrimary, "id", "", "");

cat.Tables.Append(tbl);



System.Runtime.InteropServices.Marshal.ReleaseComObject(tbl);

System.Runtime.InteropServices.Marshal.ReleaseComObject(cat);

tbl = null;

cat = null;

GC.WaitForPendingFinalizers();

GC.Collect();

MessageBox.Show("创建完成！");

在 Java 中把 .NET 使用 Convert.ToBase64String 转换出的 Base64 字符串还原成文字

Fri, 06 Jan 2012 14:28:56 GMT

C#中生成Base64字符串：

C# 代码


Convert.ToBase64String(System.Text.Encoding.GetEncoding("GB2312").GetBytes("孟宪会"))

java 转换

Java 代码


String youtData = "w8/P3Lvh";

byte[] bytes = org.apache.ws.commons.util.Base64.decode(youtData);  

String decodedText = new String(bytes,"GB2312");

System.out.println("得到的字符串:" + decodedText);

在 Java 中把 .NET 使用 Convert.ToBase64String 转换出的 Base64 字符串还原成图片

Fri, 06 Jan 2012 14:17:23 GMT

.NET中，可以使用 Convert.ToBase64String(FileUpload1.FileBytes) 方法把上传的图片文件转换成 Base64 格式的字符串。

在 Java 中，引入 ws-commons-util-1.0.2.jar 包，或者 org.python.apache.xerces.impl.dv.util.Base64.decode(youtData)（ jython.jar）包使用下面的方法可以进行还原

Java 代码


String youtData = "R0lGODdhEAAQALMAAAAAAIAAAACAAICAAAAAgIAAgACAgMDAwICAgP8AAAD/AP//AAAA//8A/wD//////ywAAAAAEAAQAAAEOvDJSSt4K+u9r05gCGoel40kZqLpKb5ZySWm/NFc+cKLfv4LnC8IFKpwSKBnt+upTLUntPMAWK/YbAQAOw==";

byte[] imgBytes = org.apache.ws.commons.util.Base64.decode(youtData);  

FileOutputStream osf = new FileOutputStream(new File("i:\\yourImage.gif"));  

osf.write(imgBytes);  

osf.flush();  

osf.close();

在没有字段名的情况下，在 aspx 中使用绑定语法的方法

Wed, 04 Jan 2012 12:42:13 GMT

这种情况下，使用 <%#Container.DataItem%> 即可。例如

ASPX 代码


<%@ Page Language="C#" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<script runat="server">

  protected void Page_Load(object sender, EventArgs e)

  {

    List<string> list = new List<string>();

    for (int i = 0; i < 6; i++)

    {

      list.Add(i.ToString());

    }

    GridView1.DataSource = list;

    GridView1.DataBind();

    GridView2.DataSource = new String[]{"A","B"};

    GridView2.DataBind();

  }

</script>

<html xmlns="http://www.w3.org/1999/xhtml">

<head runat="server">

  <title></title>

</head>

<body>

  <form id="form1" runat="server">

  <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false">

    <Columns>

      <asp:TemplateField>

        <ItemTemplate>

          <asp:CheckBox ID="chk" runat="server" /><%#Container.DataItem%>

        </ItemTemplate>

      </asp:TemplateField>

    </Columns>

  </asp:GridView>

  <br />

  <asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="false">

    <Columns>

      <asp:TemplateField>

        <ItemTemplate>

          <asp:CheckBox ID="chk" runat="server" /><%#Container.DataItem%>

        </ItemTemplate>

      </asp:TemplateField>

    </Columns>

  </asp:GridView>

  </form>

</body>

</html>

得到 Windows 任务计划的列表

Fri, 30 Dec 2011 09:36:25 GMT

以下程序得到Windows任务计划列表：

C# 代码


/// <summary>

/// 需要引入 Microsoft.Win32.TaskScheduler.dll

/// 下载地址 http://taskscheduler.codeplex.com/releases/view/73297

/// using Microsoft.Win32.TaskScheduler;

public void button1_Click(object sender, EventArgs e)

{ 

  DataTable schedTable = new DataTable();

  schedTable.Columns.Add(new DataColumn("Name", typeof(string)));

  schedTable.Columns.Add(new DataColumn("Schedule", typeof(string)));

  schedTable.Columns.Add(new DataColumn("NextRunTime", typeof(DateTime)));

  schedTable.Columns.Add(new DataColumn("LastRunTime", typeof(DateTime)));

  schedTable.Columns.Add(new DataColumn("TaskState", typeof(Enum)));

  schedTable.Columns.Add(new DataColumn("Enabled", typeof(Boolean)));

  schedTable.Columns.Add(new DataColumn("Description", typeof(string)));



  List<Task> tasks = new List<Task>();

  using (TaskService ts = new TaskService())

  {

    Version ver = ts.HighestSupportedVersion;

    bool newVer = (ver >= new Version(1, 2));       

    TaskFolder tf = ts.RootFolder;

    // 得到目录下的所有任务计划

    foreach (Task t in tf.Tasks)

    {

      tasks.Add(t);

      string trStr = "";

      DataRow r = schedTable.NewRow();

      try

      {

        this.textBox1.AppendText(t.Name + Environment.NewLine);

        r["Name"] = t.Name;

        foreach (Trigger tr in t.Definition.Triggers)

        {

          if (trStr != "")

            trStr += ";";

          trStr += tr.ToString();

        }

        r["Schedule"] = trStr;

        r["NextRunTime"] = t.NextRunTime;

        r["LastRunTime"] = t.LastRunTime;

        r["TaskState"] = t.State;

        r["Enabled"] = t.Enabled;

        r["Description"] = t.Definition.RegistrationInfo.Description;

        schedTable.Rows.Add(r);

      }

      catch { }

    }

  }

}

得到本机数据库实例的两种方法

Thu, 15 Dec 2011 11:42:17 GMT

代码：

ASPX 代码


<%@ Page Language="C#" %>



<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<script runat="server">

  protected void Page_Load(object sender, EventArgs e)

  {

    //方法1

    System.Data.DataTable table = System.Data.SqlClient.SqlClientFactory.Instance.CreateDataSourceEnumerator().GetDataSources();

    GridView1.DataSource = table;

    GridView1.DataBind();



    //得到本机的

    foreach (System.Data.DataRow row in table.Rows)

    {

      if (row[0].ToString().ToUpper().Equals(System.Net.Dns.GetHostName().ToUpper()))

      {

        Response.Write("<li>" + row[1]);

      }

    }



    //方法2

    //需要引用 Microsoft.SqlServer.Smo.dll

    GridView2.DataSource = Microsoft.SqlServer.Management.Smo.SmoApplication.EnumAvailableSqlServers(true);

    GridView2.DataBind();

  }

</script>

<html xmlns="http://www.w3.org/1999/xhtml">

<head id="Head1" runat="server">

  <title></title>

</head>

<body>

  <form id="form1" runat="server">

  <asp:GridView ID="GridView1" runat="server">

  </asp:GridView>

  <asp:GridView ID="GridView2" runat="server">

  </asp:GridView>

  </form>

</body>

</html>