02 2015 档案

csharp: read excel using Aspose.Cells

摘要：/// /// /// /// /// public static System.Data.DataTable ReadExcel(String strFileName) { Workbook book = new Workbook(strFileName); ... 阅读全文

posted @ 2015-02-28 13:04 ®Geovin Du Dream Park™ 阅读(812) 评论(0) 推荐(0) 编辑

sql:PostgreSQL

摘要：PostgreSQL sql script:-- Database: geovindu-- DROP DATABASE geovindu;CREATE DATABASE geovindu WITH OWNER = postgres ENCODING = 'UTF8' TAB... 阅读全文

posted @ 2015-02-12 15:23 ®Geovin Du Dream Park™ 阅读(714) 评论(0) 推荐(0) 编辑

csharp:SQLite and Access using C# code read data

摘要：SQLite sql script: SQLite 数据库连接字符 Csharp操作SQLite 添加返回值 Csharp操作Access添加返回值 https://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki http 阅读全文

posted @ 2015-02-11 15:02 ®Geovin Du Dream Park™ 阅读(1008) 评论(0) 推荐(0) 编辑

sql:Mysql create view,function,procedure

摘要：create database Liber; use Liber; #顯示數据庫 20150210 Geovin Du 涂聚文 SHOW DATABASES; drop table BookKindList; #书目录 create table BookKindList ( BookKindID I 阅读全文

posted @ 2015-02-10 15:01 ®Geovin Du Dream Park™ 阅读(455) 评论(0) 推荐(0) 编辑

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_BookKindO... 阅读全文

posted @ 2015-02-10 11:39 ®Geovin Du Dream Park™ 阅读(430) 评论(0) 推荐(0) 编辑

Working C# code for MySql5.5 Stored Procedures IN parameters

摘要：MySQL5.5存储过程:#插入一条涂聚文DELIMITER $$DROP PROCEDURE IF EXISTS `geovindu`.`proc_Insert_BookKindList` $$CREATE PROCEDURE `geovindu`.`proc_Insert_BookKindL... 阅读全文

posted @ 2015-02-10 01:26 ®Geovin Du Dream Park™ 阅读(316) 评论(0) 推荐(0) 编辑

csharp:search and Compare string

摘要：http://blogs.msdn.com/b/kcwalina/archive/2004/06/22/162533.aspx http://www.dotblogs.com.tw/puma/archive/2009/05/28/asp.net-generic-list-sort-find-find 阅读全文

posted @ 2015-02-07 15:56 ®Geovin Du Dream Park™ 阅读(616) 评论(0) 推荐(0) 编辑

csharp:datagridview enter Half Width and Full Width characters

摘要：/// /// 全角 /// /// /// public static string FullWidthConvertor(string unicodeString) { ... 阅读全文

posted @ 2015-02-06 15:02 ®Geovin Du Dream Park™ 阅读(335) 评论(0) 推荐(0) 编辑

csharp: SQL Server 2005 Database Backup and Restore using C#

摘要：1.第一种方式: using SQLDMO;//Microsoft SQLDMO Object Library 8.0 /// /// 数据库的备份 /// 涂聚文注:数据库的备份和实时进度显示代码：(远程备份在数据库原本地,如果在数据库安装的电脑上备份,就可以自行选择... 阅读全文

posted @ 2015-02-05 13:04 ®Geovin Du Dream Park™ 阅读(469) 评论(0) 推荐(0) 编辑

csharp: string Encoding

摘要：/// /// 中文转unicode /// /// /// public static string unicode_0(string str) { string outStr =... 阅读全文

posted @ 2015-02-01 20:10 ®Geovin Du Dream Park™ 阅读(1557) 评论(0) 推荐(0) 编辑