2007-12-20
2007-12-19
DateTimePicker vb.net 2005 bindingsource
- DateTimePicker.value = DateTime.Now().ToString("yyyy-MM-dd dddd hh:mm:ss tt")
- DateTimePicker.value = Format(Now, "yyyy-MM-dd dddd hh:mm:ss tt")
fixed by: assign value within form_load body.
2007-12-11
sql server functions
SQL Server 2000
There are three types of UDF in Microsoft SQL Server 2000:
- Scalar functions.
- Inline table-valued functions.
- Multistatement table-valued functions.
Scalar functions return a single data value (not a table) with RETURNS clause. Scalar functions can use all scalar data types, with exception of timestamp and user-defined data types. Inline table-valued functions return the result set of a single SELECT statement. Multistatement table-valued functions return a table, which was built with many TRANSACT-SQL statements.
User-defined functions can be invoked from a query like built-in functions such as OBJECT_ID, LEN, DATEDIFF, or can be executed through an EXECUTE statement like stored procedures.
2007-12-10
The Structure of Stored Procedures
(from SQL SERVER 2000 Stored Procedure Programming)
We will pause aminute to explain the structure of a stored procedure.
A stored procedure encapsulates a relatively simple Select statement for later use.
It returns a recordset containing values from the Selected column.
The recordset will contain only records that matched with the WHERE statement.
The code of a stored procedure consists of a header and a body.
The header of the stored procedure defines external attributes of the stored procedure—its name and a list of one or more parameters.
A example stored procedure has two parameters.
Parameter names must start with the @ character.
The developer must also define a datatype for each parameter.
The header must begin with the Create Procedure keyword and finish with the As keyword.
The body of the stored procedure contains the Transact-SQL statements to be executed when the stored procedure runs.
In this example, there is just one Select statement using the procedure parameters.
2007-12-03
钻石水机用户,是真是假,有关当局快快帮帮忙。
有線新聞踢爆鑽石能量水廣告
http://www.youtube.com/watch?v
鑽石水機用戶,請立刻驗腎!!!
請立刻轉寄給所有鑽石水機用戶,功德無量!!!
鑽石水機用戶感染腎小球腎炎 - 李小姐 32 歲,每年都有例行全身檢驗的習慣,
2006 年 2 月,李小姐安裝了一台鑽石水機,開始生飲過瀘後的水,
2006 年4月作例行全身檢驗時發覺感染了腎小球腎炎,腎功能開始衰退。
據知馬來西亞,新加坡和香港已有多人受感染。 鑽石水機大腸桿菌嚴重超標
鑽石水機用戶陳先生,2006 年6月安裝了一台鑽石水機,開始生飲過瀘後的水,
感到身體不適,每天肚瀉多次,代理解釋為好轉反應,陳先生不放心
於是自行把過瀘後
陳先生於是立刻退機。
Cz: 有关当局快帮帮忙,别让你忠实的用户,过于担心。
好的产品当然不怕考验,希望这一封转邮,纯属恶搞。
要不然,受害者多得是啊~
p/s:查证后,将有详细的讯息 将陆续上载~
new function of blogger
today, new function from blogger.
Write. Share. Post.
Post to Blogger from Google Docs & Spreadsheets.
friendster vs facebook
2007-11-30
From - An.Inconvenient.Truth.2006.
Learn as much as you can about the climate crisis.
Then put your knowledge into action. www.climatecrisis.net
2007-11-29
vb.net time format string.
| Codes | Output |
|---|---|
| Format(Now, "h") | System.FormatException was unhandled Input string was not in a correct format. |
| FormatDateTime(Now, DateFormat.ShortTime) | 19:36 (in 24 hour) |
| DateTime.Now.ToString("h") or Now.ToString(" h") | 7 (in 12 hour) |
| Now.Hour.ToString(" h") | h (not appear figure in hour) |
转:hottest forum in china
[5:32:27 PM] Gwyneth Tham says: iit's one of the hottest forum in china nowadays
[5:32:27 PM] Gwyneth Tham says: it has lots of forums for lots of topics
Formatting Dates and Times
Formatting Dates and Times
A format string for date/time values can use one of the predefined string values shown in the following table.
| String | Description |
|---|---|
| Long DateD | Displays a date in long date format. |
| Short Dated | Displays a date in short date format. |
| Long TimeT | Displays a date in long date format. |
| Short Timet | Displays a date in short date format. |
| F | Displays the long date and long time. |
| f | Displays the long date and short time. |
| g | Displays the short date and short time. |
| Mm | Displays the month and the day of a date. |
| Yy | Formats the date as the year and month. |
Examples of applying a format string to date/time values are shown in the following table.
| Format | Output |
|---|---|
| Format(Now,"D") | Thursday, November 29, 2007 |
| Format(Now,"d") | 11/29/2007 |
| Format(Now,"T") | 3:20:02 AM |
| Format(Now,"t") | 3:20 AM |
| Format(Now,"F") | Thursday, November 29, 2007 3:20:02 AM |
| Format(Now,"f") | Thursday, November 29, 2007 3:20 AM |
| Format(Now,"g") | 11/29/2007 3:20 AM |
| Format(Now,"m") | November 29 |
| Format(Now,"y") | November, 2007 |
kitten for adoption
TypeInitializationException was unhandled
2007-11-24
Editing guide for private battlenet server of Warcraft III.
just simply a lousy guide for editing private battlenet server of warcraft III,
will keep update ya.
(assuming your copy of Warcraft III in pc is installed, able to play in single player and LAN,
and u able to connected to official battlenet servers,
but could not login due to id and password)
| Tools: BNetGatewayEditor.exe version: 2.0.3.1. (perfer this version's flexibilities) | Url: http://track.eurobattle.net/ browser: any will do. (any will do) |
To be continue...
different of beginning and ending.
"~=~N0body cAn g0 baCk and staRt a nEw begiNning, but any0ne can sTart t0day and mAke a new ending."~=~"
2007-11-21
2007-11-20
转:是真是假,如何查证呢?
有個朋友,在一次烤肉聚會當中絆倒了,摔了一跤,旁邊的朋友建議找醫護人員,但她很確定自己沒事, 只是穿了新鞋被磚塊絆了一下罷了。她還有點危危顫顫站立不穩的時候,朋友們幫她清洗乾淨,又為她盛了一盤食物, 她就跟著大家一起享受接下來的時光了。
她的先生後來打電話通知大家,她被送到醫院,傍晚六點,就過世了,原因是她在烤肉聚餐的時候中風。如果他們懂得辨識 中風的癥兆,她現在也許還跟我們在一起。有些人不會死,但結局處於無助無望的景況中。
只需要花一分鐘的時間讀完這篇文章,腦神經外科醫師說,如果他能在三 小時之內接觸到中風患者,他就可以將中風的後果完全扭轉過來。訣竅就是辨識診斷出中風的問題,並讓病患在三小時之內接受醫療,而這是很難的。
辨識中風感謝 上帝讓我們記住 STR 三步驟,請閱讀並學習 !
有時候中風的癥兆很難辨認,不幸的是,缺乏警覺就會帶來災難。身邊的人辨認不出中風的徵兆,中風患者就會嚴重腦傷。醫生說,旁人只要問三個簡單的問題, 就可以辨識中風:
S : (smile) 要求患者笑一下
T : (talk) 要求患者說一句簡單的句子(要有條理,有連貫性),
例如:今天天氣晴朗。
R : (raise) 要求患者舉起雙手注意:
另外一項中風癥兆是: 要求患者伸出舌頭 ,如果舌頭「彎曲」或偏向一邊,那也是中風的徵兆。
上面四個動作,患者如果有任何一個動作 做不來, 就要立刻打 999!!!
並且把症狀描述給接線者聽。
心臟科醫師說,收到這封電函的人, 若能將它轉寄給 10 個人, 就至少可以救一條命。
Cz:是真是假,如何查证呢?唯有记在脑力,别等要派上用场时,记不着。。。那就无法查证了咯~
2007-11-15
dig and view CHKDSK result after reboot
Event Type: Information
Event Source: Winlogon
Event Category: None
Event ID: 1001
Date: 2007-11-05
Time: 10:46:38 PM
User: N/A
Computer: CZ
Description:
Checking file system on C:
The type of the file system is NTFS.
A disk check has been scheduled.
Windows will now check the disk.
Cleaning up minor inconsistencies on the drive.
Cleaning up 127 unused index entries from index $SII of file 0x9.
Cleaning up 127 unused index entries from index $SDH of file 0x9.
Cleaning up 127 unused security descriptors.
CHKDSK is verifying Usn Journal...
Usn Journal verification completed.
CHKDSK is verifying file data (stage 4 of 5)...
Read failure with status 0xc000009c at offset 0x891a9d000 for 0x10000 bytes.
Read failure with status 0xc000009c at offset 0x891aa9000 for 0x1000 bytes.
Windows replaced bad clusters in file 10539
of name \DOCUME~1\billson.CZ\Desktop\NTUSER~1.BAK.
File data verification completed.
CHKDSK is verifying free space (stage 5 of 5)...
Free space verification is complete.
Adding 1 bad clusters to the Bad Clusters File.
CHKDSK discovered free space marked as allocated in the
master file table (MFT) bitmap.
Correcting errors in the Volume Bitmap.
Windows has made corrections to the file system.
52428095 KB total disk space.
23384276 KB in 102093 files.
45132 KB in 16197 indexes.
4 KB in bad sectors.
306139 KB in use by the system.
65536 KB occupied by the log file.
28692544 KB available on disk.
4096 bytes in each allocation unit.
13107023 total allocation units on disk.
7173136 allocation units available on disk.
Internal Info:
90 12 02 00 1c ce 01 00 1f fa 02 00 00 00 00 00 ................
d7 00 00 00 00 00 00 00 5f 01 00 00 00 00 00 00 ........_.......
08 36 c3 03 00 00 00 00 9c 35 d5 3f 00 00 00 00 .6.......5.?....
68 10 9d 03 00 00 00 00 5c 2e 6f 6d 02 00 00 00 h.......\.om....
08 b8 90 f4 00 00 00 00 fc 5e 2d ba 03 00 00 00 .........^-.....
99 9e 36 00 00 00 00 00 d8 3c 07 00 cd 8e 01 00 ..6......<...... 00 00 00 00 00 50 43 93 05 00 00 00 45 3f 00 00 .....PC.....E?.. Windows has finished checking your disk. Please wait while your computer restarts. For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
| Details | |
| Product: | Windows Operating System |
| ID: | 1001 |
| Source: | Winlogon |
| Version: | 5.0 |
| Symbolic Name: | EVENT_AUTOCHK_DATA |
| Explanation | |
Chkdsk ran on one of the volumes when the computer restarted. A log file, bootex.log, was created and stored in the root of the volume. This file states whether Chkdsk encountered any errors and, if so, whether they were fixed. | |
| User Action | |
No user action is required. | |
| Version: | 5.2 |
| Symbolic Name: | EVENT_AUTOCHK_DATA |
| Explanation | |
Chkdsk ran on one of the volumes when the computer restarted. A log file, bootex.log, was created and stored in the root of the volume. This file states whether Chkdsk encountered any errors and, if so, whether they were fixed. | |
| User Action | |
No user action is required. | |
| Version: | 5.2.3790.1830 |
| Message: | NTFS - Autochk: file system check occurred on startup |
| Explanation | |
Microsoft® Windows® encountered corrupted file-system metadata during the last Windows session, so Windows marked the file system as “dirty” (corrupt). Windows ran the chkdsk /f command during startup in an attempt to repair the corrupted file system metadata. Related EventsChkdsk: Event ID 26180 CauseThe file system might have been marked as “dirty” (corrupt) for one of the following reasons:
| |
| User Action | |
This message is provided to inform you that thechkdsk command was run on the file system. No actions are required, but the corrupted disk might indicate other disk problems. You should do the following:
Related ResourcesFor more information about chkdsk, see Knowledge Base article 187941, “An Explanation of CHKDSK and the New /C and /I Switches,” at http://go.microsoft.com/fwlink/?LinkId=25770. | |
2007-11-14
Island near Phuket
Just grand opened
+ Large 400px
+ Show captions
+ Autoplay
- HTML Links (for MySpace)
but where is there actually?
911 will solve math as well for a 4 years old child.
you might think this is idiot. But...
who knows the reason behind this conversation?
i strongly giving out, this is one of the right way to educate some children.
911 emergency. Cz: greeting with manner
Yeah. I need some help.
What's the matter? What... Cz: lead the child to express himself.
With my math.
With your mouth? Cz: confirm the answer from the child.
No, with my math. I've to do it.
Will you help me?
Sure. What kind of math do you have that you need help with? Cz: inorder to keep communicating, operator keep agree with children request. eventhough this is out of "common sense" that adults think that shouldn't happen." (agree this request will easy for operator to question back later.)
I've. I've take-aways.
Oh, you gotta do the take-aways? Cz: confirm again the answer from the child.
Yeah.
All right what's the problem? Cz: lead again the child to express himself.
Okay, "Sixteen..."
...Yeah... Cz: respone to the child
"...take away eight..."
...uh-huh... Cz: respone again to the child
...is what?
You tell me. How much do you think it is? Cz: educate again by leading the child to think on what he is trying to solve. (later might let the child know this kind of problem/matter shouldn't call to 911)
I dunno, "one?"
No... How old are you? Cz: response back to the child about the answer is wrong, and trying to communicate with child by getting personal information.
I'm only four.
Four? Cz: confirm again the answer from the child.
Johnny, what are you doing?
This policeman is helping me with my math!
What did I tell you about playing on the phone?
Listen to the mother... Cz: operator again educate the child, by telling listen to the mother, but did not telling the child should listen to him.(if other people talk to this child again, child might remember about this call that he should listen to mother, not other stranger on the phone)
You said when i need help... to call somebody!
I didn't mean the POLICE!
......
educate children deep into their mind unconsciously.
In Malaysia, when will this kind of conversation happen?