Geeks With Blogs
Deeksha Sharma March 2014 Entries
Pivot table Example
CREATE TABLE test1 ( [month] varchar(15) , val1 int ) INSERT INTO test1 VALUES ('Jan', 70) , ('Feb', 12) , ('Mar', 12) , ('Apr', 14) ; SELECT * FROM (SELECT [month], val1 FROM test1) AS original PIVOT ( MIN(val1) FOR [month] IN ([Jan], [Feb], [Mar], [Apr]) ) AS PivotTablePivot table is used for making the data of one column as a heading of the table . and second column data as a value of that column respectively as given in the example ......

Posted On Friday, March 28, 2014 9:05 AM

WCF tutorial series-1
Windows Communication Foundation (Code named Indigo) is a programming platform and runtime system for building, configuring and deploying network-distributed servicesAdvantageWCF is interoperable with other services when compared to .Net Remoting,where the client and service have to be .Net.WCF services provide better reliability and security in compared to ASMX web services.In WCF, there is no need to make much change in code for implementing the security model and changing the binding. Small changes ......

Posted On Thursday, March 27, 2014 12:14 PM

Partial keyword in c#
It is possible to split the definition of a class or a struct, an interface or a method over two or more source files. Each source file contains a section of the type or method definition, and all parts are combined when the application is compiled.Partial can be a type and method as well.To split the definition of a class we can use partial.public partial class Employee { public void DoWork() { } } public partial class Employee { public void GoToLunch() { } }The partial keyword indicates that other ......

Posted On Thursday, March 27, 2014 1:27 AM

c# hello world

Posted On Thursday, March 27, 2014 1:07 AM

How to find the structure of JSON data
if you have your json data in  a object jsonData. then you can use the following code to see the JSON data structure.

 alert(JSON.stringify(jsonData, null, "\t"));

Posted On Tuesday, March 25, 2014 11:34 AM

new modifier in c#
New modifier applies to the concept of Hiding.Key Notes:-Use the new modifier to explicitly hide a member inherited from a base class. To hide an inherited member ,declare it in the derived class using the same name and modify it with the same modifier.An Indexer introduced in a class or struct hides all base class indexers that have the same signature.It is an error to use both new and override on the same member,because the two modifier have mutually exclusive meaning(both can not be set true at ......

Posted On Saturday, March 15, 2014 3:22 AM

Concept of new Operator
1) The new operator is used to create objects and invoke constructors. class obj=new class();2) It is also used to create instances of anonymous types.var query=from cust in customers select new{ Name=cust.Name,Address=cust... The new operator is used to invoke the default constructor for value i = new int();4) Every value type implicitly has a public default constructor .So, there is always an error to declare a default constructor for a struct.5) The new operator can not ......

Posted On Saturday, March 15, 2014 3:12 AM

Copyright © Deeksha Sharma | Powered by: