首先必須下載 MySQL Connector Net 程式：

官方下載網址：http://dev.mysql.com/downloads/connector/net/
本地下載：mysql-connector-net-6.5.4-noinstall

讀取資料表：

using MySql.Data.MySqlClient;
MySqlConnection con = new MySqlConnection(String.Format("Server={0};Port={1};Database={2};Uid={3};Pwd={4};connection timeout={5};use compression={6};pooling={7};min pool size={8};max pool size={9};", "127.0.0.1", "3306", "Database", "UserID", "Password", "5", "True", "False", "5", "100"));
con.Open();
DataSet DS = new DataSet();
MySqlDataAdapter DT = new MySqlDataAdapter("SELECT * FROM XXXX", con);
DT.SelectCommand.CommandTimeout = 60;
DT.Fill(DS);
DT.Dispose();
con.Close();
con.Dispose();
con = null;

新增和修改就不寫瞜！只需要把 SQL 指令改掉即可！

以下為常見的動態 DNS 網址，如果要防止動態 DNS，可以利用以下名單喔！

ath.cx
blogdns.com
blogdns.net
blogdns.org
blogsite.org
boldlygoingnowhere.org
dnsalias.com
dnsalias.net
dnsalias.org
dnsdojo.com
dnsdojo.net
dnsdojo.org
doesntexist.com
doesntexist.org
dontexist.com
dontexist.net
dontexist.org
dvrdns.org
dyn-o-saur.com
dynalias.com
dynalias.net
dynalias.org
dyndns.biz
dyndns.info
dyndns.org
dyndns.tv
dyndns.ws
endofinternet.net
endofinternet.org
endoftheinternet.org
ftpaccess.cc
game-host.org
game-server.cc
getmyip.com
go.dyndns.org
gotdns.com
gotdns.org
ham-radio-op.net
hobby-site.com
hobby-site.org
home.dyndns.org
homedns.org
homeftp.net
homeftp.org
homeip.net
homelinux.com
homelinux.net
homelinux.org
homeunix.com
homeunix.net
homeunix.org
is-a-chef.com
is-a-chef.net
is-a-chef.org
is-a-geek.com
is-a-geek.net
is-a-geek.org
isa-geek.com
isa-geek.net
isa-geek.org
kicks-ass.net
kicks-ass.org
merseine.nu
mine.nu
mypets.ws
myphotos.cc
office-on-the.net
podzone.net
podzone.org
scrapper-site.net
scrapping.cc
selfip.biz
selfip.com
selfip.info
selfip.net
selfip.org
servebbs.com
servebbs.net
servebbs.org
serveftp.net
serveftp.org
servegame.org
shacknet.nu
thruhere.net
webhop.biz
webhop.info
webhop.net
webhop.org
3322.org
2288.org
6600.org
7700.org
8800.org
8866.org
9966.org
3d-game.com
4irc.com
b0ne.com
bbsindex.com
chatnook.com
darktech.org
deaftone.com
dtdns.net
effers.com
etowns.net
etowns.org
flnet.org
gotgeeks.com
scieron.com
slyip.com
slyip.net
suroot.com
stufftoread.com
no-ip.ca
no-ip.net
damnserver.com
unusualperson.com
dnsiskinky.com
quicksytes.com
myactivedirectory.com
homesecuritypc.com
pointto.us
geekgalaxy.com
net-freaks.com
ditchyourip.com
workisboring.com
servep2p.com
securitytactics.com
homesecuritymac.om
serveexchange.com
blogsyte.com
securityexploits.com
ciscofreak.com
point2this.com
no-ip.co.uk
servehumour.com
mymediapc.net
cable-modem.org
mypsx.net
everydns.net
everydns.com
everydns.org
1dumb.com
25u.com
2waky.com
3-a.net
3feet.COM
4dq.com
4MyDomain.Com
4pu.com
acmetoy.com
AlmostMy.COM
americanunfinished.com
BigMoney.biz
changeip.name
changeip.net
changeip.org
compress.to
ddns.info
ddns.me.uk
ddns.mobi
ddns.ms
ddns.name
ddns.us
dhcp.biz
dns-dns.com
dns-stuff.com
dns04.com
dns05.com
dns1.us
dns2.us
dnset.com
dnsrd.com
DSMTP.COM
dumb1.com
dynamic-dns.net
dynamicDNS.biz
dynamicdns.co.uk
dynamicdns.me.uk
dynamicdns.org.uk
dyndns.pro
dynssl.COM
eDNS.biz
epac.to
eSMTP.biz
ezua.COM
FAQServ.com
FartIT.com
freeddns.com
freeTCP.com
freeWWW.biz
freeWWW.info
ftp1.biz
ftpserver.biz
GetTrials.COM
Got-Game.org
gr8domain.biz
gr8name.biz
h1x.com
ikwb.COM
InstantHQ.com
IsASecret.com
ItemDB.com
itsAOL.com
JetOS.com
Jkub.com
jungleheart.com
justdied.com
lflink.COM
LfLinkup.COM
LfLinkup.NET
LfLinkup.ORG
longmusic.com
mefound.com
moneyhome.biz
MrBasic.com
MrBonus.com
MrFace.com
MrsLove.com
my03.com
myDad.info
myDDNS.com
myFTP.info
myFtp.name
MyLFTV.COM
myMom.info
MyNetAV.NET
MyNetAV.ORG
mynumber.ORG
myPicture.info
mysecondarydns.com
myWWW.biz
myZ.info
ninth.biz
ns01.biz
ns01.info
ns01.us
ns02.biz
ns02.info
ns02.us
ns1.name
ns2.name
ns3.name
oCry.com
onedumb.com
organiccrap.com
oTZO.com
OurHobby.com
pcanywhere.NET
port25.biz
PORTRELAY.COM
ProxyDNS.com
qHigh.com
qpoe.com
REBATESRULE.NET
sellClassics.com
sendsmtp.COM
ServeUser.com
ServeUsers.com
sexidude.com
sexxxy.biz
sixth.biz
Squirly.info
toh.info
toythieves.com
trickip.NET
trickip.ORG
VizVaz.com
wha.la
wikaba.com
www1.biz
wwwhost.biz
x24HR.com
xxuz.com
xxxy.biz
xxxy.info
YGTO.com
youdontcare.com
yourtrap.com
zyns.com
zzux.com

以下為常見的拋棄信箱網址，如果要防止拋棄信箱註冊，可以利用以下名單喔！

pcmail.com.tw
m2k.com.tw
spamgourmet.com
mailinator.com
jetable.net
jetable.com
jetable.org
bsnow.net
spambox.us
nowmymail.com
dodgit.com
tempinbox.com
trashmail.net
pookmail.com
guerrillamailblock.com
getonemail.com
maileater.com
mintemail.com
trashymail.com
mytrashmail.com
mt2009.com
nospamfor.us
nospam4.us
mailexpire.com
spam.la
spambob.com
spamfree24
spaml.com
tempemail.net
tempomail.fr
temporaryinbox.com
wh4f.org
trashmail.net
spambog.com
spambog.de
discardmail.com
discardmail.de
discardmail.de
spambog.ru
cust.in
imails.info
great-host.in
tewars.org
kulturbetrieb.info
bio-muesli.net
bio-muesli.info
0815.ru
sandelf.de
recode.me
3d-painting.com
nomail2me.com
mailinator2.com
sogetthis.com
mailin8r.com
mailinator.net
spamherelots.com
thisisnotmyrealemail.com
rtrtr.com
dingbone.com
fudgerub.com
lookugly.com
smellfear.com
sharklasers.com
guerrillamail.com
guerrillamail.net
guerrillamail.biz
guerrillamail.org
guerrillamail.de

本篇利用 FTP Class 連線到 FTP，並且將檔案列出來！

FtpConnection connection = new FtpConnection();
connection.MessageReceived += new FtpConnectionEventHandler(Ftp.connection_MessageReceived);
connection.Host = "ftp://xxx.xxx.xxx/";
connection.UserName = "xxx";
connection.Password = "xxxxxx";
connection.RemoteDirectory = "";
//列出資料夾內的檔案及資料夾
List<string> files = connection.ListDirectory();
foreach (string file in files)
{
          Response.Write(file + "<br>");
}

範例檔案：Ftp_List

本篇利用 PHP 取得某網站 HTTP 的網站內容 HTML。

建立一個 class ，例如 Http_Client.class 內容如下：

<?
class HTTP_Client
{
	var $connect	= null;
	var $ip			= null;	
	var $error		= null;
	var $errno		= null;

	function HTTP_Client ($ip, $port = 80, $timeout = 30)
	{
		if (empty($ip)) return false;
		$this->connect = fsockopen($ip, $port, $this->error, $this->errno, $timeout);
		if ($this->connect) {
			$this->ip = $ip;
		}
	}

	//POST
	function post ($path, $date)
	{
		fputs($this->connect, "POST $path HTTP/1.1\n");
		fputs($this->connect, "Host: ". $this->ip ."\n");
		fputs($this->connect, "Content-type: application/x-www-form-urlencoded\n");
		fputs($this->connect, "Content-length: ". strlen($date) ."\n");
		fputs($this->connect, "User-Agent: MSIE\n");
		fputs($this->connect, "Connection: close\n\n");
		fputs($this->connect, "$date");		

		while (!feof($this->connect)) {
			$buffer .= fgets($this->connect,128);
		}
		return $buffer;
	}

	//GET
	function get ($path = "/", $arraydata = array())
	{
		if (is_array($arraydata)) {
			foreach ($arraydata as $var => $value) {
				$data .= (++$i==1) ? "$var=$value" : "&$var=$value";
			}
		} else {
			return false;
		}

		if ($data) $path .= "$data";

		fputs($this->connect, "GET $path HTTP/1.1\n");
		fputs($this->connect, "Host: ". $this->ip ."\n");
		fputs($this->connect, "User-Agent: MSIE\n");
		fputs($this->connect, "Connection: close\n\n");

		while (!feof($this->connect)) {
			$buffer .= fgets($this->connect,128);
		}
		return $buffer;
	}

	//Clear Title
	function clear($data)
	{
		$dataArray = split("\r\n\r\n",$data);
		return str_replace($dataArray[0],"",$data);
	}

	//關閉連線
	function close ()
	{
		return fclose ($this->connect);
	}
}
?>

官方網站下載：http://www.fusioncharts.com/goodies/fusioncharts-free/

本地下載：FusionChartsFree

官方網站下載：http://datatables.net/

本地下載：DataTables-1.9.2

官方網站下載：http://www.filamentgroup.com/lab/date_range_picker_using_jquery_ui_16_and_jquery_ui_css_framework/

本地下載：FilamentGroup_daterangepicker

官方網站：http://www.maxmind.com/app/ip-location

本地下載：csharp2_1.8

※請自行去官方網站下載最新版的 GeoIP.dat。  

本地下載的檔案包含範例，如下圖所示：

只需利用 GeoIP 的 API 功能即可輕鬆取的 IP 相關資訊。

webcamXP - 整合了 HTTP 網頁伺服器功能的 WebCam 網路攝影機伺服器軟體，藉由它，您可以將網路攝影機所拍攝的內容即時分享給網路上的任何人，可以一次支援多個 WebCam！

• 可以錄影，也可以擷取圖檔，能存在硬碟，也能上傳圖檔到遠端的FTP伺服器。
• 可以同時管理多台webcam(webcamXP的免費版本只能管理一台)。
• 具遠端監看功能，可以將影像做即時轉播，直接輸入網址即可觀看。
• 有聊天室功能，邊看影像邊聊天。
• webcamXP支援javascript,flash等多種格式，可將影像直接內嵌在網頁裡。
• 可以管理使用者帳號，並設定每個帳號觀看的時間(免費版無此功能)。
• 有異動偵測的功能(免費版本不支援)。

官方網站下載：http://www.webcamxp.com/

本地下載：wlite551  

可以設定多組監視器：