VISUAL STUDIO PRODUCT KEYS

13:12 Sumit Shekhawat 2 Comments


Microsoft Visual Studio 2010 Ultimate Product Key
YCFHQ9DWCYDKV88T2TMHG7BHP

Visual Studio 2010 Professional
YCFHQ-9DWCY-DKV88-T2TMH-G7BHP OR YCFHQ 9DWCY DKV88 T2TMH G7BHP

Visual Studio 2012 Ultimate
RBCXF-CVBGR-382MK-DFHJ4-C69G8
Visual Studio 2012 professional
4D974-9QX42-9Y43G-YJ7JG-JDYBP
 RBCXF-CVBGR-382MK-DFHJ4-C69G8
YKCW6-BPFPF-BT8C9-7DCTH-QXGWC   

Visual Studio 2013 Ultimate
BWG7X-J98B3-W34RT-33B3R-JVYW9


=========================================

Visual Studio 2019 Enterprise
BF8Y8-GN2QH-T84XB-QVY3B-RC4DF
Visual Studio 2019 Professional
NYWVH-HT4XC-R2WYW-9Y3CM-X4V3Y

(Thanks: https://gist.github.com/ahtazaz/cec94a5cb97593ce49e5a3d613f90441)

=========================================


2 comments:

how to Replace null value with 0 Using C#

08:45 Sumit Shekhawat 1 Comments

how to Replace null value with 0 Using C#



//here we suppose that objDataTable have data collection as table now access this //datatable object.

decimal j = 0;

 j = objDataTable.Rows[0]["Qty"] == DBNull.Value ? 0 : Convert.ToDecimal(objDataTable.Rows[0]["Qty"]);




NOTE :-
//if  DBNull.value is null then  "0 " else  "your code here") 
// ? = then
// : = else




Thank You
[Sumit Singh Shekhawat]

1 comments:

how to Replace null value with 0 in sql server 2008

08:31 Sumit Shekhawat 0 Comments


Replace null value with 0 in sql server 2008


Summary : how to a null value convert into 0.


solution : ISNULL ( check_expression , replacement_value )

declare @a float;
set @a  = ISNULL((select SUM(CONVERT(FLOAT,quentity)) as qty  from Cutting 
                   WHERE jobno = '1' and contractorname = 'submit'),0)


-- here when quentity is null then it is return "0" else your calculate value;


Thank You

[Sumit Singh Shekhawat]

0 comments: