Maxwell Tech Note

[.NET] HTML Parser --HTML Agility Pack

2012-02-02T14:13:00.004+08:00

HTML Agility Pack 提供了用XPath去分析 html的結構的功能用於要抓網站資料的時候很有用下面是用 HTML Agility Pack以Xpath的語法去抓yahoo股市資料的code Dim client As New WebClient() Dim sr As Stream = client.OpenRead("http://tw.stock.yahoo.com/q/q?s=2409") Dim doc As New HtmlAgilityPack.HtmlDocument() doc.Load(sr, System.Text.Encoding.GetEncoding("big5")) Dim nodes As HtmlAgilityPack.HtmlNodeCollection = doc.DocumentNode.SelectNodes("/

[JQuery]getJSON

2012-01-31T18:46:00.001+08:00

$.getJSON(Url, {DataKey:"Value"}, function(json){ alert(json); }); getJSON()

[ASP.net] Useful JSON Library：Json.NET

2012-01-31T15:46:00.001+08:00

How to use it's very Simple: Dim json As New JsonSerializer() json.NullValueHandling = NullValueHandling.Ignore Dim sb As New StringBuilder Dim sw As New IO.StringWriter(sb) Dim jw As New JsonTextWriter(sw) json.Serialize(jw, ObjectToJson) Response.Write(sb.ToString) Download JSon.net

100+ jquery插件應用(引用)

2012-01-13T16:41:00.004+08:00

File upload-文件上傳 Ajax File Upload jQUploader Multiple File Upload plugin jQuery File Style Styling an input type file Progress Bar Plugin Form Validation-表單驗證 jQuery Validation Auto Help Simple jQuery form validation jQuery XAV - form validations jQuery AlphaNumeric Masked Input TypeWatch Plugin Text limiter for form fields Ajax Username Check with jQuery Form - Select Box

好用的JQuery Photo Dialog

2012-01-12T10:16:00.000+08:00

fancybox ColorBox thickbox Jquery Tools http://valums.com/javascript-image-galleries/

User JQuery Dialog for Image

2012-01-11T17:43:00.003+08:00

JQuery Ajax

2012-01-04T18:20:00.001+08:00

$.ajax({ type: "post", url: "URL", data: { paraName: paraValue}, cache: "false", success: function(result) { } //success }); //$.ajax JQuery Ajax http://www.w3school.com.cn/jquery/ajax_ajax.asp

jQuery Selectors

2011-12-30T16:01:00.003+08:00

http://webdesign.kerthis.com/jquery/jquery_selectors

Facebook Meta and link link

2011-12-21T01:35:00.001+08:00

Facebook link debugging http://developers.facebook.com/tools/debug Open Graph Protocol http://ogp.me/

[jQuery] CheckBox

2011-12-12T17:33:00.002+08:00

Detect Checkbox checked $("#Checkbox ID").is(':checked') true / false Checkbox disabled $("# ID").attr("disabled","disabled"); $("#ID").removeAttr("disabled");

The ‘Microsoft.ACE.OLEDB.12.0′ provider is not registered on the local machine.

2011-10-24T13:01:00.001+08:00

The ‘Microsoft.ACE.OLEDB.12.0′ provider is not registered on the local machine.When running 64-bit windows and there are no MS Access drivers that run 64 bit.So to resolve it you need to change the build configuration to x86 found in the programs properties.Then click on Build and change the Platform target from Any CPU to x86.Recompile your program , it works like charm.http://

win2003 server 臨時授權已過期

2011-09-21T15:45:00.000+08:00

果要修正這個問題，請在「終端機服務設定」中將授權模式變更為「每個使用者」。如果要執行這項操作，請依照下列步驟執行： 1. 按一下 [開始]，指向 [系統管理工具]，然後按一下 [終端機服務設定]。 2. 按一下 [伺服器設定]，然後按兩下 [授權模式]。 3. 將 [授權模式] 變更為 [每個使用者]，然後按一下 [確定]。目前 Windows Server 2003 不會管理使用者 CAL。也就是說，雖然授權伺服器資料庫中有使用者 CAL，但就算使用了使用者 CAL，使用者 CAL 也不會減少。這並不表示系統管理員不需要符合使用者授權合約 (EULA) 中，讓每個使用者具有有效終端機伺服器 (TS) CAL 的需求。如果不是要使用裝置 CAL，卻沒有讓每個使用者都具有使用者 CAL，就是違反 EULA。

[SQL server]手動將結構描述改成dbo

2011-09-11T01:01:00.000+08:00

手動將結構描述改為dbo 開啟Microsoft SQL Server Management Studio==>選擇該資料庫==>選擇資料表，其結構描述為使用者名稱的==>到資料表上按滑鼠右鍵，選擇設計==>在屬性中選結構描述==>變更擁有者為dbo，存檔==>擁有者就改為dbo，就可刪除帳號即可

Google API for .net

2011-09-05T10:49:00.001+08:00

http://code.google.com/p/google-api-dotnet-client/ 記錄一下有天應該會用到的

[asp]asp + JSON

2011-07-20T18:18:00.004+08:00

送出Json的asp <% Dim member Set member = jsObject() member("name") = "MAX" member("surname") = "max" member("message") = "Hello World" member.Flush %>接收json的asp<!DOCTYPE html><html><head><script src="http://code.jquery.com/jquery-latest.js"></script></head><body><div id="dname"></div><script>$.getJSON("jsonTest.asp", function(data) {$("#dname").

[JQuery]checkbox 是否被選取或checked設定

2011-06-14T18:50:00.001+08:00

set $("#your-checkbox-id").attr('checked') $("#your-checkbox-id").removeAttr('checked')判斷 if ( $("#your-checkbox-id").attr('checked') ) { something(); }

[ASP] Use HashTable In asp

2011-06-01T16:45:00.003+08:00

用CreateObject("Scripting.Dictionary") 來產生 hashtableSet MyHash = CreateObject("Scripting.Dictionary") MyHash.Add "key", "Value" hashKeys = MyHash.keys for each k in MyHash.keys responsew.write( MyHash.Item(k)) next VBScript » Objects » Dictionary

[jQuery]JQuery Validation and Ajax

2011-05-19T16:00:00.008+08:00

imports jquery.min.jsimports jquery.validate.min.js[Ajax]function callAjax(){$.ajax({type: "POST", url: "ajax.asp", data: {fun: "checkCardNO", CardNo: $("#CardNo").val()}, dataType:"html", success:function(msg){ $("#AjaxValue").val(msg); /* Use Hidden input or div to transfer Ajax Value */ }}) }[Form Validation]--Add Validation Function$.validator.addMethod("checkRegisterd",

Autoruns for Windows v10.07

2011-05-11T11:02:00.000+08:00

An useful software.Autoruns for windows IntroductionThis utility, which has the most comprehensive knowledge of auto-starting locations of any startup monitor, shows you what programs are configured to run during system bootup or login, and shows you the entries in the order Windows processes them. These programs include ones in your startup folder, Run, RunOnce, and other Registry keys. You can

JQuery Select Sample

2011-04-14T16:24:00.006+08:00

JavaScript <script language="javascript" src="js/jquery-1.5.2.min.js"></script> <script language="javascript" > function ShowSelect() { $("select#Label option:selected'").each(function(){ $("#selectedItem").append(this); }); } </script>HTML:<select name="Label" size="15" multiple="multiple" id="Label"> <option value="1">1</option> <option>2</option> <option>3</option> <option>4</

GUID For ASP

2011-03-10T12:08:00.002+08:00

Function GetGuid() Set TypeLib = Server.CreateObject("Scriptlet.TypeLib") GetGuid = TypeLib.Guid Set TypeLib = NothingEnd Function

[C#]Determine Whether a String Represents a Numeric Value

2011-02-09T15:24:00.003+08:00

TryParse for Int32, long, byte, and decimalreturn BooleanInt32.TryParse( s as String, ref i as int32) [VB]Int32.TryParse(String s, out int32 i) [C#]long.TryParse( s as String, ref i as int32) [VB]long.TryParse(String s, out int32 i) [C#] int32.TryParse(s, out i)http://msdn.microsoft.com/zh-tw/library/bb384043.aspx

T-SQL Cursor Loop Sample

2010-12-24T11:23:00.001+08:00

GODECLARE @value1 varchar(50)DECLARE @value2 varchar(50)DECLARE my_cursor CURSOR FORSELECT Value1,value2 FROM TableNameOPEN my_cursorFETCH NEXT FROM my_cursorINTO @value1,@value2WHILE @@FETCH_STATUS = 0BEGINprint @value1 + ':' + @value2 /*Main Process Start*/ FETCH NEXT FROM my_cursor INTO @value1,@value2endCLOSE my_cursorDEALLOCATE my_cursor

SQL server create Schema

2010-11-13T18:29:00.000+08:00

if not exists(select 1 from information_schema.schemata whereschema_name='testtest')EXEC ('create schema TestTest AUTHORIZATION testuser');go

R Project with ODBC

2010-10-05T15:53:00.001+08:00

1.Setting ODBC in windows Control panel2.install R package "RODBC"3.In R Command Line > library(RODBC) > channel = odbcConnect("$ODBC_Name") //Create Connection > odbcGetInfo(channel) //Get odbc connection info > odbcQuery(channel,"$SQL_command") //Set SQL Command String > sqlGetResults(channel, max=$TopNumber) //get top N Data