涂聚文的专栏

/// /// 請假輸入兩個日期：（只考慮最多相差一個月）对于不同月份的数据考虑月份数据分界 /// /// /// private void button1_Click(object sender, EventArgs e) { DateTime en

//選擇節點 OnNodeSelectedScript="nodeSelectHandler(elem);" function nodeSelectHandler(elem){ var val = "selected node:" + elem.parentNode.getAttribute("treeNodeValue"); var vals=elem.parentNode

//Csharp:WebClient and WebRequest use http download file //20140318 塗聚文收錄 string filePath = "20140302.pdf"; string fileName = "http://www.dusystem.com/3.pdf";

using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;using Sy

using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;using Sy

/// /// http://www.weather.com.cn/data/sk/101280601.html /// {"weatherinfo":{"city":"深圳","cityid":"101280601","temp":"32","WD":"西南风","WS":"4级","SD":"68%","WSE":"4","time":"16:40","isRadar"

using System;using System.Data;using System.Configuration;using System.Collections;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using

using System; using System.Collections.Generic; using System.Text; using System.Drawing; using System.Resources; using System.ComponentModel; using System.Windows.Forms; namespace Cu

/// /// Request.Form,Request.QueryString,Request.Params /// http://msdn.microsoft.com/en-us/library/system.web.httprequest.params(v=vs.110).aspx /// Geovin Du 涂聚文

Function chinese2unicode(Str) Dim Str_one:Str_one = "" Dim Str_unicode:Str_unicode = "" For i = 1 To Len(Str) Str_one = Mid(Str, i, 1) If AscW(Str_one) 255 Then

//引用：using System.Web.Hosting; string filePathcsv = ""; string file = ""; string strFile = "LukfookGeovindu"; strFile = strFile + DateTime.Now.ToStr

/// ///塗聚文 存儲過程輸出參數，和返回值 /// 20131030 /// Geovin Du /// /// /// /// /// /// /// public DataTa

/// /// 計算ListView各類子項ListViewGroup的數量 /// /// private DataTable getNumber(ListView listview) { ArrayList alist = new ArrayList();

/// /// /// /// /// private void ListboxCheckboxForm_Load(object sender, EventArgs e) { //设置CheckedListBox中第i项的Checked状态

/// /// �� 塘㙍镇 ///涂聚文 20130623 ///http://zh.wiktionary.org/wiki/Wiktionary:%E9%83%A8%E9%A6%96%E7%B4%A2%E5%BC%95 /// /// /// private voi

/// /// /// public partial class Form2 : Form { private mshtml.IHTMLDocument2 hc; private mshtml.HTMLDocument hc1; //subdir in ApplicationData Folder, chan

/// /// 设置查找的节点为选定节点 /// 涂聚文 /// 2013-07-15 /// /// /// /// public TreeNode srchTxtInSelectTreeView(TreeView trvToSrch, Str

/// /// 檢測手機客戶端 HttpCapabilitiesBase.IsMobileDevice /// .NET 4.5 /// 塗聚文注 /// public static class HttpRequestBaseExtensions { #region Private Fields // Thes

.geovindu INPUT{ color:black; border-style: none; font-family: Tahoma; font-size: 7px; margin-right: 5px}.geovindu td { /* font-size:x-large;*/ width:300px; }

public class StringControl { /// /// 客户端浏览器 /// http://en.wikipedia.org/wiki/Web_browser /// http://www.w3schools.com/browsers/browsers_stats.asp /// The

namespace GeovinDu.PdfViewer{ [DefaultProperty("FilePath")] [ToolboxData("")] public class ShowPdf : WebControl { #region "Declarations" //Geovin Du 塗聚文 2

/// ///參考： http://james.newtonking.com/json/help/index.html# /// 塗聚文(Geovin Du) 20141228 /// 捷為工作室 /// public partial class _Default : System.Web.UI.Page { Geo

/// /// 全角 /// /// /// public static string FullWidthConvertor(string unicodeString) { StringBuilder sb = new StringBuilder(256);

/// /// /// public class SheetNameInfo { private int _sheetId; private string _sheetName; private string _rid; /// /// ///

参考:http://api.fanyi.baidu.com/api/trans/product/indexhttp://developer.baidu.com/wiki/index.php?title=%E5%B8%AE%E5%8A%A9%E6%96%87%E6%A1%A3%E9%A6%96%E9%A1%B5/%E7%99%BE%E5%BA%A6%E7%BF%BB%E8%AF%91APIw

DROP TABLE DepartmentGOCREATE TABLE Department( Id INT IDENTITY(1,1) PRIMARY KEY, DepName VARCHAR(50), PhoneNumber VARCHAR(50))GOCREATE PROCEDURE [dbo].[GetDepartmentId] ( @Id INT )AS

/// /// /// /// /// protected void Page_Load(object sender, EventArgs e) { var sections = new List { new

sql script code:CREATE TABLE DuCardType( CardTypeId INT IDENTITY(1,1) PRIMARY KEY, CardTypeName NVARCHAR(100) NOT NULL, --卡类名称 CardTypeColor NVARCHAR(50) NOT NULL --卡颜色(或样本))GO

winform:/// /// /// /// /// private void btnGenWord_Click(object sender, EventArgs e) { Dictionary dictSource = new Dictiona

using System;using System.Data;using System.Configuration;using System.Collections;using System.Collections.Generic;using System.Web;using System.Web.Security;using System.Web.UI;using System.

# 建表 塗聚文 20160907drop table attendrecord;create table attendrecord( seq INT NOT NULL PRIMARY KEY AUTO_INCREMENT, emp_no varchar(20) null, rdate datetime not null, rtime time not n

# 建表 塗聚文 20160907drop table attendrecord;create table attendrecord( seq INT NOT NULL PRIMARY KEY AUTO_INCREMENT, emp_no varchar(20) null, rdate datetime not null, rtime time not n

excel 2003:using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;

excel 2003 (效果不太理想)using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Wi

/// /// 执行SQL语句，返回影响的记录数 /// /// SQL语句 /// 影响的记录数 public static int ExecuteSql(string SQLString, params OleDbParameter[] cmdParms) { using

/// /// /// /// /// public static System.Data.DataTable ReadExcel(String strFileName) { Workbook book = new Workbook(strFileName);

from A Custom CheckedListBox with Datasource  http://www.codeproject.com/Articles/22960/A-Custom-CheckedListBox-with-Datasource-Implementa /// /// (eraghi) /// Custom CheckedListBox w

数据类型表：TypeNameProviderDbTypeColumnSizeCreateFormatCreateParametersDataTypeBFILE14294967296BFILE System.Byte[]BLOB24294

enum ChangeNume { /// /// 简体 /// gbk=1, /// /// 英文 /// en=2, /// /// 繁体 ///

/// /// Export DataSet into Excel /// /// /// private void Form3_Load(object sender, EventArgs e) { //Create an Emplyee DataTable Da