Thursday 28 March 2013

CTE(Common Table Expression)

CTE(Common Table Expressions) : 
                                                            CTEs are used to make the query more readable. CTE is a named  temporary result set that can be referenced within a select, insert,update,delete statement.
 CTE starts with the with clause.  CTE is defined by placing with clause before the insert,update, delete statement.
Here is the Syntax:

<expression name>  is the CTE  name which can be any valid identifier. It can be same as that of the base object name, but should be different from the other CTE name within same with clause.
The number of <column name> should be equal to the number of columns in the result set of  the <cte-defination-query>. If the column names in  <cte-defination-query> are identical then <column names> can be omitted.
 SQL SERVER supports two types of CTE
1.NON-RECURSIVE

2.RECURSIVE

1. NON-RECURSIVE:-  
A nonrecursive CTE is one that does not reference to itself within the CTE. These are simpler than recursive CTEs

e.g.

is a sample cte query on AdventureWorks database which inbuilt in sqlserver. 

2.   RECURSIVE CTE:-
                                         A recursive CTE is a CTE which reference to itself in the CTE.

e.g.
In the example we will write a CTE for printing counting from 1-10.
  We define a CTE NumberSequence which calls itself inside the definition. 




and the result will be:







Access Viewstate Value On Different aspx Page

Kailash ChandelViewstate is used for state management in asp.net on same page. We can also access the Viewstate on other aspx page. For this we need to use server.transfer() method instead of response.redirect() method to redirect to the other page.

Let us have an aspx page named passviewstate.aspx . We will store two viewstates here as follow:

view state



And use server.transfer to redirect to another page named readviewstate.aspx .  We need to place a fuction of statebag class.

statebag

Now we will read these viewstate values on the page  readviewstate.aspx . For this we will create a function to read the the previous page's viewstate.


After creating the above function we will write code to show the viewstate values.



And we are done. Now we the values of two viewstate variables Name and Organisation in the labels lblMessage and lablOrganisation.






Thursday 7 March 2013

Max Maths Magic For Kids

Max Math Magic
Max Math Magic Application is our attempt to make learning maths to be fun for kids who have just been introduced to numbers and helps them grasp simple concept easily while making it fun for them.

Max Math Magic Application is very simple play and install into you Android phones its very entertaining game for everyone its give so much Excitement when you are playing Max Math Magic game. For Kids Its Very Enjoyable Game because kids love to solve problem by playing this game.

So its very attractive game Specially for kids its makes mind sharp and give Refreshment to the mind. You Can play Max Math Magic game anytime and anywhere you never feel bored. So if wants that your kids Learn math problem Easy by playing this Max Math Magic game Install Today and see the results.

How to get code from a published ASP.Net build where we don't have source code?

If you have ever lost or misplaced your source code for an ASP.Net web application, you might wonder if there is a way to recover it from th...