04 2011 档案

摘要:using System;using System.Data;using System.Web;using System.Web.UI;using System.Web.UI.WebControls;using System.Data.OleDb;using Microsoft.Office.Interop.Excel;using System.Reflection; // For Missing.Value and BindingFlagsusing System.Runtime.InteropServices; // For COMException/// <summary>/ 阅读全文
posted @ 2011-04-20 21:28 KimSky 阅读(1227) 评论(0) 推荐(0) 编辑
摘要:1、由dataset生成 public void CreateExcel(DataSet ds,string typeid,string FileName) { HttpResponse resp; resp = Page.Response; resp.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312"); resp.AppendHeader("Content-Disposition", "attachment;filename=" + FileName); stri 阅读全文
posted @ 2011-04-20 20:56 KimSky 阅读(218) 评论(0) 推荐(0) 编辑
摘要:/***-------------------------------------------Word-----------------------------------***/ private void WordReplace(string filePath, string strOld, string strNew) { ///实例化顶级对象 Microsoft.Office.Interop.Word.Application app = new Microsoft.Office.Interop.Word.ApplicationClass(); object nullobj = Syst. 阅读全文
posted @ 2011-04-20 20:02 KimSky 阅读(312) 评论(0) 推荐(0) 编辑
摘要:1.乾卦:读 qián 2.坤卦:读 kūn 3.屯卦:读 zhūn 4.蒙卦:读 méng 5.需卦:读 xū 6.讼卦:读 sòng 7.师卦:读 shī 8.比卦:读 bì 9.小畜卦:读 xiǎo xù 10.履卦:读 lǚ 11.泰卦:读 tài 12.否卦:读 pǐ 13.同人卦:读 tóng rén 14.大有卦:读 dà yōu 15.谦卦:读 qiān 16.豫卦:读 yǜ 17.随卦:读 suí 18.蛊卦:读 gǔ 19.临卦:读 lín 20.观卦:读 guān 阅读全文
posted @ 2011-04-18 01:17 KimSky 阅读(672) 评论(0) 推荐(0) 编辑
摘要:SQL code--按某一字段分组取最大(小)值所在行的数据(爱新觉罗.毓华 2007-10-23于浙江杭州)/*数据如下:name val memoa 2 a2(a的第二个值)a 1 a1--a的第一个值a 3 a3:a的第三个值b 1 b1--b的第一个值b 3 b3:b的第三个值b 2 b2b2b2b2b 4 b4b4b 5 b5b5b5b5b5*/--创建表并插入数据:create table tb(name varchar(10),val int,memo varchar(20))insert into tb values('a', 2, 'a2(a的第二个值 阅读全文
posted @ 2011-04-05 14:54 KimSky 阅读(413) 评论(0) 推荐(0) 编辑

点击右上角即可分享
微信分享提示