11 2008 档案

AccessHelper
摘要：using System;using System.Configuration;using System.Data;using System.Data.OleDb;using System.Collections;using System.Text.RegularExpressions;using Help.Common;namespace DAL{ public abstract class AccessHelper { public static readonly string ConnectionString = ConfigurationManager.AppSettings[&quo 阅读全文
posted @ 2008-11-29 16:56 洗碗心得 阅读(733) 评论(1) 推荐(0) 编辑
Excel导入数据库
摘要：先在类中定义一个方法名为ExecleDs的方法,用于将Excel表里的数据填充到DataSet中,代码如下1publicDataSetExecleDs(stringfilenameurl,stringtable)2{3stringstrConn="Provider=Microsoft.Jet.OleDb.4.0;"+"datasource="+filenameurl+";ExtendedProperties='Excel8.0;HDR=YES;IMEX=1'";4OleDbConnectionconn=newOleDb 阅读全文
posted @ 2008-11-18 09:40 洗碗心得 阅读(1107) 评论(2) 推荐(0) 编辑