- 博客(165)
- 资源 (14)
- 收藏
- 关注
原创 Python: Flyweight Pattern
# 享元模式 Flyweight Pattern geovindu,Geovin Du,涂聚文
2022-10-22 11:49:38
172
原创 java: MySQL Metadata
//https://www.baeldung.com/jdbc-database-metadata //https://docs.oracle.com/en/java/javase/11/docs/api/java.sql/java/sql/DatabaseMetaData.html /** * 获取某数据库中的表列表 涂聚文 Geovin Du geovindu * @param * @return TablesMetadata集合 ...
2021-12-25 08:29:11
948
原创 csharp: MySQL Stored Procedure using DAL
# 建表 塗聚文 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
2021-03-05 09:32:51
294
原创 three.js: Control gui and play sound set Volume
<!DOCTYPE html><html><head> <meta charset="utf-8" /> <meta name="viewport" content="width=device-width, initial-scale=1.0, minimum-scale=1.0, maximum-scale=1.0, user-scalable=no" /> <meta name="apple-moible-w.
2021-03-05 09:19:18
289
1
原创 PHP7.27: connect mysql 5.7 using new mysqli_connect
<!doctype html><html><head><meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta charset="utf-8"><title>my sql&am
2018-07-17 14:51:42
364
原创 FullCalendar – jQuery Event Calendar in ASP.NET
https://github.com/esausilva/ASP.Net-EventCalendarhttp://trentrichardson.com/examples/timepicker/https://github.com/posabsolute/jQuery-Validation-Enginehttps://github.com/xdan/datetimepickerLi
2017-04-17 21:53:07
813
原创 csharp: Oracle Stored Procedure DAL using ODP.NET
Oracel sql:--书分类目录kind -- Geovin Du create table BookKindList( BookKindID INT PRIMARY KEY, BookKindName nvarchar2(500) not null, BookKindParent INT null, BookKindCode varchar(100) ---編號
2016-09-21 11:26:36
660
原创 MySQL Stored Procedure Prepared Statement (Dynamic SQL) Parameterized
类似于SQL Server中的:sp_executesqlsql server script:--- 涂聚文 20160906IF EXISTS (SELECT * FROM sysobjects WHERE [name] = 'proc_Select_DuDeptUserCount')DROP PROCEDURE proc_Select_DuDeptUserCountGOCR
2016-09-07 16:33:00
788
原创 csharp: MySQL Stored Procedure using DAL
# 建表 塗聚文 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
2016-09-07 11:01:01
862
原创 C++: DataGridView::DataSource
#pragma once#include "Form2.h"namespace cdemo { using namespace System; using namespace System::ComponentModel; using namespace System::Collections; using namespace System::Windows::Forms; us
2016-08-05 15:53:58
1938
原创 Csharp: Create Excel Workbook or word from Template File using aspose.Word 14.5 and aspose.Cell 8.1
winform:/// /// /// /// /// private void btnGenWord_Click(object sender, EventArgs e) { Dictionary dictSource = new Dictiona
2016-08-04 14:16:49
917
原创 csharp:asp.net Importing or Exporting Data from Worksheets using aspose cell
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.
2016-08-02 11:40:01
952
原创 csharp: Procedure with DAO and DAL
sql script code:CREATE TABLE DuCardType( CardTypeId INT IDENTITY(1,1) PRIMARY KEY, CardTypeName NVARCHAR(100) NOT NULL, --卡类名称 CardTypeColor NVARCHAR(50) NOT NULL --卡颜色(或样本))GO
2016-07-04 11:32:22
2265
原创 csharp: DataRelation objects to represent a parent/child/Level relationship
/// /// /// /// /// protected void Page_Load(object sender, EventArgs e) { var sections = new List { new
2016-05-24 10:54:47
597
原创 Fluent Nhibernate and Stored Procedures
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
2016-03-29 23:45:16
744
原创 javascript: Jquery each loop with json array or object
json:{ "justIn": [{ "textId": "123", "text": "Hello,geovindu", "textType": "Greeting" },{ "textId": "514", "text":"What's up?", "textType": "Question" },{ "textId": "122", "text":"Come over he
2016-01-12 15:53:03
702
原创 How to get the query string by javascript?
1.htmltest getQueryString2.html:javascript获取url参数和script标签中获取url参数//lastest: url paramter: //测试链接:test getQueryStringvar queryStrings=function() {//get url querystring var params=d
2016-01-08 23:58:39
644
原创 csharp:百度翻译
参考: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
2015-11-26 11:47:15
1202
转载 javascript: detect mobile devices or browser
http://detectmobilebrowsers.com/http://hgoebl.github.io/mobile-detect.js/http://www.hand-interactive.com/resources/detect-mobile-javascript.htmhttps://github.com/danielpoe/DeviceDetection/bl
2015-10-29 13:06:09
11350
原创 sql: table,view,function, procedure created MS_Description in sql server
--添加描述 Geovin Du--https://msdn.microsoft.com/en-us/library/ms180047.aspx--https://msdn.microsoft.com/zh-cn/library/ms180047(v=sql.120).aspx--https://msdn.microsoft.com/zh-cn/library/ms179853(v=sql.
2015-09-27 22:08:45
1050
原创 SQL Server: Get table primary key and Foreign Key using sql query
---某個錶的列名,主键,外键---20150923 涂聚文 SQL Server: Get table primary key and Foreign Key using sql query DECLARE @SchemaName VARCHAR(200),@TableName VARCHAR(200)SET @SchemaName='dbo'SET @TableName='Bo
2015-09-23 10:53:16
763
原创 Csharp: read excel file using Open XML SDK 2.5
/// /// /// public class SheetNameInfo { private int _sheetId; private string _sheetName; private string _rid; /// /// ///
2015-08-20 09:28:04
1186
原创 csharp: Export or Import excel using NPOI
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;
2015-07-31 00:22:32
871
原创 csharp: Export or Import excel using MyXls
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
2015-07-31 00:17:20
690
原创 csharp: 用Enterprise Library对象实体绑定数据
Enterprise Library: https://msdn.microsoft.com/en-us/library/ff648951.aspx/// /// 是否存在该记录 /// /// /// public bool Exists(string ReportID) {
2015-07-26 02:53:28
676
原创 csharp:Dapper Sample
You can find Dapper on Google Code here: http://code.google.com/p/dapper-dot-net/ and the GitHub distro here: https://github.com/SamSaffron/dapper-dot-net. /// /// 追加记录 ///
2015-07-26 02:26:28
843
原创 csharp: Data binding in WPF DataGrid control
<Window x:Class="WpfProjectDemo.MainWindow" xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" Title="M
2015-07-13 17:55:40
1074
原创 csharp: Export DataSet into Excel and import all the Excel sheets to DataSet
/// /// Export DataSet into Excel /// /// /// private void Form3_Load(object sender, EventArgs e) { //Create an Emplyee DataTable Da
2015-07-10 17:30:29
775
原创 csharp: DataTable Rename ColumnName and remove Column
enum ChangeNume { /// /// 简体 /// gbk=1, /// /// 英文 /// en=2, /// /// 繁体 ///
2015-07-09 20:39:42
1063
原创 sql: Oracle 11g create procedure
CREATE OR REPLACE PROCEDURE proc_Insert_BookKindList (temTypeName nvarchar2,temParent int)ASncount number;begin--SELECT COUNT (*) INTO ncount FROM BookKindList fm1 where EXISTS (SELECT BookKi
2015-05-26 22:44:05
936
原创 sql: Oracle 11g create table, function,trigger, sequence
----自动增长ID --序列创建 drop SEQUENCE BookPlaceList_SEQ;CREATE SEQUENCE BookPlaceList_SEQINCREMENT BY 1 -- 每次加几个START WITH 1 -- 从1开始计数NOMAXVALUE -- 不设置最大值NOCYCLE --
2015-05-22 09:35:29
791
原创 csharp: Oracle Metadata queries
数据类型表:TypeNameProviderDbTypeColumnSizeCreateFormatCreateParametersDataTypeBFILE14294967296BFILE System.Byte[]BLOB24294
2015-05-17 00:27:12
715
转载 sql:SQL Server metadata queries
-- 2012--https://technet.microsoft.com/zh-cn/library/ms186778(v=sql.110).aspx--对象目录视图 (Transact-SQL)select * from sys.foreign_keysselect * from sys.foreign_key_columnsselect * from sys.all_colum
2015-05-15 17:20:29
808
转载 csharp:A Custom CheckedListBox with Datasource
from A Custom CheckedListBox with Datasource http://www.codeproject.com/Articles/22960/A-Custom-CheckedListBox-with-Datasource-Implementa /// /// (eraghi) /// Custom CheckedListBox w
2015-05-09 21:16:05
616
原创 sql:MySql create FUNCTION,VIEW,PROCEDURE
use geovindu;#函数DELIMITER $$drop function if exists f_GetDepartmentName $$CREATE function f_GetDepartmentName( did int) returns nvarchar(400) begindeclare str nvarchar(100);select Depar
2015-04-03 17:57:18
1265
原创 sql: postgreSQL sql script
--pg_catalogSELECT * from pg_class c,pg_attribute a,pg_type t where c.relname='BookKindList' and a.attnum>0 and a.attrelid=c.oid and a.atttypid=t.oidSELECT a.attname from pg_class c,pg_attribute a,
2015-04-02 12:20:08
982
原创 Getting SQLite metadata with Csharp
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 System.Dat
2015-03-24 21:23:17
971
原创 Mysql问题:Connector/Net no longer supports server versions prior to 5.0
我用Connector/Net 6.9读取MySql 4.1 时,会报以下错:1.Connector/Net no longer supports server versions prior to 5.02.Unable to connect to any of the specified MySQL hosts.后来我下载 http://dev.mysql.com/downloads
2015-03-23 12:05:08
1684
原创 MySql:局域网和权限用户管理
MySql 5.6(XP)/5.7(win7) 添加用户和设置局域访问权限操作.请在 http://sourceforge.net/ 下载MySql Control Center(不是安装版本). use mysql; select * from user; update user set authentication_string=password('0214') wher
2015-03-20 12:59:51
1348
原创 csharp: read excel using Aspose.Cells
/// /// /// /// /// public static System.Data.DataTable ReadExcel(String strFileName) { Workbook book = new Workbook(strFileName);
2015-02-28 14:43:10
1098
SQL Prompt 7.1破解文件及说明
2017-03-30
Gizmox.WebGUI.SDK.Community.5.81.3.74.5_NET20
2007-07-11
Gizmox.WebGUI.SDK.Community.5.81.3.74.5_NET11
2007-07-11
Gizmox.WebGUI.Forms.Catalog.5.81.3.74.5_NET20
2007-07-11
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人