c_cwh-CSDN博客

原创 C#线程的一个示例,自己备忘(向多个控件传递值)

using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using System.Threading; /// <summary> //

2010-05-31 12:35:00 575

原创 C# 带参数线程的一个简单示例

using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Text;using System.Windows.Forms;using System.Threading;/// ///本程序只是线程使用的

2010-05-31 10:41:00 816

原创 VB.Net的SQL 2005数据库类

Public Class ClassDB Public cn As System.Data.SqlClient.SqlConnection Public da As System.Data.SqlClient.SqlDataAdapter Public ds As New DataSet Public dt As New DataTable Public cm

2009-10-05 13:51:00 721

原创 VB.Net创建的office类

Public Class Coffice Public xls As Excel.Application Public xlsworkbook As Excel.Workbook Public xlsworksheet As Excel.Worksheet Public doc As Word.Application Public document As Word

2009-10-05 13:47:00 551

原创 VBA文件和文件夹操作

创建文件夹Function Create_folder(ByVal Path As String, ByVal FileName As String)Dim folder As Object设置FSO对象Set fso = CreateObject("Scripting.FileSystemObject")如果文件夹不存在就创建出错跳转On Error Resume NextIf No

2009-10-05 13:41:00 1697

原创 Excel VBA创建自己的工具栏和菜单

Option ExplicitmsoBarTop工具栏的PositionType为msoControlPopup(As CommandBarPopup)的菜单下可以带子菜单,但是msoControlPopup不支持图标Type为msoControlButton(As CommandBarButton)的菜单是msoControlPopup的下级菜单,不带子菜单,支持图标以下代码可以实

2009-10-05 13:26:00 6099

原创 VBA对MySql数据库进行读取和写入操作

以下代码用于32位系统,Office 2003,环境,MySql版本5.1在使用前需要先安装MySql的驱动，进行正确配置注意：必须给出正确的服务器名、数据库名、表名、数据库连接的用户名、密码Option ExplicitDim Cnn As ADODB.Connection 定义ADO连接对象Dim Records As ADODB.Recordset 定义ADO记录集对象连接到数据

2009-10-05 13:11:00 8887 1