ConnectDB

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

using System.Web.Configuration;
using System.Data;
using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
       
       

        string sqlcmd ="select top 20 id,test_time,title,summary from test";
       

    }

    private void ConnectDB(string ConnectionString,string sqlcmd)
    {
       
          SqlConnection Conn = new SqlConnection();
          Conn.ConnectionString = WebConfigurationManager.ConnectionStrings[ConnectionString].ConnectionString;
          SqlDataReader dr = null;
         
          SqlCommand cmd = new SqlCommand(sqlcmd,Conn);

          try
          {
              Conn.Open();
              dr = cmd.ExecuteReader();
              while (dr.Read())
              {

              }

          }
          catch (Exception ex)
          {
              Response.Write("<b>Error Message----</b>" + ex.ToString());
          }
          finally {
              if (dr != null) {
                  cmd.Cancel();
                  dr.Close();
              }
              if (Conn.State == ConnectionState.Open) {
                  Conn.Close();
                  Conn.Dispose();
              }
         
          }
   
    }
}

要怎麼做到按下按鈕後跳出新視窗(open new window)，在新視窗輸入內容(Ex.帳號密碼)後回傳(return value)的效果

http://catchtest.pixnet.net/blog/post/28219055-asp.net-%E4%BD%BF%E7%94%A8%E7%AD%86%E8%A8%98

【JavaScript】在ASP.NET 呼叫 JavaScript

http://irismyself.pixnet.net/blog/post/12388073-%E3%80%90asp.net%E3%80%91%E3%80%90javascript%E3%80%91%E5%9C%A8asp.net-%E5%91%BC%E5%8F%AB-javascript-

套用MasterPage後，如何動態新增控制項

http://www.dotblogs.com.tw/hatelove/archive/2011/11/30/how-to-dynamically-add-controls-in-masterpage.aspx

ASP.NET 神奇FindControl方法

http://weisnote.blogspot.tw/2012/03/aspnet-findcontrol.html

DropDownList

for (int i = 0; i < (int)DropDownList1.Items.Count; i++)

        {

            if (DropDownList1.Items[i].Selected)

            {

                Session["my_color"] = DropDownList1.Items[i].Value;

                Session["my_name"] = TextBox1.Text;

                Response.Redirect("AJAX_Case_2.aspx");   //--前往聊天室的主畫面（AJAX版）

            }

        }

[MSSQL]bcp Unicode 選項 -w

http://msdn.microsoft.com/zh-tw/library/ms188289.aspx