Skip to main content

Posts

FAQS

hi  TECHKEYS............                                   So far we received many request for FAQs on CSHARP, ASP.NET AND SQLSERVER for fresher who are in finishing schools. We are actively working with these Technologies  to bring   KEY  Resources for   TECHIES.                                   you are interested in helping others  bring TECHKEYS  to your Friends through Social Media, please Leave the Comment to us to improve our work and subscribe  for more information.   Q 1) levels of nesting in a subquery?      a)2        b)6         c)32        d)64 ------------------------------------------------------------------------------------------------------------ Q 2) static method correct syntax:      a.private static main()                            b.public static main()      c.public static int main()                          d.public static void main() ----------------------------------------------------------------------------------------------

Iterator in csharp

Iterator What is iterator? Iterator is a method or function implementation which implements the iterative features for objects and its return type must be IEnumerable type. We can implement iterators in C# read-only property also (only with get ) In each iteration this method or properties returns one element with the help of Yield return statement What is yield Yield is a keyword which is introduced in Csharp and VB.Net to implement iterator .yield is working like return statement in functions but it will call more than one time like loop. yield gives enumeration properties implicitly for object(i.e means explicitly no need to implement IEnumerator) . Yield was implemented in C-sharp and vb.net with different keyword Yield return <expression>; in C# We used yield return statement in iterator to return each element Example static void Main( string [] args)          {             foreach ( var item in getno())         

Start menu in windows 8

Start menu in windows 8   Now a days we are using windows 8 it is good and   great but when you migrate from windows XP and windows 7 you miss the windows start button In windows 8 and windows 8.1 everything we have to do with apps menu is   easy but as windows XP user it is very difficult to overcome this we can depend on 3 rd (which is not developed by Microsoft) party tool that is available here Check and enjoy with simple steps It is free and no extra activities are required enjoy  

OOPS-Constructors and distractor

Hi friends today we will discussed about constructors and distractor in csharp Constructors are used to memory allocation for real world entities which are created with the help of objects. When program or application is running, application required memory to save and manipulate data of that real world object/entities. Now the question is how much memory is required for that object? Frankly no one can decide how much memory is required for that application because of that all object oriented programming languages depends on heap memory. Heap memory is a logical memory in RAM (temporary memory) and size is logically infinity (physically it is limited).This memory has to be creating at run time when we are using object in our program/application. Now we have to know that what type of data members we have in object. In object we have two types of data members’ object instance  shared instance Object instance are allocated occupies object memory and eve

SQLSERVER Functions- Coalesce()

SQL  Server  built-in functions Coalesce() It is A function Is Very Much Useful at Run time When We Have Multi Value Attribute in a Table. If U Consider below facts placed in a employee table With Id, Name, ph_no, Alt_no, Office no. id Name Ph_ no Alt_ no Office no 101 Albert 999999 456453 321333 102 khan null null 123455 103 victor 112121 null null 104 lovely null null 1897321 Above Employee table may have single value are three values if it have single value then it fill null  values with remaining attributes When We Retrieve The Number from employee table That Number Should Not be Null value To get not null value from employee table We Use Coalesce() Function It Returns First Encountered Not Null Value  from employee table select id , name , coalesce ( Ph_no , Alt_no , Office_no ) as contact number from employee

Csharp Events basics

Events in C# Syntax of event declaration [attributes][modifers] event <delegate_type> <event_name>[ {event body}   ]; we will discuses about syntax of event ·         Attribute s are csharp attributes ·         Modifiers are optional and those may one are combination of more than one o    Accessing specifies §   Public, private, protected, internal §   New, Virtual, Abstract, override §   Static ,extern o    Event will work between objects because of that when your are defining event in main function existing class you have to specifies event as static              ·         Event o    It is a keyword used to give event declaration o    In syntax event keyword must not be omitted ·         Type o    Event is a role player  variable foe delegate o    Without delegate event will not fired o    Type is a delegate type which is giving functions to event at run time when event is fired this process is known as hookup ·