07 2011 档案
摘要:首先需导入命名空间:using System.IO;string path = @"D:\";DirectoryInfo dir = new DirectoryInfo(path); foreach(FileSystemInfo fsi in dir.GetFileSystemInfos()) { if (fsi is FileInfo) { FileInfo fi = (FileInfo)fsi; //获得文件 } else { DirectoryInfo di = (DirectoryInfo)fsi; //获得文件夹 } }这样可以获取一个目录里的所有内容:包括文件和
阅读全文
摘要:Response.Write(Server.MapPath("test.xls")+"<BR>"); string strPath = Server.MapPath("test.xls"); DataSet ds = ExcelToDS(strPath); //获取字段名称 //Response.Write(ds.Tables[0].Columns[1].ColumnName.ToString()); //获取表格名称 //Response.Write(ds.Tables[0].TableName); //获取DATASE
阅读全文
摘要:方法代码: public DataSet ExcelToDS(string Path) { //定义EXCEL文件链接字符串 string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + Path + ";" + "Extended Properties=Excel 8.0;"; //实例化OledConnection链接 OleDbConnection conn = new OleDbConnection(strConn); //打
阅读全文

浙公网安备 33010602011771号