geovindu
geovindu_个人页
geovindu
文章
150
问答
0
视频
0
个人介绍
读者是,读之者,者之读.一沙一世界! to be is to do举世皆清我独浊,众人皆醒我独醉.俺是农民工,程序员.
擅长的技术
-
发表了文章 2017-04-17
FullCalendar – jQuery Event Calendar in ASP.NET
https://github.com/esausilva/ASP.Net-EventCalendar http://trentrichardson.com/examples/timepicker/ https://github.com/posabsolute/jQuery-Validation-Engine https://github.com/xdan/datetimepicker
-
发表了文章 2016-09-21
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-07
MySQL Stored Procedure Prepared Statement (Dynamic SQL) Parameterized
类似于SQL Server中的:sp_executesql sql server script: --- 涂聚文 20160906 IF EXISTS (SELECT * FROM sysobjects WHERE [name] = 'proc_Select_DuDeptUserCount') DROP PROCEDURE proc_Select_DuDeptUserCount GO
-
发表了文章 2016-09-07
csharp: MySQL Stored Procedure using DAL
# 建表 塗聚文 20160907 drop table attendrecord; create table attendrecord ( seq INT NOT NULL PRIMARY KEY AUTO_INCREMENT, emp_no varchar(20) null, rdate datetime not null, rtime time n
-
发表了文章 2016-08-05
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;
-
发表了文章 2016-08-04
Csharp: Create Excel Workbook or word from Template File using aspose.Word 14.5 and aspose.Cell 8.1
winform: /// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private v
-
发表了文章 2016-08-02
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 Sys
-
发表了文章 2016-07-04
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 --卡颜色(或样本) )
-
发表了文章 2016-05-24
csharp: DataRelation objects to represent a parent/child/Level relationship
/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Page_Load
-
发表了文章 2016-03-29
Fluent Nhibernate and Stored Procedures
DROP TABLE Department GO CREATE TABLE Department ( Id INT IDENTITY(1,1) PRIMARY KEY, DepName VARCHAR(50), PhoneNumber VARCHAR(50) ) GO CREATE PROCEDURE [dbo].[GetDepartmentId] ( @Id INT ) AS
-
发表了文章 2016-01-12
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 ove
-
发表了文章 2016-01-08
How to get the query string by javascript?
1.html <a href="2.html?name=geovindu&sex=woman&age=12">test getQueryString</a> 2.html: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/T
-
发表了文章 2015-11-26
csharp:百度翻译
参考:http://api.fanyi.baidu.com/api/trans/product/index http://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%91AP
-
发表了文章 2015-10-29
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.htm https://github.com/danielpoe/DeviceDetectio
-
发表了文章 2015-09-27
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=
-
发表了文章 2015-09-23
SQL Server: Get table primary key and Foreign Key using sql query
---所有用户表(主键，外键，描述等信息）涂聚文 20150924 Geovin Du SELECT tbl.[name] AS [TableName], clmns.[name] AS [ColumnName], usrt.[name] AS [DataType], ISNULL(
-
发表了文章 2015-08-20
Csharp: read excel file using Open XML SDK 2.5
/// <summary> /// /// </summary> public class SheetNameInfo { private int _sheetId; private string _sheetName; private string _rid;
-
发表了文章 2015-07-31
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.Fo
-
发表了文章 2015-07-31
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
-
发表了文章 2015-07-26
csharp: 用Enterprise Library对象实体绑定数据
Enterprise Library: https://msdn.microsoft.com/en-us/library/ff648951.aspx /// <summary> /// 是否存在该记录 /// </summary> /// <param name="ReportID"></
-
发表了文章 2015-07-26
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. ///<summary> /// 追加记
-
发表了文章 2015-07-13
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" T
-
发表了文章 2015-07-10
csharp: Export DataSet into Excel and import all the Excel sheets to DataSet
/// <summary> /// Export DataSet into Excel /// </summary> /// <param name="sender"></param> /// <param name="e"></param> pri
-
发表了文章 2015-07-09
csharp: DataTable Rename ColumnName and remove Column
enum ChangeNume { /// <summary> /// 简体 /// </summary> gbk=1, /// <summary> /// 英文 /// </summary>
-
发表了文章 2015-05-26
sql: Oracle 11g create procedure
CREATE OR REPLACE PROCEDURE proc_Insert_BookKindList ( temTypeName nvarchar2, temParent int ) AS ncount number; begin --SELECT COUNT (*) INTO ncount FROM BookKindList fm1 where EXISTS (SELECT Bo
-
发表了文章 2015-05-22
sql: Oracle 11g create table, function,trigger, sequence
--书藉位置Place目录 drop table BookPlaceList; create table BookPlaceList ( BookPlaceID INT PRIMARY KEY, --NUMBER BookPlaceName nvarchar2(500) not null, BookPlaceCode varchar(100) null,
-
发表了文章 2015-05-17
csharp: Oracle Metadata queries
数据类型表： TypeName ProviderDbType ColumnSize CreateFormat CreateParameters DataType BFILE 1 4294967296 BFILE System.Byte[] BLOB 2 42
-
发表了文章 2015-05-15
sql:SQL Server metadata queries
-- 2012 --https://technet.microsoft.com/zh-cn/library/ms186778(v=sql.110).aspx --对象目录视图 (Transact-SQL) select * from sys.foreign_keys select * from sys.foreign_key_columns select * from sys.all_c
-
发表了文章 2015-05-09
csharp:A Custom CheckedListBox with Datasource
from A Custom CheckedListBox with Datasource http://www.codeproject.com/Articles/22960/A-Custom-CheckedListBox-with-Datasource-Implementa /// <summary> /// (eraghi) /// Cust
-
发表了文章 2015-04-03
sql:MySql create FUNCTION,VIEW,PROCEDURE
use geovindu; #函数 DELIMITER $$ drop function if exists f_GetDepartmentName $$ CREATE function f_GetDepartmentName ( did int ) returns nvarchar(400) begin declare str nvarchar(100); select D
-
发表了文章 2015-04-02
sql: postgreSQL sql script
--pg_catalog SELECT * 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.oid SELECT a.attname from pg_class c,pg_attri
-
发表了文章 2015-03-24
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; usin
-
发表了文章 2015-03-23
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/c
-
发表了文章 2015-03-20
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
-
发表了文章 2015-02-28
csharp: read excel using Aspose.Cells
/// <summary> /// /// </summary> /// <param name="strFileName"></param> /// <returns></returns> public static Syste
-
发表了文章 2015-02-11
csharp:SQLite and Access using C# code read data
SQLite sql script: CREATE TABLE BookKindList ( BookKindID INTEGER PRIMARY KEY AUTOINCREMENT, BookKindName varchar(500) not null, BookKindCode varchar(100) null, BookKindPa
-
发表了文章 2015-02-10
sql:Mysql create view,function,procedure
use test; create database Liber; use Liber; #顯示數据庫 20150210 Geovin Du 涂聚文 SHOW DATABASES; drop table BookKindList; #书目录 create table BookKindList ( BookKindID INT NOT NULL AUTO_I
-
发表了文章 2015-02-10
sql: MySQL and Microsoft SQL Server Stored Procedures IN, OUT using csharp code
MySQL存储过程: #插入一条返回值 DELIMITER $$ DROP PROCEDURE IF EXISTS `geovindu`.`proc_Insert_BookKindOut` $$ CREATE PROCEDURE `geovindu`.`proc_Insert_BookKindOut` (IN param1Name NVarChar(1000),IN param1P
-
发表了文章 2015-02-06
csharp:datagridview enter Half Width and Full Width characters
/// <summary> /// 全角 /// </summary> /// <param name="unicodeString"></param> /// <returns></returns> public static string F
-
发表了文章 2015-01-15
WHILE (Transact-SQL)
---循环 declare @n int declare @rowcount int declare @name varchar(50) create table #temp ( id int identity(1,1), ColumnNme nvarchar(100) ) insert into #temp select COLUMN_NAME from 数据库名.INFORMAT
-
发表了文章 2014-12-29
csharp: using OleDb Getting the identity of the most recently added record
/// <summary> /// 执行SQL语句，返回影响的记录数 /// </summary> /// <param name="SQLString">SQL语句</param> /// <returns>影响的记录数</returns>
-
发表了文章 2014-12-28
csharp:Learn how to post JSON string to generic Handler using jQuery in ASP.Net C
/// <summary> ///參考： http://james.newtonking.com/json/help/index.html# /// 塗聚文(Geovin Du) 20141228 /// 捷為工作室 /// </summary> public partial class _Default : Sy
-
发表了文章 2014-08-14
parent-childRecursive sum in parent-child hierarchy T-SQL
---树形（父子关系类）分级类统计（父子统计） --涂聚文 2014-08-14 drop table BookKindList create table BookKindList ( BookKindID INT IDENTITY(1,1) PRIMARY KEY, BookKindName nvarchar(500) not null, Boo
-
发表了文章 2014-07-24
csharp: Converting chinese character to Unicode
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) < 0 or
-
发表了文章 2014-06-30
csharp:DropDownComboxTreeView
using System; using System.Collections.Generic; using System.Text; using System.Drawing; using System.Resources; using System.ComponentModel; using System.Windows.Forms; namespac
-
发表了文章 2014-06-12
sql: Compare Tables
---使用 UNION、INTERSECT 或 EXCEPT 运算符合并的所有查询必须在其目标列表中有相同数目的表达式 select * from BookInfoList --存在不同的 select BookInfoID,BookInfoBarCode from BookInfoList where BookInfoStatus=1 except select BookInven
-
发表了文章 2014-06-01
csharp: using using System.Web.Script.Serialization read json
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; us
-
发表了文章 2014-06-01
csharp:using Newtonsoft.Json.Net2.0 in .net 2.0 webform
/// <summary> /// http://www.weather.com.cn/data/sk/101280601.html /// {"weatherinfo":{"city":"深圳","cityid":"101280601","temp":"32","WD":"西南风","WS":"4级","SD":"68%","WSE":"4","tim
-
发表了文章 2014-05-28
csharp: Request.Form,Request.QueryString,Request.Params
/// <summary> /// Request.Form,Request.QueryString,Request.Params /// http://msdn.microsoft.com/en-us/library/system.web.httprequest.params(v=vs.110).aspx /// Geov
-
发表了文章 2014-05-15
sql:查询创建表的结构
--显示所有用户表： --1 SELECT SCHEMA_NAME(schema_id) As SchemaName , name As TableName from sys.tables ORDER BY name --2。alternate: SELECT sch.name As SchemaName , tbl.name As T
暂无更多信息
-
发表了文章
2017-04-17
FullCalendar – jQuery Event Calendar in ASP.NET
-
发表了文章
2016-09-21
csharp: Oracle Stored Procedure DAL using ODP.NET
-
发表了文章
2016-09-07
MySQL Stored Procedure Prepared Statement (Dynamic SQL) Parameterized
-
发表了文章
2016-09-07
csharp: MySQL Stored Procedure using DAL
-
发表了文章
2016-08-05
C++: DataGridView::DataSource
-
发表了文章
2016-08-04
Csharp: Create Excel Workbook or word from Template File using aspose.Word 14.5 and aspose.Cell 8.1
-
发表了文章
2016-08-02
csharp:asp.net Importing or Exporting Data from Worksheets using aspose cell
-
发表了文章
2016-07-04
csharp: Procedure with DAO and DAL
-
发表了文章
2016-05-24
csharp: DataRelation objects to represent a parent/child/Level relationship
-
发表了文章
2016-03-29
Fluent Nhibernate and Stored Procedures
-
发表了文章
2016-01-12
javascript: Jquery each loop with json array or object
-
发表了文章
2016-01-08
How to get the query string by javascript?
-
发表了文章
2015-11-26
csharp:百度翻译
-
发表了文章
2015-10-29
javascript: detect mobile devices or browser
-
发表了文章
2015-09-27
sql: table,view,function, procedure created MS_Description in sql server
-
发表了文章
2015-09-23
SQL Server: Get table primary key and Foreign Key using sql query
-
发表了文章
2015-08-20
Csharp: read excel file using Open XML SDK 2.5
-
发表了文章
2015-07-31
csharp: Export or Import excel using NPOI
-
发表了文章
2015-07-31
csharp: Export or Import excel using MyXls
-
发表了文章
2015-07-26
csharp: 用Enterprise Library对象实体绑定数据
滑动查看更多
暂无更多信息
暂无更多信息