project management - agile

project management - agile
In order to be agile everyone in the team must be proficient.

ASP.NET DataBinding Eval V.S. Bind

Eval is used for one way data presentation whereas Bind is used to push data back to the database. Some detailed explanation:

http://www.15seconds.com/issue/040630.htm

Agile Project Management with Scrum

found this about Scrum, very helpful

http://agilescrum.tar.hu/agile_scrum_0035.html

"check-in pending" problem opening enterprise project within MS Project 2007

work around:
1. delete cache OR
2. when close the project, don't just click on "x", instead go File - Close

Available fields in Microsoft Office Project 2007

Available fields in Microsoft Office Project 2007
http://office.microsoft.com/en-us/project/HA102369301033.aspx?pid=CH100788901033

what is Queue in MSPS 2007

Microsoft Office Project Server 2007 Queuing System

http://technet.microsoft.com/en-us/library/cc197395.aspx

what is resource units in Microsoft Office Project 2007

Sometimes it takes one resource to complete a task, but other times you need more. Sometimes a resource can only work part time. To account for these differences, Microsoft Office Project 2007 uses units (units: The quantity of a resource assigned to a task. The maximum units is the maximum number of units available for the resource. For example, if you have three plumbers, the maximum units is 300 percent or three plumbers working full-time.) to calculate the exact amount of time resources can work on a task............
Details: http://office.microsoft.com/en-us/project/HA102548291033.aspx

Configuring Linked Servers SQL Server 7 and 2000

found this post very helpful
http://www.informit.com/articles/article.aspx?p=21644

Endnote x1 with WORD 2007 slows down Windows Vista x64

found a workaround for this issue
http://www.endnote.com/envista.asp

Walkthrough: Validating User Input in a Web Forms Page

found this article on MSDN very helpful
http://msdn2.microsoft.com/en-us/library/a0z2h4sw(VS.80).aspx
Visual Studio 2005, c#, web form, validator control

translate 'In' operator in SQL to LINQ

Just found out there is no 'In' in LINQ, instead there is an ANY in LINQ:
e.g.
var abc=
from d in mydb.department
where mydb.employee.Any(e => e.ProductID == d.ManagerId)
select d;

OUTKAST - PROTOTYPE

[Intro]
I hope that you're the one
If not, you are the prototype
We'll tiptoe to the sun
And do thangs I know you like

[Hook]
I think I'm in love again [repeat]

[Verse 1]
Today must be my lucky day
Baby, you are the prototype
Do sumn' outta the ordinary
Like catch a manitee
Baby you are the prototype
I think I'm..

[Hook]

[Verse 2]
If we happen to part
Lord knows I don't want that
But hey, we can't be mad at God
We met today for a reason
I think I'm on the right track now

[Hook]

The Scene
Come here

[Hook]

[Outro (ad libs)]
Girl, right now I wanna say, I wanna say
I wanna say stank you very much
For picking me up
And bringing me back to this world
I can't, I'm not
I can't afford to not record
I thank I wanna say
I thank I wanna say stank you, stank you
Smelly much!
For picking me up and bringing me back to this world
Hey, hey John! Are we recording our ad libs?
Really?? Were we recording just then?
Let me hear that, that first one
When I first started

不归路

歌曲：不归路

歌手：迪克牛仔

专辑：忘记我还是忘记他

词∶许常德　曲∶林进璋


我没有退路

尽管你也千辛万苦

不愿认输

是良心让爱坚固

剩下由老天做主

爱你是一条不归路

一度我非常孤独

但是我更怕漂浮

不知道身在何处

有时候绝路也是人生一条路

爱让人全意付出忘记有结束

一心只想你幸福

疏忽了自己痛苦

我没有退路

尽管你也千辛万苦

不愿认输

是良心让爱坚固

剩下由老天做主

有時候错误也是人生一条路

谁不是跌到谷底才有点觉悟

只要你不想退出

我不怕命运残酷

我没有退路

尽管你也千辛万苦

不愿认输

是良心让爱坚固

剩下由老天做主

我没有退路

尽管我也千辛万苦也不愿认输

是良心让爱坚固

老天做主

美丽的神话-成龙，金喜善

解开我 最神秘的等待 星星坠落 风在吹动
终于再将你拥入怀中 两颗心颤抖
相信我 不变的真心 千年等待 有我承诺
无论经过多少的寒冬 我绝不放手

이젠 나의 손을 잡고 눈을 감아요 yi jie na ye so nul qia go,nu nul ka ma yo.
（现在紧抓住我的手闭上眼睛）
우리 사랑했던 날들 생각해봐요 u li sa la hei dang nal dul,sei ga ke ba yo.
（请你回想起过去我们恋爱的日子）
우리 너무 사랑해서 아팠었네요 u li no mu sa la hei so,ha pa so ne yo.
（我们是因为太爱所以更使得我们痛苦）
서로 사랑한단 말도 못했었네요 so lo sa la ha dan mal do,mo tei so ne yo.
（我们连"爱你"这句话都无法讲）

每一夜 被心痛穿越 思念永没有终点
早习惯了孤独相随 我微笑面对
相信我 已选择等待 再多苦痛也不闪躲
只有你的温柔能解救 无边的冷漠

이젠 나의 손을 잡고 눈을 감아요 yi jie na ye so nul qia go,nu nul ka ma yo.
（现在紧抓住我的手闭上眼睛）
우리 사랑했던 날들 생각해봐요 u li sa la hei dang nal dul,sei ga ke ba yo.
（请你回想起过去我们恋爱的日子）
우리 너무 사랑해서 아팠었네요 u li no mu sa la hei so,ha pa so ne yo.
（我们是因为太爱所以更使得我们痛苦）
서로 사랑한단 말도 못했었네요 so lo sa la ha dan mal do,mo tei so ne yo.
（我们连"爱你"这句话都无法讲）

让爱成为你我心中 那永远盛开的花
穿越时空绝不低头 永不放弃的梦
우리 너무 사랑해서 아팠었네요 u li no mu sa la hei so,ha pa so ne yo.
（我们是因为太爱所以更使得我们痛苦）
서로 사랑한단 말도 못했었네요 so lo sa la ha dan mal do,mo tei so ne yo.
（我们连"爱你"这句话都无法讲）

让爱成为你我心中 那永远盛开的花
우리 소중했던 약속 잊지는 말아요 u li so ju hei dang ya kso,yi ji ni ma la yo.
（我们千万不要忘记我们的约定）
唯有真爱追随你我 穿越无尽时空
서로 사랑한단 말도 못했었네요 so lo sa la ha dan mal do,mo tei so ne yo.
（我们连"爱你"这句话都无法讲）
爱是心中唯一不变美丽的神话

美丽的神话-孙楠，韩虹

梦中的人熟悉的脸孔
你是我守候的温柔
就算泪水淹没天地
我不会放手,每一刻孤独的承受
只因我曾许下承诺
你我之间熟悉的感动
爱就要苏醒
万世沧桑唯有爱是永远的神话
潮起潮落始终不悔真爱的相约
几番若痛的纠缠多少黑夜掐扎
紧握双手让我和你再也不离分
枕上雪冰封的爱恋
真心相摇篮才能融解
风中摇曳炉上的火
不灭亦不休
等待花开春去春又来
无情岁月笑我痴狂
心如钢铁任世界荒芜
思念永相随
悲欢负月唯有爱是永远的神话
谁都没有遗忘古老,古老的誓言
你的泪水化为漫天飞舞的彩蝶
爱是翼下之风两心相随自在飞
你就是我心中唯一美丽的神话

爱情诺曼底

六月六日六时六分刚过六十秒
脆弱的堡垒远眺如风化的沙雕
轻抚着断裂的皱纹沧桑一条条
谁的心早已死掉
曾和你相爱如天命难违的凑巧
为何与你对决变成轮回的纷扰
爱如那常消的海潮退去时飘渺
我的心不再计较
情爱它似毒药 你我早就应该知道
为何却不停的要
为何却一再的要
我怎么才能登上你的爱情诺曼底
别让天与海的距离 衡量爱与恨的对立
怎么才能让我登上你的爱情诺曼底
狂奔在破晓的大地 拼了命也要找到你
占领这爱情诺曼底 Yeah

挑衅

我的梦早已归零 我的爱结成冰

退色的刺青 残留的姓名 那是我的曾经

别为我动了真情 别怪我那么ㄍㄧㄥ

孤独的背影 落寞的神情 经不起你的挑衅

不要闯进我冰冷的爱情 我怕沉睡的梦被你惊醒

无论束手就擒 或是抵挡你的入侵 都会让我 摇摆不定 触景伤情

你的梦如此清醒 你的爱太冷静

催泪的叮咛 温柔的神情 却又让我动心

别让我掉入陷阱 别恨我不敢听

固执的个性 坚定的表情 经不起你的挑衅

不要闯进我冰冷的爱情 我怕沉睡的梦被你惊醒

无论束手就擒 或是抵挡你的入侵 对我来说 都是挑衅

不要挑衅我冰冷的爱情 我怕醒来会爱你爱不停

请你别再靠近 不要让我恨不下心

现在的我 经不起你 一再挑衅

check all or none items in checkedlistbox

if (clientList.CheckedItems.Count == 0)
for (int i = 0; i < clientList.Items.Count; i++)
{
clientList.SetItemChecked(i, true);
}
else
for (int i = 0; i < clientList.Items.Count; i++)
{
clientList.SetItemChecked(i, false);
}

Visual Studio 2008 checkedlistbox

figured this way to databind checkedlistbox, not sure why DataSourse, ValueMember, and DisplayMember do not appear in intellisense

this.clientsTableAdapter.Fill(this.dataSet1.Clients);
practice2.DataSet1.ClientsDataTable t = clientsTableAdapter.GetData();
checkedListBox1.DataSource = t;
checkedListBox1.ValueMember = t.IdColumn.ColumnName;
checkedListBox1.DisplayMember = t.NameColumn.ColumnName;

detect if ActiveX is disabled

found this two links quite useful

tect the browser using ASP.NET and C#
http://www.codeproject.com/KB/aspnet/detectbrowser.aspx

How Can I Tell if ActiveX is Enabled in Internet Explorer?
http://www.microsoft.com/technet/scriptcenter/resources/qanda/nov05/hey1114.mspx

HAPPY Valentine's DAY!!!!!!!!!!!!!!!

HAPPY CHINESE NEW YEAR TO YOU ALL!!!!!!

五谷丰登 六畜兴旺 吉庆有余
惠风和畅 发家致富 日度小康
鼠年大吉 万事遂心 利国利民
一往无前 四海皆春 普天同庆

人逢盛世情无限；鼠拱华门岁有余

吉日生财鼠拱户；新春纳福鹊登梅

名题雁塔登金榜；鼠拱华门报吉祥

戌年引导小康路；亥岁迎来锦绣春

孟春之月方营室；宝盖进豕恰是家

国泰民安戌岁乐；粮丰财茂亥春兴

金榜题名光耀第；喜鼠拱户院生财

猪守家门旧主喜；鼠增财富新春欢

猪岁已赢十段锦；鼠年更上一层楼

猪年已展千重锦；鼠岁再登百步楼

猪问平安随腊去；鼠生财富报春来

make google dance~

found this link somewhere, it provides a block of javascript that makes images in google image search result dance in a queue, lol funny
http://www3.webng.com/redtophank/cit.html

ORA-00979: not a GROUP BY expression

problem query

select class_schedule.class_id, class_schedule.sum(class_schedule.enrolments) tot_enr, class.name from class_schedule inner join class on class_schedule.class_id = class.id group by class_schedule.class.id

solution

select class_schedule.class_id,
sum(class_schedule.enrolments) tot_enr, class.name
from class_schedule
inner join
class on class_schedule.class_id = class.id
group by class_schedule.class_id, class.name

how to convert my query to stored procedure

I have this procedure below:

set serveroutput on
DECLARE
v_counter NUMBER(7) := 0;
v_tax NUMBER(11,2) := 0;
v_an_sal NUMBER(11,2) := 0;
CURSOR emp_cursor IS
SELECT id, last_name, first_name, salary
FROM scott.s_emp;
--r_emp scott.s_emp%ROWTYPE;
BEGIN
DBMS_OUTPUT.PUT_LINE(rpad(‘ID’,5) || rpad(‘LAST_NAME’, 15) || rpad(‘FIRST_NAME’,15) || lpad(‘ANNUAL_SALARY’,11) || lpad(‘TAX’,11));
DBMS_OUTPUT.PUT_LINE(rpad(‘____ ’,5) || rpad(‘_______________’, 15) || rpad(‘_______________’,15) || lpad(‘___________’,11) || lpad(‘___________’,11));
FOR r_emp IN emp_cursor LOOP
v_counter := v_counter + 1;
v_tax := 0;
v_an_sal := r_emp.salary * 12;
IF v_an_sal > 150000 THEN
v_tax := 47850 + (v_an_sal -150000)*0.45;
ELSIF v_an_sal > 75000 THEN
v_tax := 17850 + (v_an_sal -75000)*0.40;
ELSIF v_an_sal > 25000 THEN
v_tax := 2850 + (v_an_sal -25000)*0.30;
ELSIF v_an_sal > 6000 THEN
v_tax := (v_an_sal -6000)*0.15;
ELSE
v_tax := 0;
END IF;
DBMS_OUTPUT.PUT_LINE(rpad(r_emp.id,5) || rpad(r_emp.last_name, 15) || rpad(r_emp.first_name,15) || lpad(v_an_sal,11) || lpad(v_tax,11));
IF v_counter mod 5 = 0 THEN
DBMS_OUTPUT.PUT_LINE('******************************************************');
END IF;
END LOOP;
END;
/

I need to convert it to a stored procedure (or create a sored procedure for this) so that i can call it from my psp pages.

solution:
remove 'DECLARE set serveroutput on'
replace with 'CREATE OR REPLACE PROCEDURE proc_emp_sum_analysis AS'

loop through query result and print each row in stored procedure

have this query which returns a set of rows, How can I loop through each row and display them using dbms.output.put_line? Please notice in the where clause there is a variable 'v_trainer_id', the variable value is known (retrieved from a column of a current row of another cursor)

select customer.id as customer_id, membership.join_date, membership.join_fee,round(months_between(sysdate, membership.join_date),0) as months_joined, membership_plan.monthly_price, membership.monthly_discount, (membership_plan.monthly_price- membership.monthly_discount) * round(months_between(sysdate, membership.join_date),0) as total_paidfrom membership,membership_plan,customerwhere membership.membership_plan_id = membership_plan.id andcustomer.id=membership.customer_id andmembership.trainer_id = v_trainer_idorder bycustomer.id;

solution:

v_cur_tid := r_trainer.trainer_id;FOR r_mem IN(select membership.customer_id as cust_id, membership.join_date, membership.join_fee,round(months_between(sysdate, membership.join_date),0) as months_joined, membership_plan.monthly_price, membership.monthly_discount, (membership_plan.monthly_price- membership.monthly_discount) * round(months_between(sysdate, membership.join_date),0) as total_paidfrom membership,membership_planwhere membership.membership_plan_id = membership_plan.id andmembership.trainer_id = v_cur_tidorder bymembership.customer_id)LOOP

PL/SQL: ORA-01744: inappropriate INTO

I have this part of the stored procedure, trying to use one select query to fill in 2 variables, got error 'PL/SQL: ORA-01744: inappropriate INTO'

--print summary of subsection

select t.* from (select count(membership.id) into v_tot_mem_by_trainer,sum((membership_plan.monthly_price- membership.monthly_discount) * round(months_between(sysdate, membership.join_date),0)) into v_tot_rev_by_trainerfrom membership, membership_planwhere membership.trainer_id = r_trainer.trainer_id andmembership.membership_plan_id = membership_plan.id) t;

this is the original select query that has no problem

select t.* from (select count(membership.id) as total_number_of_members,sum((membership_plan.monthly_price- membership.monthly_discount) * round(months_between(sysdate, membership.join_date),0)) as total_membership_paymentfrom membership, membership_planwhere membership.membership_plan_id = membership_plan.id) t;

the solution:

select t.* into v_tot_mem_by_trainer, v_tot_rev_by_trainer from (select count(membership.id),sum((membership_plan.monthly_price- membership.monthly_discount) * round(months_between(sysdate, membership.join_date),0))from membership, membership_planwhere membership.trainer_id = r_trainer.trainer_id andmembership.membership_plan_id = membership_plan.id) t;

ORA-00937: not a single-group group function

I want to select some data from table membership and membership_plan, these 2 have some relationships with each other. In the same query, I also want to 'select count(*) from customers' where customers table has no relationship with the other 2 tables, I just want to find out the total number of customers and display with the rest of the query results.

select (select count(id) from customer), count(membership.id) as total_number_of_members, sum((membership_plan.monthly_price- membership.monthly_discount) * round(months_between(sysdate, membership.join_date),0)) as total_all_members from membership,membership_planwhere membership.membership_plan_id = membership_plan.id;

I got an error message as below:
ERROR at line 1:ORA-00937: not a single-group group function

solution:

select (select count(id) from customer), t.* from (select count(membership.id) as total_number_of_members,
sum((membership_plan.monthly_price- membership.monthly_discount) * round(months_between(sysdate, membership.join_date),0)) as total_all_members
from membership, membership_plan
where membership.membership_plan_id = membership_plan.id) t;

oracle sqlldr datetime value problem

this is my loader ctl file

LOAD DATAINFILE 'trainer.data' BADFILE 'trainer.bad'DISCARDFILE 'trainer.dsc'REPLACEINTO TABLE trainerFIELDS TERMINATED BY ','TRAILING NULLCOLS(ID TERMINATED BY ',' ENCLOSED BY '"',FN TERMINATED BY ',' ENCLOSED BY '"',LN TERMINATED BY ',' ENCLOSED BY '"',GENDER TERMINATED BY ',' ENCLOSED BY '"',PHONE TERMINATED BY ',' ENCLOSED BY '"',MOBILE TERMINATED BY ',' ENCLOSED BY '"',EMAIL TERMINATED BY ',' ENCLOSED BY '"',CERTIFICATE_LEVEL TERMINATED BY ',' ENCLOSED BY '"',IS_PERSONAL_TRAINER TERMINATED BY ',' ENCLOSED BY '"',HIRE_DATE TERMINATED BY ',' ENCLOSED BY '"',IS_ACTIVE ENCLOSED BY '"')

the field 'hire_date' is a datetime field. e.g. '15-JUN-2005 13:30' in the format of 'DD-MON-YYYY HH24:Mi'. please see the first 3 rows of my datafile below:

"1","Cara","Surename","m","06623355","0446002359","lorem.ut.aliquam@dictum.edu","a","y","06-JUN-2006 00:00","y""2","Noble","Surename","m","28435168","0451498500","Mauris.magna.Duis@id.com","a","n","06-JUN-2006 00:00","y""3","Coby","Surename","f","79907443","0460112510","Mauris@accumsan.ca","d","n","06-JUN-2006 00:00","y"


then when i executed the ctl file, i got this error below in the log file

Record 1: Rejected - Error on table TRAINER, column HIRE_DATE.ORA-01830: date format picture ends before converting entire input stringRecord 2: Rejected - Error on table TRAINER, column HIRE_DATE.ORA-01830: date format picture ends before converting entire input stringRecord 3: Rejected - Error on table TRAINER, column HIRE_DATE.ORA-01830: date format picture ends before converting entire input string



solution:
HIRE_DATE DATE "DD-MON-YYYY HH24:Mi" TERMINATED BY ',' ENCLOSED BY '"',

An old joke about project manager

A tourist walked into a pet shop and was looking at the animals on display. While he was there,another customer walked in and said to the shopkeeper, "I'll have a C monkey please." Theshopkeeper nodded, went over to a cage at the side of the shop and took out a monkey. Hefitted a collar and leash, handed it to the customer, saying, "That'll be £5,000."

The customer paid and walked out with his monkey.

Startled, the tourist went over to the shopkeeper and said, "That was a very expensive monkey. Most of them are only a few hundred pounds. Why did it cost so much?" The shopkeeperanswered, "Ah, that monkey can program in C - very fast, tight code, no bugs, well worth themoney."

The tourist looked at a monkey in another cage. "Hey, that one's even more expensive! £10,000! What does it do?"

"Oh, that one's a C++ monkey; it can manage object-oriented programming, Visual C++, even some Java. All the really useful stuff," said the shopkeeper.

The tourist looked around for a little longer and saw a third monkey in a cage of its own. The price tag around its neck read £50,000. The tourist gasped to the shopkeeper, "That one costs more than all the others put together! What on earth does it do?"

The shopkeeper replied, "Well, I haven't actually seen it do anything, but it says it's a project manager".

oracle how to random select a value out of 2 letters

select chr(121 - 11 * (round(dbms_random.value))) is_successful from dual
or

select case when dbms_random.value(0,1) < 0.5 then 'y' else 'n' end is_successful from dual

or

select translate(dbms_random.string('U',1),'ABCDEFGHIJKLMNOPQRSTUVWXYZ','ynynynynynynynynynynynynyn') from dual

or

select distinct First_Value(is_successful) over(order by dbms_random.value) as is_successfulfrom (select 'n' as is_successful from dual union all select 'y' from dual);

or

substr('yn', dbms_random.value(1,3), 1)

oracle add a day

select sysdate+1 from dual

oracle add a day

select sysdate+1 from dual

oracle get a rendom set of string value with length in between 0 and 100

select dbms_random.string('l',dbms_random.value(0,100)) from dual

oracle return a range of integer

select level num from dual connect by level <= 5;

NUM
1
2
3
4
5

oracle get a random value out of a query result

I have a query:

select id from class_schedule where id not in (select distinct(event_id) from trainer_schedule)

I want to pick up a random value from this query result and assign it to a varible e.g. randomID.

solution:

randomID :=
select id from
(
select id from class_schedule
where id not in (select distinct(event_id) from trainer_schedule)
order by dbms_random.value
)
where rownum = 1

oracle update one table with values from another table

e.g.

update membership
set membership.join_fee = (select membership_plan.join_fee
from membership_plan
where membership.membership_plan_id = membership_plan.id)
where exists (select 1
from membership_plan
where membership.membership_plan_id = membership_plan.id)

ORA-06550 problem in script

Tried to execute the script below got error The query:

DECLARE
CURSOR sol_cursor IS select * from membership;
months NUMBER(5,0) :=0;
BEGIN
FOR r_sol IN sol_cursor LOOP
months := (select min_months from membership_plan where id = r_sol.membership_plan_id);
UPDATE membership
SET end_date = add_months(r_sol.end_date,months)
WHERE id = r_sol.id
END LOOP;
END;

ERROR:

ORA-06550: line 6, column 12: PLS-00103: Encountered the symbol "SELECT" when expecting one of the following: ( - + case mod new not null others avg count current exists max min prior sql stddev sum variance execute forall merge time timestamp interval date pipe

SOLUTION:
changing:
months := (select min_months from membership_plan where id = r_sol.membership_plan_id);

to:
select min_months INTO months from membership_plan where id = r_sol.membership_plan_id;

oracle add an hour

select to_char(to_date('15-08-2006 21:30','DD-MM-YYYY HH24:Mi')+1/24,'DD-MM-YYYY HH24:Mi') from dual
or
select sysdate, sysdate + 5/24 from dual;

I created this, do you know what it does?

update class_schedule set start_time= add_months(start_time, -12*

(select to_number(to_char(start_time,'yyyy')-2006) from dual)) where

to_char(start_time,'yyyy')> to_char(2006)


GOOD LUCK!

oracle add a year

update class_schedule set start_time = (select add_months(start_time,12*2003)from dual)

or

add_months(trunc(start_time),12*35)

oracle update and display datetime in Date datatype fields

update class_schedule set start_time = to_date('2003-06-13 15:18','YYYY-MM-DD HH24:MI') where id=17

select to_char(start_time,'YYYY-MM-DD HH24:MI') from class_schedule where id=17;

oracle generate a random date using julian dates

SELECT TO_CHAR(TO_DATE('2006-06-06', 'YYYY-MM-DD'), 'J') FROM DUAL;
--> 2453893

SELECT TO_CHAR(TO_DATE('2007-10-01', 'YYYY-MM-DD'), 'J') FROM DUAL;
--> 2454375


SELECT TO_DATE(TRUNC(DBMS_RANDOM.VALUE(2453893, 2454375)), 'J') FROM DUAL;

--> 19/SEP/06

using pl/sql dbms_random function for generating random values

UPDATE purchase_order_line
SET discount_total = (select round(dbms_random.value(0, 9999.22),2) from dual)
WHERE purchase_order_id = r_po.purchase_order_id;

using general expression when creating check constraint in pl/sql

CONSTRAINT "CUSTOMER_CK_PHONE" CHECK (REGEXP_LIKE ( phone, '^([0-9]*?\ ?\/?[0-9]{4}[0-9]{4})$ ' ) ) ENABLE

Oracle Database 10g Express Edition forgot password after installation

symptom:
I installed 10g ex a while ago, now try to login, but forgot what the password was for the default username "system", can any one please help to retrieve the password?

fix:
SQL> conn / as sysdba
Connected.
SQL> alter user system identified by ;

PL/SQL DBMS_OUTPUT.PUT_LINE formating experience

for the header row, do this:
DBMS_OUTPUT.PUT_LINE(rpad(‘ID’,5) || rpad(‘LAST_NAME’, 15) || rpad(‘FIRST_NAME’,15) || lpad(‘ANNUAL_SALARY’,11) || lpad(‘TAX’,11) || lpad(‘COMMISSION_PCT’, 16));
DBMS_OUTPUT.PUT_LINE(rpad(‘____ ’,5) || rpad(‘_______________’, 15) || rpad(‘_______________’,15) || lpad(‘___________’,11) || lpad(‘___________’,11) || lpad(‘______________’, 16));

then in the loop I did:
DBMS_OUTPUT.PUT_LINE(rpad(r_emp.id,5) || rpad(r_emp.last_name, 15) || rpad(r_emp.first_name,15) || lpad(v_an_sal,11) || lpad(v_tax,11) || lpad(v_com_pct, 16));

not very enjoyable way of formating, but it worked......

sqlplus view existing indexes

select * from user_indexes
where table_owner like 'xxxxxx' and table_name like 'ABC';

modify linewidth in sqlplus

set line 200;

upload sql database to the host environment

found this tool that makes it easier to upload sql database to the host environment
http://www.codeplex.com/sqlhost

oracle sqlplus

select TABLE_NAME, CONSTRAINT_NAME, STATUS
from USER_CONSTRAINTS
where TABLE_NAME like 'INVOICE';

the word after 'like' must be in capital, otherwise you won't get any result

make your DNN site home page style different to other pages

create a homepage skin with the LogoPane instead of the Logo skin token

all other pages will use a skin that has standard Logo skin token

yellow color flash when open a new page on DNN site

the background color of my site is mainly dark-red and black, the text is in white color. When i click on a link to open another page, the background always flash in yellow color and return back to normal. what happened?

answer:
there is a background color set to be yellow in the css, check it

how to remove DNN version number on the tab

update DNN site from version 3.1 to 3.3.7, now when i open the site in IE7, the version number is displayed together with the page title on the IE7 tab:

My Site > Home (DNN 3.3.7)

in order to get rid of the stuff in '()', Log in as superuser ("host"), go to host settings in host menu and uncheck "show copyright credits".

Oracle DB 10g EX SQL - case sensitivity

Only the text with quotes is case sensitive.

Oracle DB 10g EX SQL - create table - syntax to add Check

CREATE TABLE student(
student_no NUMBER(3) NOT NULL,
age NUMBER(2) CHECK(age>18),
gender CHAR(1) CHECK(gender='m' or gender='f') NOT NULL
);

Oracle DB 10g EX SQL - query the list of all columns in curent table

SELECT * FROM tab;

MS SQL - query the list of all columns in curent table

select column_name from information_schema.columns where table_name ='authors'

MS SQL - query the list of all tables in curent schema

select * from sysobjects where type = 'U' and uid=user_id('dbo')

Oracle DB 10g EX SQL - query the list of all tables in curent schema

SELECT * FROM tab;

filter a GridView column based on another column, ASP.NET

< asp:Button runat="server" ID="GoButton" Text="Go" CommandName="Select" Visible='<%# ((System.Data.DataRowView)Container.DataItem)["ABC"] != DBNull.Value %/>' />

Only String Type accpts null value in mssql db

if you want to do assign a NULL value to a integer type column, u will get error, I had to try to give a -1 value to work around, is there a better/real solution?

VS2005 ASP.NET Gridview Date Format

tried to format date boundfield to {0:dd/MM/YYYY}, it won't work, in order to solve the problem, you need to set the "HtmlEncode" of the column to "false"

TinyURL, something can help you to shorten long URLs

http://tinyurl.com/

ASP.NET 2005 issues with creating object data adapter in design view

normally when i create a table adapter in design view, i will have this list on the last step
Generated SELECT statement.
Generated INSERT statement.
Generated UPDATE statement.
Generated DELETE statement.
Generated table mappings.
Generated Get method.
Generated Update methods.
How come when i use Authors Table in Pubs sample database to create a table adapter, the line "Generated DELETE statement." is missing? (which means that the delete statement wasnt generated)

It is because:
there was no PK set in the author table when i took it out of the Pub database
now with a defined PK (the AuthorID), all the statements were generated correctly.
The designer just didn't provide enough information explaning why some of the statements havn't been generated. maybe it's something need to be improved....

how to install AJAX Control Toolkit

I went on to the http://www.codeplex.com/AtlasControlToolkit/Release/ProjectReleases.aspx?ReleaseId=1425 downloaded the toolkit, but no idea how to installed.

this is the place where i found the solution, hope it can help you too http://ajax.asp.net/ajaxtoolkit/Walkthrough/Setup.aspx

ASP.NET AJAX, not let autopostback items cause page reload when the postback occurs

e.g. on my form, clicking on the navigation items (or a dropdownlist control) on the left of screen will filter/refresh the gridview on the right hand side, how can i achieve this using Ajax and not let the navigation items (or a dropdownlist control) to reload themselves? (only the gridview refreshes) the dropdownlist has already been placed outside of UpdatePanel. the whole page reloads because the dropdownlist is "autopostback". I found 3 lines of code that helped me to stop the whole page reload:

This can also be achieved by setting "Triggers" property of the UpdatePanel in design view

any ideas?

i need to write up a research proposal this semester, what are the hot topics related to information systems at the moment? hope someone can help me out~

I am back!

happy chinese new year! now i am back to work & study, wish myself great achievement in 2007!

Controlling browser's control items

http://msdn.microsoft.com/library/default.asp?url=/workshop/author/dhtml/reference/methods/open_0.asp

Collapse and Expand HTML Elements

domCollapse
http://www.onlinetools.org/tools/domcollapse/index.html

free rich text editors

TinyMCE
http://tinymce.moxiecode.com/
http://rorlach.de/mediawiki/index.php/PHP

Rich Text Editor
http://www.websitescreation.ca/Products/RichText.php

char, varchar, nchar, nvarchar

nchar and nvarchar are used for unicode data, which require twice as much space (bytes) to store the same non-unicode characters. It is a significant disadvantage to use nchar and nvarchar if we do not need unicode charactors. Only use nchar & nvarchar when you need unicode charactors
use char & nchar when the length of the data is fixed, e.g. all customerID must be CUST_XXXX. use varchar and nvarchar when the length of the data is uncertain, e.g. customerID starts from 1 to 100000.

WebControls V,S HtmlControls in ASP.NET2.0

http://www.odetocode.com/Articles/348.aspx

asp.net2.0 upload file

use FileUpload control. this example checks for file type, empty file

protected void btnSaveFile_Click(object sender, EventArgs e)
{
if (IsPostBack)
{
Boolean fileOK = false;
String path = @"C:\temp\";
if (FileUpload1.HasFile)
{
String fileExtension =
System.IO.Path.GetExtension(FileUpload1.FileName).ToLower();
String[] allowedExtensions =
{ ".gif", ".png", ".jpeg", ".jpg" };
for (int i = 0; i < fileextension ="="" fileok =" true;" text = "File uploaded!" text = "File could not be uploaded." text = "Cannot accept files of this type.">

reference: http://msdn2.microsoft.com/en-us/library/ms227669.aspx

ASP.NET 2.0 “Ambiguous match found” error

when trying to load an ASPX page. The error was a “Parser Error” with “Ambiguous match found”.
The problem could be caused by having a member variable and a control variable with the same name (but different casing)
e.g.
private double aVariable = 0;
AnVariable.Text = aVariable .ToString("c");
The code will compile, and will run locally, but fails when deployed.

The solution is to rename the private member variables

*Thanks to Simon for the finding
*the reference: http://weblogs.asp.net/pjohnson/archive/2006/08/11/Ambiguous-match-found.aspx

unit testing issue (access denied - aborted) - VS Team - Developers

Symptom:
when i try to test a method, the result says "Aborted", and the error message was:
"Failed to Queue Test Run "@MACHINE1" 2006-12-04 17:13:30' with id {********-****-****-****-************}: Microsoft.VisualStudio.TestTools.TestManagement.ExecutionException: Test Run deployment issue: The location of the file or directory '\\server1\users\ab\my documents\visual studio 2005\projects\webservicepractice1\testproject1\bin\debug\testproject1.dll' is not trusted."

Solution
1. Control Panel --> .NET Framework 2.0 Configuration --> Runtime Security Policy --> Machine --> All_Code
2. Right click All_Code, select "New...", and give a name for your new group. Click Next and Next again
3. Type in "\\machine_name\shared_folder\assembly.dll" or "\\machine_name\shared_folder\*" and click Next
5. Make sure permission is set to FullTrust. Click Next, and Finish

.NET should be closed all the time while doing these settings

create & call stored procedure in ASP.NET 2.0 & MSSQL DB

<--CREATE-->
ALTER PROCEDURE dbo.NumOfRecords
AS
SELECT COUNT(*) FROM Branding
RETURN

<--CALL-->
protected void Button8_Click(object sender, EventArgs e)
{
SqlConnection newConn = new SqlConnection("Data Source=localhost;Initial Catalog=TCdatabase;Integrated Security=True;Pooling=False");
SqlCommand newComm = new SqlCommand("NumOfRecords", newConn);

newConn.Open();
int theTotal = (Int32)newComm.ExecuteScalar();
Response.Write(theTotal.ToString());
newConn.Close();
}

messagebox in ASP.NET 2.0

The basic concept is to use JavaScript. Below only shows one way of implementing javascript for messagebox:

switch (txtName.Value)
{
case ("aaa"):
Page.ClientScript.RegisterStartupScript(this.GetType(),"Alert","< script language="javascript" >alert('AAA');< /script >
");
break;

case ("bbb"):
Page.ClientScript.RegisterStartupScript(this.GetType(), "Alert", "< script language="javascript" >alert('BBB');< /script >
");
break;


}

deploy applications that use Microsoft SQL Server 2005 Express Edition (SQL Server Express),

http://msdn2.microsoft.com/en-us/library/ms165639.aspx

realize inputBox in C#.net by referencing VB.net component

this will add VB.NET runtime dependency in C# application, you can even add a reference to Microsoft.VisualBasic assembly and call InputBox function implemented there:

string aaa = Microsoft.VisualBasic.Interaction.InputBox("enter a name", "Inputbox Demo", "ROCKY", 100, 100);
MessageBox.Show(aaa);

Another way of doing it without referencing VB.net is to create a form that looks like an inputBox:


using System;

namespace MyNamespace
{
public class InputDialog : System.Windows.Forms.Form
{
private System.Windows.Forms.TextBox txtInput;
private System.Windows.Forms.Label label1;
private System.Windows.Forms.Button cmdOK;
private System.Windows.Forms.Button cmdCancel;

public string Value
{
get
{
return txtInput.Text;
}
set
{
txtInput.Text = value;
}
}

public InputDialog()
{
// Required for Windows Form Designer support
InitializeComponent();
}

private void InitializeComponent()
{
this.txtInput = new System.Windows.Forms.TextBox();
this.label1 = new System.Windows.Forms.Label();
this.cmdOK = new System.Windows.Forms.Button();
this.cmdCancel = new System.Windows.Forms.Button();
this.SuspendLayout();
//
// txtInput
//
this.txtInput.Location = new System.Drawing.Point(48, 16);
this.txtInput.Name = "txtInput";
this.txtInput.Size = new System.Drawing.Size(232, 20);
this.txtInput.TabIndex = 0;
this.txtInput.Text = "";
//
// label1
//
this.label1.AutoSize = true;
this.label1.Location = new System.Drawing.Point(8, 16);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(33, 16);
this.label1.TabIndex = 1;
this.label1.Text = "Input:";
//
// cmdOK
//
this.cmdOK.DialogResult = System.Windows.Forms.DialogResult.OK;
this.cmdOK.Location = new System.Drawing.Point(69, 48);
this.cmdOK.Name = "cmdOK";
this.cmdOK.TabIndex = 2;
this.cmdOK.Text = "OK";
//
// cmdCancel
//
this.cmdCancel.DialogResult = System.Windows.Forms.DialogResult.Cancel;
this.cmdCancel.Location = new System.Drawing.Point(149, 48);
this.cmdCancel.Name = "cmdCancel";
this.cmdCancel.TabIndex = 2;
this.cmdCancel.Text = "Cancel";
//
// Form1
//
this.AcceptButton = this.cmdOK;
this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
this.CancelButton = this.cmdCancel;
this.ClientSize = new System.Drawing.Size(292, 86);
this.Controls.Add(this.cmdOK);
this.Controls.Add(this.label1);
this.Controls.Add(this.txtInput);
this.Controls.Add(this.cmdCancel);
this.Name = "Form1";
this.Text = "Form1";
this.ResumeLayout(false);
}
}
}

convert sting value to the value of datetimepicker

generally the format should be everything except the AM part.

DateTime result = DateTime.Now;

if (DateTime.TryParse(this.label1.Text, out result))

{

this.dateTimePicker.Value = result;

}

We can also use DateTime.TryParseExact:
http://msdn2.microsoft.com/en-us/library/h9b85w22(VS.80).aspx

WinXP folder/file sharing ------ create a hiden share

A> create a hiden share
1. right click disk or folder you want to share and click on Sharing and Security
2. specify a share name with 1 - 11 characters, end with a "$"
3. if want to give edit rights, click on "allow net work users to change my files


B> access the hiden share
1. My Computer --> Tools --> Map Netwok Drive
2. give an unused drive letter and network parth of the hiden share, make sure to include the "$"
3. if select "Reconnect at logon", connection will be connected everytime start the pc, otherwise have to manually map everytime

inputbox in C#.net 2005 winform app

C# does not support inputbox, but C#.net2005 can have added reference to Microsoft.VisualBasic.dll

then in C#.net2005, you will be able to something like:

private void button3_Click(object sender, EventArgs e)
{
string userInput = Microsoft.VisualBasic.Interaction.InputBox("Give me something, I will tell you what you got?", "Question Popup", "Default Text",400,400).ToString();
MessageBox.Show(userInput);
}

use of YesNoCancel in messagebox.show() method in C#.net 2005 winform application

private void Form1_FormClosing(object sender, FormClosingEventArgs e)
{
e.Cancel = false;
DialogResult result = MessageBox.Show("Do you want to save any changes before closing this window? \n\n Click on 'Yes' to save; or \n Click on 'No' to close without saving; or \n Click on 'Cancel' to do nothing.", "Closing Window", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Question, MessageBoxDefaultButton.Button3);

if (result == DialogResult.Yes)
{
MessageBox.Show("you clicked on YES, c u!");
}
else if (result == DialogResult.No)
{
MessageBox.Show("you clicked on NO, c u!");
}
else
{
e.Cancel = true;
}
}

detailed explanation of application.settings in C#.net 2005

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnvs05/html/SettingsCS_RL.asp

make databound checkbox checked in C#.net2005 winform application

normal checkbox can use checkbox1.checked = true;

databound checkbox needs to change the checkstate: checkbox1.checkstate = checkstate.checked;

make databound checkbox checked in C#.net2005 winform application

normal checkbox can use checkbox1.checked = true;

databound checkbox needs to change the checkstate: checkbox1.checkstate = checkstate.checked;

check whether form is already opened in C#.net 2k5 winform application

created the form object in application settings

Code to open the form:
private void button1_Click(object sender, EventArgs e) {

if ( Properties.Settings.Default.frmReg == null )
{
Properties.Settings.Default.frmReg = new frmRegistration();
Properties.Settings.Default.frmReg.Show( this );
}
else if ( Properties.Settings.Default.frmReg != null && Properties.Settings.Default.frmReg.WindowState ==

FormWindowState.Minimized)
{
Properties.Settings.Default.frmReg.WindowState = FormWindowState.Normal ;
}
else
{
Properties.Settings.Default.frmReg.Focus();
}
}

Code to close the opened form:
Properties.Settings.Default.frmReg = null;

something wrong with goggle?

what's happening with blogger.com? the whole weekend and this monday morning, sometimes can't create a new post, sometimes changes to the template are not reflected, come on!!!!!

check whether form is already opened in C#.net 2k5 winform application

created the form object in application settings

Code to open the form:
private void button1_Click(object sender, EventArgs e) {

if ( Properties.Settings.Default.frmReg == null )
{
Properties.Settings.Default.frmReg = new frmRegistration();
Properties.Settings.Default.frmReg.Show( this );
}
else if ( Properties.Settings.Default.frmReg != null && Properties.Settings.Default.frmReg.WindowState == FormWindowState.Minimized)
{
Properties.Settings.Default.frmReg.WindowState = FormWindowState.Normal ;
}
else
{
Properties.Settings.Default.frmReg.Focus();
}
}

Code to close the opened form:
Properties.Settings.Default.frmReg = null;

testing post

testing post

using OleDbCommand class to update a database table based on one or more variable values C#.net 2005 winform app

using ( OleDbConnection connection = new OleDbConnection( Properties.Settings.Default.HPMConnectionString ) )
{
connection.Open();
OleDbCommand changeActiveToNoCommand = new OleDbCommand( "UPDATE staff SET active = no WHERE staff_id = @staff_id" , connection );
changeActiveToNoCommand.Parameters.AddWithValue( "@staff_id" , Convert.ToInt64( staff_id ) );
changeActiveToNoCommand.ExecuteNonQuery();
}

using OleDbDataReader class to retrieve a value based on one or more variable values C#.net 2005 winform app

string staff_no = staffDataGridView.CurrentRow.Cells[0].Value.ToString();

string staff_id="";

using (OleDbConnection connection = new OleDbConnection(Properties.Settings.Default.HPMConnectionString))
{
//OleDbCommand findStaffIDCommand = new OleDbCommand("SELECT staff_id FROM staff WHERE staff_no = '" + staff_no + "'", connection);
OleDbCommand findStaffIDCommand = new OleDbCommand( "SELECT staff_id FROM staff WHERE staff_no = @staff_no",connection );
findStaffIDCommand.Parameters.AddWithValue( "@staff_no" , staff_no );

connection.Open();
OleDbDataReader reader = findStaffIDCommand.ExecuteReader();

while (reader.Read())
{
staff_id = (reader[0].ToString());
}
reader.Close();
}
MessageBox.Show( staff_id.ToString() );

dataGridView show value of any cell on selected row (multiRow select = false) C#.net 2005

MessageBox.Show(clientsDataGridView.CurrentRow.Cells[0].Value + "");

tooltip in VS2005 winform and asp applications

in winform applications, there is a component called "tooltip", which can be referenced by other visual components

in asp.net applications, there is a property called "tooltip" for most of the visual components, which can be used to enter single line tooltipss.
There is a third party tooltip utility called "cooltip", which is much more powerful:
http://www.acooltip.com/index.html#

make combobox readonly in C#.net 2005 winform application

change the value of property "DropDownStyle" to "DropDownList)

referencing other classes C#.NET 2005

if you create a class within a subfolder of a winform project, you can't reference it within he code of a class in the root folder of project.
Solution:
to create the class in the same folder/rootlevel as the class that needs to have referencing code, and then move the class into anyother folder

access application settings in code C#.NET 2005

to access the values predefined in application settings, do this:
label1.Text = Properties.Settings.Default.aaa;
aaa is the name of the variable;

to persist the change, do this:
Properties.Settings.Default.aaa = "bbb";
Properties.Settings.Default.Save();

i am back

it's been a while.....
busy doing my masters and working at the same time. have to submit a report next monday, another one is coming soon.

feel lost.....