03 2013 档案

ASP.NET导出导入Excel
摘要：1.用Spire.XLS.dll和Spire.License.dll导入和导出ExcelView Code 1 private void ExportExcelFile() 2 { 3 //创建一个流 4 using (MemoryStream stream = new MemoryStream()) 5 { 6 //创建Excel文档 7 Spire.Xls.Workbook book = new Spire.Xls.Workbook();... 阅读全文
posted @ 2013-03-28 16:07 小银光 阅读(1189) 评论(3) 推荐(1)
sql server行转列
摘要：首先创建表和添加数据想要的结果--方法一SELECT DISTINCT C.[USER_NAME] AS '姓名',(SELECT SCORE FROM TEST_TB_GRADE WHERE [USER_NAME]=C.[USER_NAME] AND COURSE='语文') AS '语文',(S... 阅读全文
posted @ 2013-03-16 23:15 小银光 阅读(399) 评论(0) 推荐(0)