®Geovin Du Dream Park™

摘要： ---SQL SERVER 2000 遍历父子关系數據表（二叉树）获得所有子节点 所有父节点及节点层数函数---Geovin Du 涂聚文--建立測試環境Create Table GeovinDu([ID] Int, fatherID Int, [Name] Varchar(10))Insert A Select 1, 0, '中国'Union All Select 2, 1, '广东'Union All Select 3, 1, '北京'Union All Select 4, 2, '深圳特区'Union All Select 阅读全文

摘要： --sql server 2005 输出表的函數用法--Geovin Du 塗聚文 --締友計算機信息技術有限公司create function EmailParse (@email varchar(1000))returns @t table (UserName varchar(20), Domain varchar(20))asbegin declare @i int select @i = charindex('@', @email,1); if (@i > 1) insert into @t values (left(@email,@i-1), substring 阅读全文

摘要： --SQL server 2005 表中某一字段的所有值逗号分开的列表Geovin Du 塗聚文select * from Production.Productdeclare @names varchar(50)set @names=''select @names=@names+s.Name+' , 'from Production.Product sorder by s.Nameselect @namesgo--sql server 2000 如何逐条读出表中某一字段的所有值 Geovin Du 塗聚文declare @allstring varchar(80 阅读全文

摘要： http://jtoday.codeplex.com/jQuery jToday Plugin http://blog.donavon.com/2009/09/jquery-jtoday-plugin.htmljToday.js code:// jToday a simple jQuery date display plugin by Donavon West// Copyright 2009 Donavon West. All rights reserved(function($, document) {//--------------------$.fn.jToday = function 阅读全文

摘要： SQL Server 2000 http://msdn.microsoft.com/en-us/library/Aa223952http://msdn.microsoft.com/en-us/library/aa902644(SQL.80).aspxhttp://msdn.microsoft.com/en-us/library/aa902644(SQL.80).aspx#intlfeaturesinsqlserver2000_usingadpformatSQL Server 2005 http://msdn.microsoft.com/zh-cn/library/ms188688(v=sql. 阅读全文

摘要： /*****************************************---Geovin Du 塗聚文 締友計算機信息技術有限公司---公司集團有親屬員工顯示介紹人的姓名。一個表中的兩個外鍵是來自於同一個表*****************************************/--員工表IF EXISTS (select * from sysobjects where id = object_id(N'[dbo].[Employeetest]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) D 阅读全文

摘要： using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Text;using System.Windows.Forms;using System.Net;namespace WindowsTreeViewDemo{ /// <summary> /// 2011-06-25 /// 涂聚文 QQ天气预报 /// </summary> public partial class Fo 阅读全文

摘要： /// <summary> /// 2011-06-16 塗聚文 /// </summary> public partial class QQweather : System.Web.UI.Page { public string selectcity = "1"; string strUrl = "http://weather.qq.com/inc/ss1.htm"; /// <summary> /// /// </summary> /// <param name="sender" 阅读全文

摘要： /// <summary> /// 2011-06-16 塗聚文 /// </summary> public partial class QQweather : System.Web.UI.Page { public string selectcity = "1"; /// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></pa 阅读全文

摘要： http://www.syncfusion.com/faq/windowsforms/faq_c91c.aspxhttp://stackoverflow.com/questions/4527023/get-text-of-the-clicked-node-treeview-c-winformshttp://msdn.microsoft.com/en-us/library/system.windows.forms.treeview.selectednode.aspx /// <summary> /// 点击事件 /// </summary> /// <param n 阅读全文