读者是,读之者,者之读.一沙一世界! to be is to do举世皆清我独浊,众人皆醒我独醉.俺是农民工,程序员.
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; usin
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; usin
//Csharp:WebClient and WebRequest use http download file //20140318 塗聚文收錄 string filePath = "20140302.pdf"; string fileName = "http://www.dusystem.com/3.pdf"
T-SQL: declare @int int,@prov int,@city int,@str nvarchar(500) set @str='天河麗特青春:中國廣東省廣州市天河區天河路623號天河娛樂廣場麗特青春百貨一樓,塗聚文' select @int=charindex(':',@str) select @prov=charindex('省',@str) sel
http://www.jacklmoore.com/colorbox/http://www.jacklmoore.com/colorbox/example5/ <script type="text/javascript" charset="utf-8"> $(document).ready(function() { /* Automatically resize
<script type="text/javascript"> //選擇節點 OnNodeSelectedScript="nodeSelectHandler(elem);" function nodeSelectHandler(elem){ var val = "selected node:" + elem.parentNode.getAttribut
---Example Uses of the SUBSTRING String Function --http://www.sql-server-helper.com/tips/tip-of-the-day.aspx?tkey=4AB06421-E859-4B5F-A948-0C9640F3108D&tkw=sample-uses-of-the-substring-string-
<% @LANGUAGE="VBSCRIPT" CODEPAGE="65001" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="
//引用:using System.Web.Hosting; string filePathcsv = ""; string file = ""; string strFile = "LukfookGeovindu"; strFile = strFile + Da
DECLARE @birthday datetime,@stat datetime,@end datetime,@statbirthday datetime,@endbirthday datetime,@thirdbirthday datetime,@firthbirthday datetime, @year int,@month int , @day int,@str varchar(
/// <summary> ///塗聚文 存儲過程輸出參數,和返回值 /// 20131030 /// Geovin Du /// </summary> /// <param name="rept"></param> /// <
<%@LANGUAGE="JAVASCRIPT" CODEPAGE="65001"%> <% //塗聚文 //20131021 function getData(connectionString, sql){ var result = null; var adStateOpen = 1; var connection = new
namespace GeovinDu.PdfViewer { [DefaultProperty("FilePath")] [ToolboxData("<{0}:ShowPdf runat=server></{0}:ShowPdf>")] public class ShowPdf : WebControl {
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head>
public class StringControl { /// <summary> /// 客户端浏览器 /// http://en.wikipedia.org/wiki/Web_browser /// http://www.w3schools.com/browsers/browsers_sta
http://msdn.microsoft.com/en-us/library/ms537512(VS.85).aspx http://www.quirksmode.org/css/condcom.html Item Example Comment ! [if !IE] The NOT operator. This is placed immediately in front of
drop table t_geovindu create table t_geovindu ( xid int IDENTITY (1, 1), price money, DebitCredit VARCHAR(2), adate datetime default(getdate()) )
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head>
/// <summary> /// 檢測手機客戶端 HttpCapabilitiesBase.IsMobileDevice /// .NET 4.5 /// 塗聚文注 /// </summary> public static class HttpRequestBaseExtensions {
<html> <head> <meta content="text/html; charset=utf-8" http-equiv="Content-Type" /> <title>javascript iframe switchSysBar 左欄打開關閉,兼容各瀏覽器操作</title> <!--
--這種是無效的過程 declare @sql nvarchar(500), @where nvarchar(500),@i nvarchar(64),@p nvarchar(50),@id int set @id=5 set @sql='select '+@p+'=AreaCode from AdministrativeAreaList where AreaID='+cast(
/// <summary> /// 设置查找的节点为选定节点 /// 涂聚文 /// 2013-07-15 /// </summary> /// <param name="trvToSrch"></param> /// <pa
/** * Copyright 2010 Tim Down. * * Licensed under the Apache License, Version 2.0 (the "License"); * you may not use this file except in compliance with the License. * You may obtain a c
<style type="text/css"> .geovindu INPUT { color:black; border-style: none; font-family: Tahoma; font-size: 7px; margin-right: 5px } .geovindu td { /* font-size
/// <summary> /// /// </summary> public partial class Form2 : Form { private mshtml.IHTMLDocument2 hc; private mshtml.HTMLDocument hc1; /
/// <summary> /// �� 塘㙍镇 ///涂聚文 20130623 ///http://zh.wiktionary.org/wiki/Wiktionary:%E9%83%A8%E9%A6%96%E7%B4%A2%E5%BC%95 /// </summary> ///
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head>
/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void List
/// <summary> /// 計算ListView各類子項ListViewGroup的數量 /// </summary> /// <returns></returns> private DataTable getNumber(ListView listview)
---sql server declare @date datetime set @date='2012-02-03'--getdate() --本月第一天 SELECT DATEADD(mm, DATEDIFF(mm,0,@date), 0) --本月最后一天 SELECT dateadd(ms,-3,DATEADD(mm, DATEDIFF(m,0,@date)+1, 0
/// <summary> /// 請假輸入兩個日期:(只考慮最多相差一個月)对于不同月份的数据考虑月份数据分界 /// </summary> /// <param name="sender"></param> /// <param name="e"><
---sql server 2005 顯示一個月的數據,如果沒有空的也要顯示出來 declare @T table([geovinddate] Datetime,[workcontent] nvarchar(8),[worker] nvarchar(50)) Insert @T select '2012-8-11',N'遲到','geovindu' union all select
jmail.Message MailObj = new jmail.MessageClass(); MailObj.From = "geovindu@qq.com"; //发件人的地址 可以显示与服务名不一样 MailObj.FromName = "締友計算機信息技術有限公司";//用户名 //MailObj.FromNa
/// <summary> /// 選擇顏色 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void
---請假跨月份問題,或跨年份問題 日期部分边界 declare @sart datetime,@end datetime,@d int,@s1 datetime,@e1 datetime,@s2 datetime,@e2 datetime,@t varchar(50),@t2 varchar(50),@I int set @sart='2012-11-18 14:56:12' se
/// <summary> /// 添加 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void bu
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head>
using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.IO; using System.Drawing.Imaging; using System.Drawing.Printing; using System.Drawing.Draw
---去除字符串中重復的值函數 create function StringRemove(@str nvarchar(2000)) returns varchar(2000) as begin declare @result nvarchar(2000),@temp nvarchar(1000) set @result='' set @temp=''
--sql code Geovin Du IF EXISTS (SELECT * FROM sysobjects WHERE [name] = 'proc_Select_AssessmentProjectSetSearch') DROP PROCEDURE proc_Select_AssessmentProjectSetSearch GO CREATE PROCEDURE proc
/// <summary> /// 20130118 /// 搜索字符串 /// 塗聚文 締友計算機信息技術有限公司 /// 捷為工作室 /// </summary> public class StringSearchClass { /// <summary>
深圳地鐵羅寶線和蛇口線示例:見上圖。 要求瀏覽器版本:browser does support HTML5 canvas element:Google Chrome V 8+;Mozilla Firefox V 3.6+;Opera V 11+;Apple Safari V 5+;Microsoft Internet Explorer V 9+。 javascript: /
//透明背景图 Brush b = new SolidBrush(Color.FromArgb(50, Color.Transparent)); Bitmap image = new Bitmap(1015, 637); Graphics g = Graphics.FromImage(image);
listView1.GridLines = true;//显示行与行之间的分隔线 listView1.FullRowSelect = true;//要选择就是一行 listView1.View = View.Details;//定义列表显示的方式 listView1.Scrollable
---表中的主鍵 select [name],'tablekey'= (select top 1 COLUMN_NAME from INFORMATION_SCHEMA.KEY_COLUMN_USAGE where TABLE_NAME = sysobjects.name) from sysobjects where type='U' --所有表 selec
using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using System.IO; using
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; usin
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; usin
// --------------------------------------------------------------------------------------------- #region // Copyright (c) 2004-2005, SIL International. All Rights Reserved. // <copyrigh