工作需要筆記

<link rel="shortcut icon" href="/favicon.ico" type="image/x-icon">
<link rel="icon" href="/favicon.ico" type="image/x-icon">

http://www.favicon-generator.org/

<ul>

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

DataView dv = new DataView(dt會員);
dv.Sort = "序號 " + "DESC";   //排序
dv.RowFilter = "序號<20";     //查詢條件
dv.RowFilter = "暱稱 like '%會員%'";     //查詢條件
GridView1.DataSource = dv;
GridView1.DataBind();

http://www.dotblogs.com.tw/yc421206/archive/2009/10/18/11095.aspx

private DataTable 產生dataTable()
    {
        DataTable dt = new DataTable();
        DataRow dr;
        dt.Columns.Add(new System.Data.DataColumn("姓名", typeof(string)));
        dt.Columns.Add(new System.Data.DataColumn("電話", typeof(string)));
        SqlDataReader dr會員 = xdb.查詢_會員();
        while (dr會員.Read())
        {
            dr = dt.NewRow();
            dr[0] = dr會員["姓名"].ToString();
            dr[1] = dr會員["電話"].ToString();
            dt.Rows.Add(dr);
        }        
        return dt;
    }

//之後再加上欄位內容
        for (int i = 0; i < dt會員.Rows.Count; i++)
        {
            dt會員.Rows[i][2] = i;
        }

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Configuration;
using System.Data;
using System.Data.SqlClient;

/// 
/// db 的摘要描述
/// 
public class db
{
    public string DB連線字串 = WebConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
        public db()
        {
                //
                // TODO: 在這裡新增建構函式邏輯
                //
        }
    public SqlConnection 資料庫連線(string connString)
    {
        try
        {
            SqlConnection connDB = new SqlConnection(connString);
            connDB.Open();
            return connDB;
        }
        catch (SqlException ex)
        {
            throw (ex);
        }
    }
    int errCode = 0;
    //***************** 查詢_會員 ***************** 
    public DataSet 查詢_會員(int 第n頁,int 筆數)
    {
        SqlConnection conn = this.資料庫連線(DB連線字串);
        if (conn == null) { errCode = 1; }

        SqlDataAdapter da = new SqlDataAdapter("EXECUTE 會員_查詢", conn);
        DataSet ds = new DataSet();        
        try
        {
            da.Fill(ds, 第n頁, 筆數, "會員清單");
        }
        catch (Exception ex)
        {
            errCode = 1;
        }
        if (conn != null) { conn.Close(); conn.Dispose(); conn = null; }    //連線關閉
        return ds;
    }    
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;

private DataTable GetData()
    {
        DataTable dt = new DataTable();
        DataRow dr;
        dt.Columns.Add(new System.Data.DataColumn("Column1", typeof(int)));
        dt.Columns.Add(new System.Data.DataColumn("Column2", typeof(String)));
        dt.Columns.Add(new System.Data.DataColumn("Column3", typeof(String)));
        dt.Columns.Add(new System.Data.DataColumn("Column4", typeof(String)));
        dt.Columns.Add(new System.Data.DataColumn("Column5", typeof(int)));
        dt.Columns.Add(new System.Data.DataColumn("Column6", typeof(int)));
        dt.Columns.Add(new System.Data.DataColumn("Column7", typeof(int)));
        dt.Columns.Add(new System.Data.DataColumn("Column8", typeof(int)));
        dt.Columns.Add(new System.Data.DataColumn("Column9", typeof(int)));
        dt.Columns.Add(new System.Data.DataColumn("Column10", typeof(String)));
        dt.Columns.Add(new System.Data.DataColumn("Column11", typeof(String)));
        int totalprice = 0;
        List orderlist = (List)Session["orderlist_session"];
        if (orderlist != null)
        {
            int i = 0;
            foreach (orderProdObj element in orderlist)
            {
                dr = dt.NewRow();
                dr[0] = i;
                dr[1] = element.name;
                dr[2] = element.colorName;
                dr[3] = element.size;
                dr[4] = Convert.ToInt16(element.count);
                dr[5] = Convert.ToInt16(element.totalCount);
                dr[6] = Convert.ToInt16(element.buyPrice);
                dr[7] = Convert.ToInt16(element.count) * Convert.ToInt16(element.buyPrice);
                dr[8] = element.no;
                dr[9] = element.prodDLink;
                dr[10] = element.prodImg;
                dt.Rows.Add(dr);
                totalprice = totalprice + (Convert.ToInt16(element.count) * Convert.ToInt16(element.buyPrice));
                i++;
            }
        }
        totalText.Value = totalprice.ToString();
        //Response.Write(totalprice);

        return dt;

    }

Convert.ToInt32、int.Parse（Int32.Parse）、int.TryParse、(int) 四者都可以解釋為將類型轉換為 int，那它們的區別是什麼呢？
Convert.ToInt32 與 int.Parse 較為類似，實際上 Convert.ToInt32 內部調用了 int.Parse：

string URI ="http://www.myurl.com/post.php";
string myParameters ="param1=value1&param2=value2&param3=value3";

using (WebClient wc =newWebClient()){

if(rw.Cells[i].Value==null|| rw.Cells[i].Value==DBNull.Value||String.IsNullOrWhitespace(rw.Cells[i].Value.ToString())

using (System.IO.StreamWriter file = new System.IO.StreamWriter(@"C:\Users\Public\TestFolder\WriteLines2.txt", true))
        {
            file.WriteLine("Fourth line");
        }

<ul class="teamlist" style="<%# Eval("論壇識別").ToString() == "2"?"display:none;":"display:block;"%>">

public class Class1

   2:  {

   3:      #region 主要程式碼

   4:      public Class1() { 

   5:          

   6:          //一堆程式碼

   7:          //.......

   8:          //.......

   9:      }

  10:      #endregion

  11:   

  12:      public int  Add(int a,int b) {

  13:          return a + b;

  14:      }

  15:  }

http://www.dotblogs.com.tw/holiestar/archive/2013/12/07/132865.aspx

<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.2/jquery.min.js"></script>
<script>

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

http://geekswithblogs.net/dotNETvinz/archive/2009/08/13/bind-datatable-to-datalist-control.aspx

<asp:TextBox ID="txt_date" runat="server" class="form-control" style="width:263px;" TextMode="Date"></asp:TextBox>

<asp:RangeValidator ID="RangeValidator1" runat="server" ErrorMessage="※日期需介於1900/01/01 ~ 2100/01/01" ControlToValidate="txt_date" MinimumValue="1900/01/01" MaximumValue="2100/01/01" Type="Date" Display="Dynamic"></asp:RangeValidator>

TextBox1.Text.Replace(System.Environment.NewLine, “<br>”);

HttpUtility.HtmlEncode(xxxx);

http://www.c-sharpcorner.com/UploadFile/0c1bb2/display-country-list-without-database-in-Asp-Net-C-Sharp/

web.config

HtmlMeta tag =newHtmlMeta();
tag.Attributes.Add("property","og:title");
tag.Content="MyTitle";// don't HtmlEncode() string. HtmlMeta already escapes characters.
Page.Header.Controls.Add(tag);