Some date format mostly using for UTC time zone, VB.NET and C#.

yyyy-MM-ddTHH:mm:ss.000
yyyy-MM-ddTHH:mm:ssZ

Date.ToString("yyyy-MM-ddTHH:mm:ssZ")
Format(Date., "yyyy-MM-ddTHH:mm:ss.000")

Handle special character in oracle while inserting and updating.

Most of the time we are facing problem while inserting or updating special character in oracle database.

when executing the scripts it gives/ask to insert values for those fields which followed by special signature like "&"

How to insert special character in database ??

How to use ||chr(38) || in oracle ??

 

Solution is :-

In the query just replace "&" with ||chr(38) || and this will work

How to resolve file uploading issue in asp.net and 404 file not found when upoloading file.

For uploading large size through asp.net below tag need to be added in web.config file.

Under "system.web"

"httpRuntime maxRequestLength="1048576" "

After adding this tag you may get below error.

404 file not found or moved from this location,Page not found

Add below tag in web.config under  "system.webServer"

 "security / requestFiltering  "requestLimits maxAllowedContentLength="104857600""
/requestFiltering/security

How to check coloum type, coloum default value and coloum length in oracle.

Below query will give this result.
 
SELECT atc.TABLE_NAME, atc.OWNER, atc.DEFAULT_LENGTH, atc.DATA_DEFAULT,
       atc.COLUMN_NAME,
       atc.DATA_TYPE
FROM  ALL_TAB_COLUMNS atc where lower (atc.COLUMN_NAME)='XXXX' and atc.TABLE_NAME ='XXXXXXXXXXx'

Microsoft Certified Professional Developer - Web Developer 4

Microsoft Certified Professional.

Finally, I got the badge of a Microsoft Certified Professional :)

Microsoft Certified Technology Specialist NET Framework 4 Service communication application

Finally, I have completed this exam :)\

I got in-depth learning and details for the below modules.

1. A solid understanding of WCF in the context of the .NET Framework 4 solution stack
2. Experience creating service model elements
3. Experience using WCF to support open and .NET communication
4. Experience configuring and deploying WCF applications
5. Experience using Visual Studio tools, tracing tools, SvcUtil, WCF performance monitoring, and IIS/WAS for hosting services
6. Experience securing WCF applications
7. A solid understanding of concurrency