Shubhank Upadhyay

 Hi All, Its been almost 10 years I haven't posted  anything  on my blog , As lot of changes happened during this tenure :) in my personal and professional life. Here I will talk only about my professional career and learning events related with it  :) Of course  I would share knowledge and cascade information what I have and  learnt concepts in my past 10 years with all of you So be Ready for my new posts !  Next Post on my Blog -  Cloud and How I cleared AZ-900 Microsoft Azure Fundamental exam and Why I choose fundamental  Regards Shubhank 'Google will tell  u SYNTAX ! 'But I will tell u  CONCEPTS '

Hi, Last few Days, I learnt a very basic and important thing about  that ,When one should go for ArrayList or Generic.List in coding......On basis of that, I found  few difference between both. ArrayList Its comes under System.Collections namespace. Its contains Array of Object.i.e Any objects type we can store in a ArrayList.We can store any no. of objects at runtime. ArrayList aryList= new ArrayList(); // No Need to specify the object type,can store anything arList.Add(1); arList.Add("Shubhank"); arList.Add("False"); We can store any objects in ArrayList and can retrieve only Objects from ArrayList... We can say that ArrayList is not Type-Safe .At the Time of inserting recods ,we can store any type of objects,but at the time of fetching we can't be sure that  Values  which are populate by arList (ArrayList object ) of what type..however.. we have to following code while fetching records/items from Array list foreach(Object o in arList) { ....

Hello All, I learnt new thing ,how to debug in Web Services, earlier i have used log (txt) to see where my services failed,but now I got new way.Hence I would like share this with all of you.... :) steps - 1) Create a new TestWebservice (File->New Project->ASP.Net Web Service Application) steps - 2) Create a public new method with [webmethod] attribute say " int return type Calculations method accepting two inputs and a calculations class (note set breakpoint in calculation method ) Services.asmx.cs Calculations.cs steps -4) Now run the web services and you will see URL in browser like  http://localhost:49623/Service1.asmx steps -5) Now create a new TestClientWebapplications a new website (File->New Project->WebSite) have a button (btncallWebserices) ,Text=CallWebService and on it click event call the web services ( before that u need to Add a Web References add url above). steps -6) Set breakpoint on btnclick event method run application and then cl

SQL Interview Questions Q. Display names of all salesperson whose customers are john? Q. Display names of all salesperson whose customers are not john? Q. Insert   those records into a table highvale(name,age) from saleperson whose salary is 2000 or greater than ? Q.   Display name of customer who have 2 or more order ? Q. Display name of saleperson who have maximum amt in orders ? Q. Display name of saleperson,total of amt   who have maximum amt in orders ? Q.   Display 3 rd highest salary of salesperson (Assume there are 1000 records in salesperson table). Q. Difference between Delete and Truncate ? Q.   Select substr(‘shubh’,2) from dual ? Is this Query will run ? yes /No .If not then what will be correct Query ? Q.   Select Round(2.75,2) from dual, Select   trunc(2.75,2) from dual ? what will be output ? Q. Difference between CAST and Convert ? (note : both function may be or may be not in your database.So try it

Hello Friends ! Greetings I will show an puzzle which display different output in VB.Net and C#.Think on it. class Program { public static void main() { byte a = 100; byte b = 200; byte c= a + b; Console.Writeline(c); Console.ReadLine(); } } Now what output it will display when compile this application it gives you compile Time Error like that Cannot implicitly convert type 'int' to 'byte'. An explicit conversion exists (are you missing a cast?) BUT BUT When u do the same code in VB.Net then it gives you RunTime Error."Arithmetic operation resulted in an overflow." And Interesting thing is that when you change value of a from 100 to 1 and b from 200 to 2.It will run successfully and display 3....in VB.Net. So Conclusion of Above Puzzle is that Type Casting Aspect is strongly used and recommend in C#.Developers need to take care of it Whereas in VB.Net (Considering Option strict off), it will do internally Type Casting. Suggest Me if you find any ot

Hello friends Greetings ! I will share an interesting Query that Delete records from table which doesn't have any Key (primary Key,Unique Key ). Step 1 : Create a table named as empName run the following query CREATE TABLE [dbo].[emp]( [empId] [int] , [empName] [nvarchar](max) NULL ) Step 2 : Insert records into the table empName INSERT INTO [emp] VALUES (1,'Shubhank') INSERT INTO [emp] VALUES (2,'Viru') INSERT INTO [emp] VALUES (3,'Shubhank') INSERT INTO [emp] VALUES (4,'Maths') INSERT INTO [emp] VALUES (5,'Shubhank') INSERT INTO [emp] VALUES (6,'Shubhank') INSERT INTO [emp] VALUES (7,'Denis') INSERT INTO [emp] VALUES (8,'Gates') INSERT INTO [emp] VALUES (9,'Linux') INSERT INTO [emp] VALUES (10,'Shubhank') INSERT INTO [emp] VALUES (11,'Gary') INSERT INTO [emp] VALUES (12,'Rajkishan') INSERT INTO [emp] VALUES (13,'Shubhank') INSERT INTO [emp] VALUES (14,'Rajiv') INSERT