摘要: 1、用到的命名空间using Excel;using System.Diagnostics;using NPOI.HSSF.UserModel; npoi读取excel 1 StringBuilder sb = new StringBuilder(); 2 using (Stream stream = File.OpenRead("c:\\abc.xls")) 3 { 4 //内容中的excel文件 5 HSSFWorkbook workbook = new HSSFWorkboo... 阅读全文
posted @ 2012-08-06 00:43 Fan帥帥 阅读(309) 评论(0) 推荐(0) 编辑
摘要: View Code 1 SELECT 2 O.name , 3 TableDesc=PTB.[value], 4 Column_id=C.column_id, 5 ColumnName=C.name, 6 PrimaryKey=ISNULL(IDX.PrimaryKey,N''), 7 [IDENTITY]=CASE WHEN C.is_identity=1 THEN N'√'ELSE N'' END, 8 Computed=CASE WHEN C.is_computed=1 THEN N'√'ELSE N'' E 阅读全文
posted @ 2012-08-06 00:20 Fan帥帥 阅读(775) 评论(0) 推荐(0) 编辑