Let's Talk about .. Visual Stuido 2005-Currency format in Grid view

Since I use a grid view to show my data, it shows the numeric data without comma and currency symbols. Thus, I searched the method and found that this website provides the solution to me http://forums.msdn.microsoft.com/ja-JP/vbgeneral/thread/88d1abd8-9a37-4f55-ac4d-52a82e14c46f/

The solution is adding HtmlEncode="False" and DataFormatString="{0:c} in to the code.

For example,

Let's Talk about .. SAP SummIT 08

Today I was assigned from my Team Executive to participate the SAP User Group Forum 08 or SAP SummIT 08 at Queen Sirikit National Convention Centre, Bangkok. The concept is Business Beyond Boundaries.



Blueprint to a Billion Company

One program that I think it's very interesting is 7 Essentials of Blueprint to a Billion Company by Mr.David G. Thomson who wrote Blueprint to a Billion.





I summarized from what he said.. The Blueprint company is a company that makes revenue over a billion dollars. Well, and the seven essentials are...

1. Create & Sustain a breakthrough Value Preposition
   For example, Starbuck, it's benefit = Product + Location + Experience


2. Lessons from Top CEOs
   - Grow in mature, not emerging market
   For example, Starbuck, Nike, etc.
   - Stay close to customers
   - with Suppliers


3. Marquee Customer
   Marquee Customers = Product Customer x Value Proposition Shaper x Lighthouse reference


4. Leverage Big Brother Alliance
   For example, (I'm not sure if I remember correctly) Yahoo! and AT&T


5. Become Master of Exponential Returns


6. Management Inside and Outside Leadership


7. Board: Comprised of Essential Experts

Most Blueprint companies have 5 or more essentials. However, only the essentials are not enough, the company has to invest in the infrastructure, too.

Bridging the gap between HR Requirements and Technology

I also joined the Breakout Session of Bridging the gap between HR Requirements and Technology by Mr. Michael Custers, Vice-President of NorthgateArinso Co.,Ltd.

He said that today global challenge consists of..

• Demographics
• Talent Management
• Continuous Change
• HR/Business Allignment

Therefore, what we should do are the HR Transformation Study and HR Roadmap.

• As Is: Collecting Data Model
• To Be: Service Delivery Model
• Enhanced user: Experience Through Tierred Service
  For example, Tier 0 is the website

Let's Talk about .. SQL Server 2005-Count the number of items from many sets of select

P'Beer told me yesterday about how to find out the number of all items (from many selects). This is the solution.

[SQL]
select count(*)
from(select .......)
UNION(select .......) Table_Name

Note: you've to specify the Name (Table_Name) after the last select.

Let's Talk about .. SQL Server 2005-Manage Transaction

When your stored procedure is running, what happen if something accidentally occurs? Your update procedure may just copy only some fields of some records.. then stop. Thus, we should manage the transaction for every neccessary stored procedure such as Add, Update, Delete, etc.

This is the example of managing transaction that I found from http://www.4guysfromrolla.com/webtech/080305-1.shtml

[SQL]
BEGIN TRANSACTION

[your process]

IF @@ERROR <> 0
BEGIN
ROLLBACK
RETURN
END
COMMIT

Let's Talk about .. Visual Stuido 2005-Features

Today, P'Beer, the outsource at my office teached me about what the important features of Visual Studio 2005 over Visual Studio 2003. He said that there are three vital features:

1. AJAX (Asynchnous JavaScript and XML), while Visual Studio 2003 retrieve the data via the XMLHttpRequest object.
2. Master Page/Detail Concept.
3. Theme/Skin which is also included CSS.

Let's Talk about .. SQL Server 2005-Convert AD to BD

I found the way to convert the AD to BD in the SQL query from http://www.narisa.com/forums/index.php?act=Print&client=printer&f=22&t=21017
[SQL]

convert(varchar(4), year(AD_Date) + 543)
+ '-' +
convert(varchar(2),month(AD_Date))
+ '-' +
convert(varchar(2), day(AD_Date))
as BD_Date,

Let's Talk about .. Visual Stuido 2005-Function Get DataTable or variable from SQL2005 Stored Procedure

[VB.Net]
Public Shared Function GetDataTableByValueAAndValueB(ByVal ValueA As String, ByVal ValueB As String) As DataTable
Dim ds As New DataSet
Dim SqlParam As SqlParameter() = Nothing
addParameter(SqlParam, "@ValueA ", ValueA)
addParameter(SqlParam, "@ValueB", ValueB)
Helper.SqlHelper.FillDataset(ConnectionString _
, CommandType.StoredProcedure _
, "spPBG_Trn_TrackingList_GetDataTableByValueAAndValueB" _
, ds _
, dtName _
, SqlParam)
Return ds.Tables(dtName(0))
End Function


[VB.Net]
Public Shared Function GetResultByValueAAndValueBAndValueC(ByVal ValueA As String, ByVal ValueB As String, ByVal ValueC As String) As Integer
Dim SqlParam As SqlParameter() = Nothing
addParameter(SqlParam, "@ValueA", ValueA)
addParameter(SqlParam, "@ValueB", ValueB)
addParameter(SqlParam, "@ValueC",ValueC )

Dim dr As SqlDataReader = Helper.SqlHelper.ExecuteReader(ConnectionString, CommandType.StoredProcedure, "GetResultByValueAAndValueBAndValueC", SqlParam)
If dr.Read() Then
Result = (Helper.ConvertHelper.NullToNothing(dr("Result")))
End If

Return Result
End Function