2008年07月_EricYeung

12月 10月 09月 08月 07月 06月 04月 03月 02月 01月

原创 C# modify file (read all and modify and write all)

StringBuilder newFile = new StringBuilder();string temp = "";string[] file = File.ReadAllLines(@"C:/Documents and Settings/john.grove/Desktop/1.txt");foreach (string line in file){ if (line.Contai

2008-07-16 11:55:00 1040

原创 C# 2.0 send email

private void SendMail(string smtpHost, string sender, string[] receivers, string subject, string content) { try { SmtpClient client = ne

2008-07-16 11:54:00 780

原创 hide insteadof close form

private void frmMain_Closing(object sender, System.ComponentModel.CancelEventArgs e) { this.Hide(); e.Cancel = true; }

2008-07-16 11:53:00 973

原创 C# join DataTable (support Left/Right/Full join)

using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Text;using System.Windows.Forms;using System.Data;names

2008-07-16 11:52:00 8203 3

原创 Use MemoryMapFile to read large file

// FileMapTest.cpp : Defines the entry point for the console application.//#include "stdafx.h"#include "FileMapTest.h"#ifdef _DEBUG#define new DEBUG_NEW#endif#include "MtVerify.h"// The one and only

2008-07-16 11:43:00 1556

原创 sql split path

declare @str varchar(100)set @str = C:/data/test.csvdeclare @idx int, @len intset @len = len(@str)set @idx = @lenwhile(@idx > 0 and substring(@str, @idx, 1) if @idx - 1 > 0 print path = + sub

2008-07-16 11:41:00 569

原创 SQL: select @var = xxx from table1 problem

declare @var intset @var = 1print @var = + isnull(str(@var), null)select top 1 @var = [object_id] from sys.objects where 1=2-- @var != nullprint @var = + isnull(str(@var), null)

2008-07-16 11:33:00 794

空空如也

TA创建的收藏夹 TA关注的收藏夹

TA关注的人