06 2006 档案
ASP.NET1.1中Grid自定义眉头
摘要:protectedvoidgrid_ItemCreated(objectsender,DataGridItemEventArgse){if(e.Item.ItemType==ListItemType.Header){e.Item.SetRenderMethodDelegate(newRenderMethod(NewRenderMethod));}elseif(e.Item.ItemType==Li... 阅读全文
posted @ 2006-06-27 13:45 老狐狸 阅读(194) 评论(0) 推荐(0)
asp.net1.0 TreeView
摘要:var OnInit;var OnNodeChecked;function initchecknode(TreeView1){ //获得需要初始化选择状态的节点的字符串. var selectedNodes = document.getElementById("corpList").value; var arrayNodes = new Array(); arrayNode... 阅读全文
posted @ 2006-06-27 13:13 老狐狸 阅读(307) 评论(0) 推荐(0)
asp.net2.0 TreeView
摘要: 阅读全文
posted @ 2006-06-27 13:02 老狐狸 阅读(353) 评论(0) 推荐(0)
摘要:包头: create or replace package GetMonthPlan is TYPE T_MonthPlan IS REF CURSOR; Procedure p_GetMonthStockPlan(sYear in varchar, sMonth in varchar, ... 阅读全文
posted @ 2006-06-23 17:19 老狐狸 阅读(345) 评论(0) 推荐(0)
创建记录、数组
摘要:--创建记录 TYPE REC_PERSON IS RECORD( PersonSID varchar2(50), PersonName varchar2(60), Gender varchar2(10), DepartSID varchar2(50), IsSaler char(1), IsAgent char(1), IsDel... 阅读全文
posted @ 2006-06-16 16:00 老狐狸 阅读(149) 评论(0) 推荐(0)
关闭远程数据库连接
摘要:sSQL := 'alter session close database link ' || sDataSource; execute immediate sSQL; 阅读全文
posted @ 2006-06-16 15:58 老狐狸 阅读(245) 评论(0) 推荐(0)
创建游标
摘要:TYPE V_CUR IS REF CURSOR; CUR V_CUR;open CUR for sSQL; LOOP FETCH CUR INTO R_PERSON; EXIT WHEN CUR%NOTFOUND; i := i+ 1; table_person_list(i) := R_PERSON; END LOOP; CLOSE CUR; 阅读全文
posted @ 2006-06-16 15:57 老狐狸 阅读(224) 评论(0) 推荐(0)
创建新的序列
摘要:select NVL(count(Sequence_Name), 0) into nCount from all_sequences where Sequence_Owner = 'LSP' and Sequence_Name = 'SEQ_SHELFID'; if nCount > 0 then sSQL := 'drop sequence LSP.SEQ_SHE... 阅读全文
posted @ 2006-06-16 15:54 老狐狸 阅读(196) 评论(0) 推荐(0)
创建隐式游标
摘要:for cura in (select DeptId,parentId from lsp.lbi_department where parentId = curId order by DeptId) loop insert into TMP_TEST(id,parentId) values(cura.id,cura.parentId); Insert... 阅读全文
posted @ 2006-06-16 15:52 老狐狸 阅读(177) 评论(0) 推荐(0)
创建临时表
摘要:select count(*) into nCount from user_tables where table_name = 'TT_DEPARTPERSONRELATION';sSQL := 'Create global temporary table TT_DepartPersonRelation( DepartSID varchar2(50), Pers... 阅读全文
posted @ 2006-06-16 15:50 老狐狸 阅读(245) 评论(0) 推荐(0)
更新表(多表相关联)
摘要:update f_shortforest forest set forest.forestquantity = (select (decode(sum(detail.quantity), null, 0, ... 阅读全文
posted @ 2006-06-16 15:47 老狐狸 阅读(234) 评论(0) 推荐(0)
更新表(如果记录已存则更新,不存在则插入)
摘要:MERGE INTO course cUSING (SELECT course_name, period,course_hoursFROM course_updates) cuON (c.course_name = cu.course_nameAND c.period = cu.period)WHEN MATCHED THENUPDATESET c.course_hours = cu.course... 阅读全文
posted @ 2006-06-16 15:45 老狐狸 阅读(306) 评论(0) 推荐(0)
慢慢上升的图片
摘要:1 html: ... 阅读全文
posted @ 2006-06-16 15:43 老狐狸 阅读(257) 评论(0) 推荐(0)
XMLHttpRequest
摘要:后台代码: protected void Page_Load(object sender, System.EventArgs e) { // This page makes the contents of the dataset available as an XML file // that the javascript XmlHttp... 阅读全文
posted @ 2006-06-16 15:40 老狐狸 阅读(316) 评论(0) 推荐(0)
一个简单的文本框控件
摘要:这一个简单的文本框控件主要实现在了IPostBackDataHandler, IEditableTextControl, ItextControl三个接口。IPostBackDataHandler IEditableTextControl主要有事件event EventHandler TextChanged;有ItextControl主要有一个Text属性接口说明:IPostBackDataHan... 阅读全文
posted @ 2006-06-05 11:25 老狐狸 阅读(993) 评论(0) 推荐(0)
控件生命周期
摘要:第一次加载主要事件如下:1:TrackViewState2:OnPreRender3:SaveViewState()4:Render回传时页面加载主要事件如下: page.isPostBack1:TrackViewState2:LoadViewState3:LoadPostData4:RaisePostDataChangedEvent5RaisePostBackEvent6:OnPreRender... 阅读全文
posted @ 2006-06-05 08:54 老狐狸 阅读(1095) 评论(2) 推荐(0)