MY BLOG SPACE

Most influential computer books

2011-09-07T04:08:00.000-07:00

Stackflow has a 3 year old post for voting the most important IT books. The vote can be found here.

The top 10 books are:

Code Complete (2nd Ed) by Steve McConnell
The Pragmatic Programmer;
Structure and Interpretation of Computer Programs
The C Programming Language by Kernighan and Ritchie
Introduction to algorithms (Cormen, Leiserson, Rivest, Stein) aka CLRS
Refactoring: Improving the Design of Existing Code
Design Patterns by the Gang of Four
The Mythical Man-Month.
The Art of Computer Programming
Compilers: Principles, Techniques, and Tools

I've read the Refactoring and Design Pattern but not the rest of them. They are really good. Hope to have to to go through them when I'm free.

Resizing partition for HP laptop

2011-09-06T04:51:00.000-07:00

Last Sunday, I bought a new HP pavilion dv6 6024TX for my wife. She was quite happy with the new machine. The only flaw is that the whole 750G HDD has only one drive C. (There are 4 partitions but rest of them are for recovery purpose). So I take the responsibility to reorganize the partitions.

I did that before by reinstall the OS. But this time I decided to resize the existing partition without losing exist data and create a new partition on freed space.

I started to try Partition Magic of Symantec since I have used it long time before. Unfortunately, the product has been discontinued by its owner as described in this post.

I have to find another tool. After searching around on net, I found GParted. The tool is open source and powerful. It can be downloaded here.

In order to use GParted, system need to be boot under GParted itself. So a bootable USB is needed. I took the follow steps to setup a bootable USB

USB setup with Windows

Download the GParted Live zip file.
If you already have a partition of at least 200 MB in size on your USB flash drive formatted with a FAT file system then skip to the next step (3).
Otherwise create at least a 200 MB partition on your USB flash drive and format it with a FAT16 or FAT32 file system.
Extract all the contents of the zip file to FAT16/FAT32 partition on your USB flash drive. Keep the directory architecture, for example, file "COPYING" should be in the USB flash drive's top directory (e.g. G:\COPYING).
Browse to your USB flash drive and as an administrator, click the makeboot.bat in the dir utils\win32\. WARNING! Makeboot.bat must be run from your USB flash drive.
Follow the on-screen instructions.
(PS: The above description is modified from: http://www.pendrivelinux.com/2007/01/02/all-in-one-usb-dsl. Thanks to PDLA from http://pendrivelinux.com)

There are also other ways to create bootable USB. Check out this link to find more

After setup the USB, reboot system from USB. In order to boot from USB, I need to enter BIOS(press F10 to enter BIOS for HP laptop) and change boot order.

The system will start Debian Linux and eventually enter GParted. It is a X window program looks like this.

Then I can do tasks like resize a partition, create a new partition etc. The whole information about how to use can be found in Help Manual,

It's not end yet. As I tried to create a new partition on freed space I get this error:

You can not have more than 4 primary partitions

This is because there are already 4 there, one is driver C and the other 3 are HP_TOOLS, RECOVERY and SYSTEM. Windows has the limitation that a machine cannot have more than four primary partitions.

So I have to delete one of them. I backup up the Recovery through HP tool Recovery Manager to 4 DVD. It was pretty straightforward and the instructions can be found here on HP support site.

After all this, I created a new partition and named it D drive.

12 Absolutely and Insanely Essential Utilities For Programmers

2010-08-31T17:48:00.000-07:00

12 Absolutely and Insanely Essential Utilities For Programmers from Jesse Liberty

Tortoise SVN
ExamDiff Pro
TimeSnapper
Snip it pro
Evernote
Mozy
Mikago

Performance tuning tricks for Web App

2010-08-30T22:32:00.000-07:00

Mads Kristensen talked about perfornace tuning tricks. This is the second part of the series and is quite useful. The download zip contains tools mentioned in his post.

The post also have links to some good performance articles and tools like Microsoft Ajax Minifier, YUI Compressor and Google Closure Compiler.

Scale out in SQL Server 2005

2009-11-26T21:54:00.000-08:00

There is an msdn article about scale out architecture for SQL Server 2005. The link is here Scale Out SQL Server 2005

Microsoft provide an open souce CMS

2008-12-09T21:11:00.000-08:00

MS developed an open source CMS codenamed "Oxite". It's at alpha version stage.

From Microsoft’s description of Oxite:

“Oxite provides you with a strong foundation you can build upon - pingbacks, trackbacks, anonymous or authenticated commenting (with optional moderation), gravatar support, RSS feeds at any page level, support for MetaWebLog API (think Windows Live Writer integration made easy), web admin panel, support for Open Search format allowing users to search your site using their browser’s search box, and more - so, you can spend time on designing a great experience.”

Please go to here for some detail

Free refactor in Visual Studio

2008-11-30T17:22:00.000-08:00

There aren't many articles about build-in refactor tool in VS 2008. I find one post Refactoring In Visual Studio 2008. This can be used as a start point to this refactoring tool.

Also, DevExpress provided a free Refactor! for VS 2005. I found it originally from Free refactoring tools for ASP.NET code in Visual Studio 2005. Not sure if it works fine in VS 2008.

Output GridView to Excel

2008-11-27T19:32:00.000-08:00

To output GridView or DataGrid to Excel file, one can use:

Use oledb classes to create and write data into Excel file

If datasource is DataTable or DataSet, use writeXml method

Use RenderControl method of Control class

Taking the latest way as an example

System.IO.StringWriter stringWrite = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
htmlWrite.WriteLine("<table cellspacing=\"0\", rules=\"all\", border=\"1\">");
gvResult.RenderControl(htmlWrite);
htmlWrite.WriteLine("</table>");

System.Text.UnicodeEncoding encoding = new System.Text.UnicodeEncoding();

String fileName = Guid.NewGuid().ToString() + ".xls";
String path = @"c:\temp\";
File.WriteAllText(path + fileName, stringWrite.ToString(), encoding);

Data Binding Expression

2008-11-27T19:04:00.000-08:00

One can use objects as datasouce and bind to it by using GridView control.

<asp:Label ID="lbNumber" runat="server" Text='<%#Eval("Number") %>'></asp:Label>

Here "Number" is a property of the datasouce object.

If the field of datasouce is a strong typed object itself, we can also use like this:

<asp:Label ID="lbProjectType" runat="server" Text='<%#Eval("ProjectType.Type") %>'></asp:Label>

"ProjectType" is a property of datasouce object and is an object which has a member called "Type".

If we want to do some complex work during binding, we can also do it at code behind. One approach is writing code in RowDataBinding or ItemDataBinding event handler, The other way is define a method and call it declaratively. Below is an example for the later:

<asp:Label ID="lbScheduledDate" runat="server" Text='<%# DisplayDate(Eval("ScheduledFrom"), Eval("ScheduledTo")) %>'></asp:Label>

IIS can not access by anonymous account

2008-11-06T14:12:00.000-08:00

Recently I encounter an issue. Windows anonymous account can not access local IIS. The security setting in IIS is correct.

After a couple of hours searching on internet. I find the cause. That's because my IUSR_computername doesn't has the right of "log on locally". So I go to:

controlpanel -> Admin Tool -> Local Security Settings -> Local Policies -> User Rights Assignment and find that Guest group doesn't have the permission of "Log on locally". Since IUSER_computername is memeber of Guest group. It doesn't have it as well.

I removed it from Guest group and add it to User group to make this account can be log on locally.

Auth Diagnostics 1.0 is a good tool to find IIS authentication issues. It can be downloaded here

Also, there is a good guideline here to help troubleshooting such issue.

Create Template Dynamically - Part 2

2008-11-02T22:07:00.000-08:00

In my previous blog entry: Create Template Dynamically. I mentioned a nice article on this topic. This article shows how to implement ITemplate interface to build template.

Another article, Using Templated Controls Programmatically shows how to use CompiledTemplateBuilder to do the something. Actually, CompiledTemplateBuilder class is an implement of ITemplate, in it's constructor, a method need to be passed in. And later on, it's initiateIn method will call the method to finish render task.

Create Template Dynammically

2008-10-31T19:44:00.000-07:00

Some ASP.NET server controls, like GridView, ListView, Menu provide templates, we can use templates to partially change render behaviors of these controls. Usually we achieve this by using declarative.

However, chances are that we need to create and use templates programmatically. Here is a nice article written by Dino Esposito. Although it is written several years ago, the concept is remain unchanged.

ModalPopupExtender with PostBack and Set Focus

2008-10-29T20:09:00.000-07:00

There is a good article about how to add postback and setfocus on ModalPopupExtender.

Check out here

Import Excel spreadsheet into SQL Server table

2008-10-09T20:23:00.000-07:00

MVP David Hayden has written some good articles regarding the data import/export between Excel and SQL Server. They can be found in links below:

Import Excel Spreadsheet Data into SQL Server Database Table Using SqlBulkCopy

Reading and Writing Excel Spreadsheets Using ADO.NET C# DbProviderFactory

Thanks David.

Ultimate Regular Expression for HTML tag parsing with PHP

2008-08-31T17:51:00.000-07:00

Go to this link

1054 Unknown column 'p.products_id' in 'on clause'

2008-05-03T15:58:00.000-07:00

When upgrade mySQL 4.x to mySQL 5.x, it will create this error in zen-cart 1.2.x. The get around is change sql select statemenst as follows:

ZenCart/includes/modules/meta_tags.php, about line 180

from ((" . TABLE_PRODUCTS . " p), " . TABLE_PRODUCTS_DESCRIPTION . " pd) left join " . TABLE_META_TAGS_PRODUCTS_DESCRIPTION . " mtpd on mtpd.products_id = p.products_id and mtpd.language_id = '" . (int)$_SESSION['languages_id'] . "

ZenCart/includes/blocks/blk_advanced_search_result.php

$from_str = "from (((" . TABLE_PRODUCTS . " p) left join " . TABLE_MANUFACTURERS . " m using(manufacturers_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd), " . TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c) left join " . TABLE_META_TAGS_PRODUCTS_DESCRIPTION . " mtpd on mtpd.products_id= p.products_id and mtpd.language_id = '" . $_SESSION['languages_id'] . "'";

ZenCart/includes/index_filters/default_filter.php

$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, if(s.status = '1', s.specials_new_products_price, NULL) AS specials_new_products_price, IF(s.status = '1', s.specials_new_products_price, p.products_price) as final_price, p.products_sort_order from (" . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c) left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$_GET['manufacturers_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$_SESSION['languages_id'] . "' and p2c.categories_id = '" . (int)$_GET['filter_id'] . "'";
} else {
// We show them all
$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, IF(s.status = '1', s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status = '1', s.specials_new_products_price, p.products_price) as final_price, p.products_sort_order from (" . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m) left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '" . (int)$_SESSION['languages_id'] . "' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$_GET['manufacturers_id'] . "'";
}
} else {
// show the products in a given categorie
if (isset($_GET['filter_id']) && zen_not_null($_GET['filter_id']))
{
// We are asked to show only specific catgeory
$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, IF(s.status = '1', s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status = '1', s.specials_new_products_price, p.products_price) as final_price, p.products_sort_order from (" . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c) left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$_GET['filter_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$_SESSION['languages_id'] . "' and p2c.categories_id = '" . (int)$current_category_id . "'";
} else {
// We show them all
$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, IF(s.status = '1', s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status ='1', s.specials_new_products_price, p.products_price) as final_price, p.products_sort_order from (" . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c) left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$_SESSION['languages_id'] . "' and p2c.categories_id = '" . (int)$current_category_id . "'";

ZenCart/includes/modules/product_listing.php, line 1

if($m_brandname&&!$model_code)
{
$listing_sql = "select p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, IF(s.status = '1', s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status ='1', s.specials_new_products_price, p.products_price) as final_price, p.products_sort_order from ((".TABLE_PRODUCTS_DESCRIPTION." pd, ".TABLE_PRODUCTS." p) left join ".TABLE_MANUFACTURERS." m on p.manufacturers_id = m.manufacturers_id, ".TABLE_BRAND_MODEL." bm) left join ".TABLE_SPECIALS." s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = bm.product_id and pd.products_id = bm.product_id and pd.language_id = '1' and bm.brand_name = '".$m_brandname."' order by p.products_sort_order, pd.products_name";
}
else if($m_brandname&&$model_code)
{
$listing_sql = "select p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, IF(s.status = '1', s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status ='1', s.specials_new_products_price, p.products_price) as final_price, p.products_sort_order from ((".TABLE_PRODUCTS_DESCRIPTION." pd, ".TABLE_PRODUCTS." p) left join ".TABLE_MANUFACTURERS." m on p.manufacturers_id = m.manufacturers_id, ".TABLE_BRAND_MODEL." bm, ".TABLE_MODEL." md) left join ".TABLE_SPECIALS." s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = bm.product_id and pd.products_id = bm.product_id and pd.language_id = '1' and bm.brand_model_id = md.brand_model_id and md.model_code = '".$model_code."' order by p.products_sort_order, pd.products_name";
}
else if($p_brandname&&!$part_code)
{
$listing_sql = "select p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, IF(s.status = '1', s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status ='1', s.specials_new_products_price, p.products_price) as final_price, p.products_sort_order from ((".TABLE_PRODUCTS_DESCRIPTION." pd, ".TABLE_PRODUCTS." p) left join ".TABLE_MANUFACTURERS." m on p.manufacturers_id = m.manufacturers_id, ".TABLE_BRAND_PART." bp) left join ".TABLE_SPECIALS." s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = bp.product_id and pd.products_id = bp.product_id and pd.language_id = '1' and bp.brand_name = '".$p_brandname."' order by p.products_sort_order, pd.products_name";
}
else if($p_brandname&&$part_code)
{
$listing_sql = "select p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, IF(s.status = '1', s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status ='1', s.specials_new_products_price, p.products_price) as final_price, p.products_sort_order from ((".TABLE_PRODUCTS_DESCRIPTION." pd, ".TABLE_PRODUCTS." p) left join ".TABLE_MANUFACTURERS." m on p.manufacturers_id = m.manufacturers_id, ".TABLE_BRAND_PART." bp, ".TABLE_PART." pt) left join ".TABLE_SPECIALS." s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = bp.product_id and pd.products_id = bp.product_id and pd.language_id = '1' and bp.brand_part_id = pt.brand_part_id and pt.part_code = '".$part_code."' order by p.products_sort_order, pd.products_name";
}

Although this may not solve all issues, most are eliminated

DataGrid.ItemCommand doesn't fire

2008-05-01T18:03:00.000-07:00

In one of my web application, ItemCommand event of a datagrid doesn't fire as expected. After some work, I find out the reason.

The bind to datasouce code of this datagrid control is put in Page_PreRender handler, not in Page_Load. On first load of the page, everything is fine, the rows are populated in datagrid and I add "cancel" button for each row.

Then I click "cancel" button, which trigger a postback. Again, Page_Load hander runs first. Then .NET framework try to call ItemCommand event, I reckon it checks the rows in datagrid and since their are no rows yet. It decides not to call ItemCommand. Then Page_PreRender is called. The command is ignored.

So, don't do important tasks in Page_PreRender

Use custom control in Page_Load

2008-05-01T16:44:00.000-07:00

As known, custom control's onload() method is called after container's page_load event fires. So in Page_Load handler, custom control hasn't been fully initialized. Although we can do something on custom control in prerender handler, but sometimes we need custom control ready before anything else can do.

Here is an example:

If we have an authenticate custom control and we want everything else run after check the permission of user, we have to make sure custom control is ready. But since onload hasn't been invoked, the codes in it hasn't been executed yet.

The work around is put all code in onload to anothe method, then call it directly from container page's Page_Load handler.

How to prevent Post back event when page refresh

2008-04-29T18:30:00.000-07:00

One annoying behavior of ASP.NET pages is a replay of postback events when user hit refresh (F5) in browser.
This behavior is easily reproducible:
Place ASP button on Web Form
1. Add some code to Button_Click event
2. View page in browser
3. Check that your code being executed when you hit button
4. Refresh page and observe that your code being executed once again

The are a couple of solutions to get around this. But the easiest way is like this,

At the end of eventhandler, ie. button click, itemcommand, insert a line of code.

Response.Redirect("thispage.aspx ");

Which means, just redirect to the same page.

Also, this can be used to disable Back button

Eric

Error when installing .NET Framework 3.0

2008-04-07T03:53:00.000-07:00

Microsoft .NET Framework 3.0 has encountered a problem during setup.
Setup did not complete correctly.

occured while installing the .NET 3.0 redistrubutable (downloaded from here) on my PC running XP Pro SP (also with .NET 1.1 & 2.0).

After some investigation it turns out this error was caused when installing the WCF (Windows Communication Foundation) components - when trying to open the following registry key:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Security\ServiceModel 3.0.0.0

I thought this was odd, because my user is a local admin - so in regedit (regedt32) I tried giving my user permissions to full control of this registry node... then reran the install - however to no avail - same error.

So, tried giving Everyone full control of this node - reran the install - and bingo, it worked!

For those of you who don't know - here's how:

1. Open the registry editor: Start - Run..., then enter "regedt32" (without quotes).
2. Navigate down to the node by opening each node in the heirarchy.
3. Right click on the node we're after (ServiceModel 3.0.0.0) and select Permissions
4. Click on Add, then enter "everyone" (no quotes) on the 'Select Users, Computers or Groups' dialog then click OK.
5. Back on the 'Permissions for ServiceModel 3.0.0.0' dialog select the user group Everyone, then make sure the Full Control checkbox has a tick, then click OK.

Thats it - now rerun the .NET 3.0 installation.

NuSoap notice

2007-12-19T15:48:00.000-08:00

1. Put all defination of complex type into one file

2. When use .net application to call Nusoap web service, use wsdl.exe instead of add web reference to create proxy class

MySql commands

2007-11-04T21:20:00.000-08:00

1. mysql -h localhost -u root -p

2. dump database
mysqldump -h localhost -u root -p DBNAME>c:\dumpfile.sql

3. restore database
mysql -h localhost -u root -p DBNAME<c:\dumpfile.sql

Five free Web apps we can't live without

2007-09-30T18:46:00.000-07:00

Ta-da List
PBWiki
Google Docs
Bloglines V3
Zoho Creator

http://www.computerworld.com/action/article.do?command=printArticleBasic&articleId=9038638

Three internet platform

2007-09-20T17:38:00.000-07:00

http://blog.pmarca.com/2007/09/the-three-kinds.html

Using JavaScript Along with ASP.NET

2007-09-13T17:50:00.000-07:00

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

2007-08-29T06:17:00.000-07:00

1. 被点到名字的要在自己的博客或者空间写下答案，所有问题都要真实回答，并且要将这几个题目传给你的7个好朋友，通知对方，你被点名了
2. 这7个人要在博客或者空间上注明是在哪儿接受到的题目，并且要再将题目传给其他7个好朋友,让游戏继续下去，不得回贴。
3. 虽然不可以回帖，但是你的朋友还是可能会点到你，如果有第二次，甚至是第三次点到，那么说明你将会是一个非常幸运和幸福的人。
4. 答完题后，删除掉一个你想删除的问题，增加一个你想增加的问题，然后传给朋友。

1.从谁那里接到的题目？

老婆

2.2007年最难过的事

2007年还没过完呢

3.2007年最大的心愿是什么？

老婆找到工作

4.你会毫无保留的相信你的朋友么？为什么？

不, 朋友有时会恶作剧

5.要是失眠，你会做什么？

不睡了

6.哪种类型的异性让你最反感？你喜欢暧昧的感觉么？

不对胃口的.
老了，不会有这种感觉了

7.将来想要找个什么样的工作？

将来想创造工作

8.有没有什么是一直想要的？

还没有

9.你爱我多点还是喜欢自己多点？

当然是爱你啦

10.世界上什么东西你认为是钱买不到的？

智慧

11.你理想的伴侣应该具有什么样的品质？

不怕失败

12.如果可以重来，你最想改变的是什么？

早点买房，早点结婚，早点来澳洲

13.什么才算得上真正的朋友？

有某些共同点的

14.活到现在最烦恼的一件事是什么?

动作慢

15.最近最让你迷茫的事情是什么？

还没有

16.不开心的时候你会做什么？如果是自己关心的人不开心了呢？你会为她做些什么？

抽烟
陪在她身边

17.你的梦想是什么？
财务自由

18.最想去哪里？为什么？

巴黎
有文化底蕴和浪漫气息

19.最想收到什么生日礼物

不是太有所谓

20.如果和你的挚友同时爱上同一个人,只能择其一,你会如何选择?

没这种可能性

21.你的恋人有很多异性朋友会不断受到异性朋友的骚扰，你会有什么举措呢？

这样的人首先避而远之

22.说一件你曾经做过的最疯狂的事情~

骑自行车从并排开的两辆公交车中穿过

Export more than 255 characters into Excel by OLEDB

2007-07-16T23:32:00.000-07:00

I create a excel using ole db provider, like below

string connString = "Data Source=" + fullPath + "; Provider=Microsoft.Jet.OLEDB.4.0; Extended Properties=Excel 8.0;";

OleDbConnection myConn=new OleDbConnection(connString);
OleDbCommand myCommand=new OleDbCommand();
myCommand.CommandText = "CREATE TABLE Report (msisdn string, comment string )";

// connect an excel file, if this file doesn't exist, it will be created
myConn.Open();
// create a workbook in this file
myCommand.ExecuteNonQuery();

The problem is when import more than 255 characters into Excel, error occurs:

OLEDBException: The field is too small to accept the amount of data you attempted to add.....

This is because string in Excel has the limitation of 255 characters. To work around this, change the datatype to memo

myCommand.CommandText = "CREATE TABLE Report (msisdn string, comment memo)";

参观小鹰号航母

2007-07-08T05:19:00.000-07:00

7月5日,米国小鹰号航母到达悉尼.停港5日.这大好机会不能错过.周日虽然下午开始阴雨绵绵.但还是携妻先来到Opera House, 穿过植物园，足足在风里雨里走了3公里，终见此庞然大物。

从树下探出头来：

终见全貌：

指挥塔上天线高耸：

战机密布舰尾：

预警机火眼金睛：

原来这家伙编号是63：

此次到访不对公众开放。虽然看到"No Public Tour"的牌子，还不死心问了下米国大兵。那大兵指了指牌说Never。另一个大兵安慰下说：May be next time. 就把我们打发了.遗憾，无法上船看个究竟。

成渝地区或成下一个金矿

2007-06-12T04:36:00.000-07:00

昨日成渝地区上市公司平均涨幅达到5.70%

　　成渝经济区空间分布图 CFP图片 □本报记者徐海洋

　　成都和重庆将成为新的改革开放前沿阵地，这个位于西部的改革试验区被外界评点为力图打造中国经济发展的“第四增长极”。
正如此前上海浦东新区、天津滨海新区获批设立后带给相关公司和市场的变化，市场人士相信，成渝新特区也将成为又一个值得继续发掘的“金矿”，新的机遇孕育其中。

　　昨天的市场走势已经对这一政策面的变化作出明确反应。根据天相投顾编制的地区指数，昨日天相重庆指数和四川指数涨幅分别达到7.02%和3.38%，列地区指数涨幅的第二和第五位（涨幅最高的贵州指数市值较小，指示意义不高）。而统一成都和重庆两地62家上市公司编制的成渝指数（总股本加权）显示，昨日成渝地区上市公司平均涨幅达到5.70%，这一涨幅高于所有可比规模的地区指数，也高于所有的行业指数表现。

　　成渝特区个股正在悄然崛起。在昨日正常交易的54只个股中，仅7只出现下跌，其余全部上涨。上涨的44只个股有20只封死涨停，23只涨幅超过7%，渝三峡A、重庆港九、四川路桥、重庆路桥等均以涨停板收盘。可见，资金的确表现出了对成渝个股的投资欲望。

　　纵观川渝已经公布的城乡统筹规划，将有以下几方面内容：统筹城乡规划，统筹城乡产业发展；建立覆盖城乡的基础设施建设及其管理体制；建立城乡均等化的公共服务保障体制，建立覆盖城乡居民的社会保障体系；建立城乡统一的户籍制度，统筹国民收入分配等重点领域和关键环节率先突破，加快经济社会快速健康协调发展。

　　新特区建设的侧重点将是加快城乡一体化进程和新农村建设，而浦东和天津滨海新区的经验表明，一旦成为综合配套改革试验区，国家将在金融、土地、税收、财政等政策上给予试验区很多优惠，这些也恰好为上市公司带来了发展的空间。申银万国证券发布的报告认为，金融政策方面，试验区将拥有更大的金融制度改革的自主权，推动形成区域金融中心；土地方面，地方政府将拥有新的政策空间，特别是在实现区域整体规划、连片开发方面，将为地方政府提供更广阔的施展空间。中央财政支持和税收优惠等也值得预期。中央财政在一定时期内还可能对试验区予以专项补助。

　　此外，结合浦东和滨海两个新区的发展过程，申万认为成渝新区上市公司的投资机会也将分批次逐级展开。在新特区成立前夕，以工业和建筑业为代表的第二产业产值增速较快，而后期以服务业和房地产业为代表的第三产业增速快速上升。因此，投资品将是率先从新区发展中获益的行业。由于特区第一阶段建设将以基建为主，建筑、建材、钢铁、工程机械、电气设备、能源电力将直接受益，而四川路桥、中铁二局、四川双马、四川金顶、东方电机等属于此类公司。此后，随着生产活动的大规模开展，贸易、物流等服务业将逐步受益，对应行业为港口、高速、机场等，重庆港九和重庆路桥属于此类；城乡一体化程度的进一步提高，将使相关消费服务业面临巨大发展空间，房地产、零售、酒店餐饮、医药、家电、汽车等行业公司将直接受益，如渝开发、重庆百货、桐君阁、太极集团、长安汽车等。

　　不过有分析师提醒，成渝公司的投资价值在目前阶段大多仍是基于预期的提前炒作，新特区的发展过程究竟能够惠及哪些上市公司，还有很多的变数，投资者应深度发掘公司基本面，避免盲目跟风炒作的投资风险。（中证网）

转贴：关注51个个股

2007-06-08T17:36:00.000-07:00

□聚源数据研究所钟杰黄翔邓海

　　经过一轮大幅下挫，市场近日开始转暖。我们试图从近期市场交投情况来客观分析本次下跌，并探讨如何捕捉暴跌后的投资机会。

　　据聚源数据e财讯统计数据显示，5月以来截至5月29日，有统计数据的1353家公司，平均每交易日换手率为5.50%，因此可以说市场个股在不到20个交易日换手就可达100%，确实存在一定的交投过旺情况。
特别是5月23日至29日的5个交易日中，个股平均每日换手更是飙升到8%，连续过高的交投水平已经预示着市场风险的临近。

　　然而在5月30日到6月4日连续4个交易日中个股平均每日换手为6.84%，尽管相比之前5个交易日的8%有所减少，但相比之前整个5月以来 5.50%的平均水平依然明显高出，显示出市场在暴跌中依然有相当的资金选择了买入，同时在暴跌的背景下还能有如此水平的换手，从资金来源的角度来讲也很有可能为机构行为，因为在暴跌中，散户资金往往采取的多是杀跌策略。

　　从6月5日大盘触底反弹来看，5月30日到6月5日计算得到的个股平均每日换手率为6.81%，相比之前暴跌中的4天略微下降了0.03%，然而就是这细微的差别却反映出市场在6月5日当天股价跌至底部时依然保持相当的交投，抄底资金进入明显，而与之前几日相比总量却有所减少，则表明市场杀跌动能已经在前几日的暴跌与相当水平的换手中得到充分释放。

　　面对后续行情的演绎，可从价格与换手两方面入手分析。e财讯统计数据显示，从5月30日暴跌开始到6月5日开始反弹，两市共有1319家上市公司期间股价下跌，其中跌幅达到30%的就有441家，甚至有5家公司跌幅超过40%，因此，在认识到市场并非想象中的那么坏以后，从这些暴跌的公司中寻找被错杀的个股，以及在暴跌中股价依然稳定的个股，败中求胜，可成为近期决策的一种思考策略。

　　为此我们统计出两组公司。一组满足以下条件：5月30日至6月5日期间跌幅超过30%，平均每日换手率相比暴跌前5个交易比值在80%到 120%区间，2007年一季度盈利，截至6月5日收盘市盈率在45倍以下，共计筛选出16家上市公司。另一组公司5月30日至6月5日期间依然实现股价上涨或跌幅在10%以内，且截至6月5日收盘市盈率在45倍以下，筛选出35家上市公司。两组共计51家公司给大家重点参考。

　　从这51家公司情况来看，首先行业分布非常明显，特别是有矿产资源背景的采掘与金属非金属行业，在51家公司中占据17席，整整1/3的数量说明在大跌中这些有资源背景的公司或抗跌、或有可能强劲反弹因此值得关注；其次是纺织服装与港口航运、电器与环保机械制造以及金融行业上市公司占据数量较多，其中蓝筹绩优股比较集中，显示出在后续行情中市场热点将有可能转换。

　　其次这51家公司，5月30日至6月5日平均每交易日换手达7.02%,远高于暴跌前5个交易日平均每日换手5.98%的水平，显示出在大跌的市场环境下资金流入的迹象，同时这5.98%的换手相比同期整个市场平均8%的换手又显示这些公司在大跌前行情的稳定，并非市场热炒公司，因此我们认为，在大跌中和大跌后随着市场行情的稳定和热点的转换，这些业绩优良，估值水平合理的公司有望获得资金青睐，带领市场完成新的热点转换。

　　大跌后值得关注的51只股票情况一览

　　证券代码证券简称 5月30日至6月5日换手率 5月23日至5月29日换手率涨跌幅涨跌幅( 每股收益(07Q1)(元) 市盈率(2007 所属行业

　　(%) (%) (2007-5-30, 2007-5-23, -06-05)

　　2007-6-5)(%) 2007-5-29)(%) (倍)

　　600348 国阳新能 29.27 21.30 -6.79 10.52 0.3074 23.07 采掘业

　　601600 中国铝业 62.54 41.80 1.76 8.41 - 24.33 采掘业

　　600028 中国石化 50.27 19.14 10.86 4.73 0.224 24.8 采掘业

　　600497 驰宏锌锗 34.04 33.81 -5.89 9.34 1.5355 25.21 采掘业

　　601699 潞安环能 16.92 10.84 -9.21 1.31 0.3702 26.84 采掘业

　　600395 盘江股份 47.43 50.57 -31.14 7.99 0.0476 37.87 采掘业

　　600330 天通股份 32.01 38.98 -30.05 6.83 0.0648 41.1 电子

　　600493 凤竹纺织 45.35 48.89 -36.49 10.78 0.0201 24.82 纺织、服装、皮毛

　　002034 美欣达 32.10 29.19 -30.45 2.91 0.022 33.04 纺织、服装、皮毛

　　600987 航民股份 40.34 41.33 -30.86 -0.61 0.0756 39.19 纺织、服装、皮毛

　　002015 霞客环保 41.85 40.53 -31.15 2.82 0.0703 41.75 纺织、服装、皮毛

　　600320 振华港机 29.00 25.74 -9.26 4.24 0.1468 33.92 机械、设备、仪表

　　000651 格力电器 12.43 8.73 -3.72 5.31 0.2037 37.18 机械、设备、仪表

　　002028 思源电气 7.94 4.87 -3.61 10.35 0.1677 41.43 机械、设备、仪表

　　000541 佛山照明 57.36 34.11 5.56 13.52 0.3458 42.41 机械、设备、仪表

　　600502 安徽水利 50.65 52.45 -34.62 5.02 0.0659 43.16 建筑业

　　000088 盐田港 33.56 37.25 -9.04 6.76 0.1178 31.37 交通运输、仓储业

　　600317 营口港 49.65 43.43 -9.37 1.81 0.1466 34.15 交通运输、仓储业

　　601006 大秦铁路 32.81 23.78 -6.16 4.47 0.1222 42.99 交通运输、仓储业

　　000905 厦门港务 42.51 50.20 -31.5 0.95 0.0485 27.45 交通运输、仓储业

　　600016 民生银行 22.08 16.30 -8.58 3.02 0.1087 33.09 金融、保险业

　　601398 工商银行 31.27 25.71 -9.12 2.01 0.056 34.39 金融、保险业

　　601166 兴业银行 21.60 15.43 -6.95 3.78 0.2817 37.35 金融、保险业

　　600000 浦发银行 7.63 7.15 10.33 7.88 0.2246 42.59 金融、保险业

　　000001 S深发展A 10.01 10.84 -0.24 3.27 0.275 42.85 金融、保险业

　　600036 招商银行 16.10 10.05 0.42 3.58 0.1674 44.46 金融、保险业

　　证券代码证券简称 5月30日至6月5日换手率 5月23日至5月29日换手率涨跌幅涨跌幅( 每股收益(07Q1)(元) 市盈率(2007 所属行业

　　(%) (%) (2007-5-30, 2007-5-23, -06-05)

　　2007-6-5)(%) 2007-5-29)(%) (倍)

　　600362 江西铜业 57.53 52.96 -8.62 7.19 0.2888 15.65 金属、非金属

　　000060 中金岭南 37.34 29.10 -9.19 7.26 0.4154 19.12 金属、非金属

　　002110 三钢闽光 93.30 47.36 -8.46 1.98 0.1876 21.22 金属、非金属

　　000630 铜都铜业 64.98 48.72 -9.2 16.62 0.1951 25.99 金属、非金属

　　000039 中集集团 27.80 19.05 -6.73 18.71 0.2609 26.51 金属、非金属

　　000825 太钢不锈 27.50 21.45 -9.08 13.92 0.4605 29.72 金属、非金属

　　000878 云南铜业 56.17 38.63 10.59 10.65 0.2073 32.01 金属、非金属

　　600660 福耀玻璃 6.04 6.59 -8.18 8 0.1599 39.04 金属、非金属

　　000612 焦作万方 35.03 25.52 -2.86 11.69 0.353 42.02 金属、非金属

　　600992 贵绳股份 47.49 55.53 -30.93 5.13 0.0596 30.33 金属、非金属

　　600172 黄河旋风 41.87 44.26 -30.39 2.54 0.0499 35.98 金属、非金属

　　600840 新湖创业 27.98 0.08 7.87 33.06 0.0361 35.1 批发和零售贸易

　　600058 五矿发展 39.36 28.29 -8.63 14.4 0.1997 38.46 批发和零售贸易

　　600826 兰生股份 40.17 41.53 -32.57 12.03 0.0139 31.72 批发和零售贸易

　　600056 中技贸易 38.81 47.92 -30.64 6.12 0.0673 33.84 批发和零售贸易

　　000421 南京中北 42.53 47.74 -33.07 2.16 0.0253 26.88 社会服务业

　　002109 兴化股份 51.07 32.10 -9.23 3.59 0.1274 29.76 石油、化学、塑胶、塑料

　　600331 宏达股份 30.95 19.30 2.24 9.53 0.3757 30.07 石油、化学、塑胶、塑料

　　600426 华鲁恒升 27.65 33.32 -5.87 14.51 0.1936 31.37 石油、化学、塑胶、塑料

　　600596 新安股份 9.49 10.35 -5.87 14.74 0.2762 35.21 石油、化学、塑胶、塑料

　　000792 盐湖钾肥 9.90 5.94 -4.15 4.82 0.2367 37.8 石油、化学、塑胶、塑料

　　600226 升华拜克 36.82 42.67 -32.94 9.07 0.0464 32.2 石油、化学、塑胶、塑料

　　000589 黔轮胎Ａ 43.77 41.73 -32.19 10.32 0.076 36.92 石油、化学、塑胶、塑料

　　600356 恒丰纸业 33.07 32.15 -32.01 6.56 0.0387 34.83 造纸、印刷

　　600415 小商品城 7.01 9.64 -6.66 7.71 0.5607 36.99 综合类

转贴：多头反击八千亿资金流向曝光

2007-06-08T17:31:00.000-07:00

　　沪深大盘在一轮急跌之后终于迎来反弹，三天来沪深总成交金额始终保持在2700亿元以上，合计多头资金8000多亿元流向股市，来自广州万隆成长投资顾问群的统计数据显示化工、有色金属、建筑农机重卡、煤炭消费燃料、新能源、电子设备制造、西药、食品（不含酒类）等八大板块受到新增资金的青睐，三天来成交量与日俱增，而房地产、钢铁、有色金属、化工银行、电力等六大板块三天来绝对成交量居前。　反弹行情演绎至昨日，盘面显示，新增资金在超跌的参股券商概念股及房地产、西药、电力、化工等蓝筹股上加速进场，个别基金或机构重仓股已创出历史新高，市场人士研判券商概念股、新能源、房地产、有色金属、煤炭等构成短期热点。

　　钢铁：该板块三日成交494亿，资金流入较大的个股有：宝钢股份、马钢股份、新兴铸管、太钢不锈、邯郸钢铁等。

　　房地产：该板块三日成交628亿，持续为成交量排名第一。昨日相比上一日有小幅缩量，幅度达-8%。资金流入较大的个股有：万科、金融街、中粮地产、陆家嘴、广宇发展、苏州高新、新湖创业、物华股份。

　　有色金属：该板块三日成交412亿，昨日排名第三，三天来持续小幅放量。资金流入较大的个股有：中孚实业、金瑞科技、宝钛股份、云南铜业、山东黄金等。

　　参股券商：该板块三日成交753.2亿，该板块三天来每天成交量高达250亿元上下，为概念类板块的成交量之最。昨日资金流入较大的个股有：安信信托、中信证券、亚泰集团、辽宁成大、吉林敖东。

　　煤炭：该板块三日成交165亿，昨日成交与上一日相比小幅放量，幅度达9.5%。资金流入较大的个股：国阳新能、大同煤业、山西焦化、金牛能源等。

　　新能源：该板块三日成交160亿，昨日成交与上一日相比大幅放量，幅度达25%。昨日资金流入较大的个股：江苏阳光、航天机电、湘电股份。前两天放量个股有银星能源、轻工机械。

　　建筑农机重卡：该板块三日成交205亿，昨日成交与上一日相比小幅放量，幅度为5%。昨日资金流入较大的个股：三一重工、中联重科、香江控股、徐工科技。

　　近期市场出现回暖态势，从热点的转移上看，市场正在进行一个结构性的变化，这个过程可能需要一定的时间。在股市长线看好的观点得到市场普遍认同和流动性仍然过剩的背景下，优质股票出现超跌实际上为投资者提供了很好的买入机会。广州万隆坚持认为，无论从市场博弈还是从资金配置角度来看，以权重蓝筹品种为代表的市场核心资产将成为驱动后市行情健康发展的强大驱动力。(上海证券报)

继续关注走势

2007-06-07T05:54:00.000-07:00

大盘，沪指继续上行，在3900-4000点之间有大量抛盘，深指比沪指略强。上行中两市成交量略微减小。

石化板块：
600028，尾市被强行拉升，后市看跌

银行板块：
600038（招行），连续两个十字星，成交量略有放大，关注
601398（工行），头肩底已基本确认，目前正在反抽，远离
601988（中行），将继续下行，远离
600000（浦发），可能会继续上行
601998（中信)，可能会继续上行

电信：
中国联通：上升三角形变成反转形态

ST板块：
ST TCL: 回调刚开始，利空出尽，可购入

其他：
申华控股：涨停力量不足，会调整，可小心买入
荣华实业：回复刚开始，可买入
中海海盛：有个双底，双底底部可能无法突破
歌华有线：上升动力减小，持有

不在反抽中出手

2007-06-05T04:34:00.000-07:00

今天大盘反抽，机会不好把握，继续观望。
沪指技术形态也不明朗，ms头肩顶左肩，3449是强支撑。深成指未跌破趋势线

石化板块
600028对称三角形目标价位已经达到，但未跌破趋势线，观望。

银行板块
600036（招商），ms出现双顶，20元是阻力位
601398（工行），出现头肩顶形态（近期），长期来看是个运动到顶点的对称三角形，现都已破位，远离
601988（中行），上升三角形走坏，变成头肩顶
600000(浦发），下降三角形被向上突破，显已到目标位，观望
601998（中信），已经跌到发行价，关注

其他

000825（太钢不秀）运行到对称三角形顶点，即使上涨也无力，观望.
600037(歌华有线）上升三角形目标价位未达到，有上攻潜力

新基金提速发行后可跟进买股吗

2007-06-04T19:31:00.000-07:00

6月5日，新基金发行提速，貌似一个积极信号，但也不能就此认为大盘能够恢复趋势。原因是：

1。这些新基金ms是来接盘的
2。新基金拿的实际上也是老百姓的钱，如果托不住问题也不大。

还是继续关注大势。