Monday, August 10, 2009

Exe in Local Computer

i also find different exe here
C:\Program Files\Microsoft SDKs\Windows\v6.0A\bin
1.ildasm.exe
2.SqlMetal.exe
3.wsdl.exe
etc...

Friday, July 3, 2009

Ajax Nested Update Panel

Parent UpdatePanel Last refresh <%=DateTime.Now.ToString() %>
Nested UpdatePanel Last refresh <%=DateTime.Now.ToString() %>

Friday, June 26, 2009

Close() Vs Dispose Method

Difference between Close() and Dispose() Method

The basic difference between Close() and Dispose() is, when a Close() method is called, any managed resource can be temporarily closed and can be opened once again. It means that, with the same object the resource can be reopened or used. Where as Dispose() method permanently removes any resource ((un)managed) from memory for cleanup and the resource no longer exists for any further processing.

Byte Count .Net

string strInputData="録";
Encoding japEnc = Encoding.GetEncoding("Shift_JIS");
int nByteCount = japEnc.GetByteCount(strInputData);
OutPut :
here Byte Count is 2.

SUBSTRING() in SQL Server

SELECT 'gangadhar',SUBSTRING('gangadhar', 1, 1)

this query returns the name in one column with only the first initial in the second column.

Output is:
gangadhar g

STUFF in Sql Server 2005

SELECT STUFF('gangadhar', 2, 3, '12345')
The following example returns a character string created by deleting three characters from the first string, gangadhar, starting at position 2, at a, and inserting the second string at the deletion point.
Output :
g12345adhar