Sudhakar’s Blog

தமிழும் காவேரியும் தான் தமிழ் நாட்டுக்கு பெருமை……
காவேரியோ நாம் வீட்டுக்குள் வர மாறுகிறது…..
தமிழோ நாம் வீட்டை விட்டு வெளியே சென்று கொண்டிருக்கிறது….
இரண்டையும் மீட்கும் பொறுப்பு…….
தமிழா  உனக்கு……

- சுபவீ

Extensible Stylesheet Language Transformations (XSLT) is an XML-based language used for the transformation of XML documents into other XML or “human-readable” documents. The original document is not changed; rather, a new document is created based on the content of an existing one.^[2] The new document may be serialized (output) by the processor in standard XML syntax or in another format, such as HTML or plain text.^[3] XSLT is most often used to convert data between different XML schemas or to convert XML data into HTML or XHTML documents for web pages, creating a dynamic web page, or into an intermediate XML format that can be converted to PDF documents.

                                               

72% I Passed with an Average Score

Free Online Dating from JustSayHi

A common table expression (CTE) can be thought of as a temporary result set that is defined within the execution scope of a single SELECT, INSERT, UPDATE, DELETE, or CREATE VIEW statement. A CTE is similar to a derived table in that it is not stored as an object and lasts only for the duration of the query. Unlike a derived table, a CTE can be self-referencing and can be referenced multiple times in the same query.

A CTE can be used to:

• Create a recursive query. 
• Substitute for a view when the general use of a view is not required; that is, you do not have to store the definition in metadata.
• Enable grouping by a column that is derived from a scalar subselect, or a function that is either not deterministic or has external access.
• Reference the resulting table multiple times in the same statement.

The basic syntax structure for a CTE is:

       WITH expression_name [ ( column_name [,...n] ) ]

       AS

       ( CTE_query_definition )

The list of column names is optional only if distinct names for all resulting columns are supplied in the query definition.

The statement to run the CTE is:

SELECT <column_list>

FROM expression_name

EG.

WITH CTE_ProductAndCategoryNamesOverTenDollars (ProductName, CategoryName, UnitPrice) AS
(
   SELECT
      p.ProductName,
      c.CategoryName,
      p.UnitPrice
   FROM Products p
      INNER JOIN Categories c ON
         c.CategoryID = p.CategoryID
   WHERE p.UnitPrice > 10.0
)

SELECT *
FROM CTE_ProductAndCategoryNamesOverTenDollars
ORDER BY CategoryName ASC, UnitPrice ASC, ProductName ASC

anonymous access is one of the authentication method that IIS follows to authentiate any user who visit your site. In this method  IIS allows everybody to visit the public areas of your site. anonymous users are assigned by default to the IUSR_MachineName account, which is a valid Windows account that is a member of the Guests group.

how to set this access method for a site.

Go to IIS –> Virtual Directory –> right click (select properties) –> click directory security tab

 Here you can set the anonymous access.

Now comes the point of controlling it from my .NET application.

We have an element in the web.config file called IDENTITY to control this.

identity impersonate=”true|false”
          userName=”domain\username”
          password=”password”/>

Now if i say impersonate = true and give any USerName and password, it is same as we do in the above figure.

The behaviour of your site differs with each combination of this element with authentication mode (windows/forms).

URL rewriting is the way of hiding the complex URL’s from the user and
show him a friendly URL. when we have some nested folder structure in our
application, then the user finds it really difficult to remember the URL
and at this point the URL rewriting helps. 

ASP.NET 2.0 makes it simple for the developers. we have an option in the
web.config file called urlMappings where we can set the requested URL
and the URL to be displayed to the user.

<urlMappings>   
 <add url=”~/DVD/Matrix.aspx”
  mappedUrl=”~/DVDCategory.aspx?Category=1″/>   
 <add url=”~/DVD/Titanic.aspx”
  mappedUrl=”~/DVDCategory.aspx?Category=2″/>
<urlMappings>

whenever a request is made to the server as matrix.aspx, the server will be
executing the URL as DVDcategory.aspx?category=1. Here the user will be
seeing the URL as matrix.aspx which will be easy for him to remember.

But when it comes to dynamic URL’s where the URL’s will be created only on the fly,
then this method will not help.

 

 

Kalki Krishnamurthy was a great Tamil writer. I haven’t read all his books. one of the best historical novel written by an Indian is Sivakamiyin Sabatham (The oath of Sivakami), authored by him. I have been and still am his

  

admirer since that time. Kalki’s description of the landscape and social conditions portrayed the Thamizh region exactly the way they were at the time of the story. The characters in the story lived up to their image. The romantic scenes (OODAL & KOODAL) were handled with finesse and grace and would be a good lesson to anyone interested in writing about love at its deepest level. The clash of human emotions and interactions and the religious sectarian tendencies which prevailed at the time flashed before the eyes of the reader. Indeed the historical details in Kalki’s novels were presented in such a way that one learnt more about the history of the Thamizh region by reading Kalki’s novels rather than through formal courses at school !

 Kalki was and will remain in Thamizh Literature Through the Ages……

We all know that we need web.config file in a web application. But it is fact that the application will also run even without a web.config file, taking all the necessary settings from machine.config file. whereas we will not be able to debug without web.config file.

 .pdb files are the program database files that are created when the application is compiled in VS.NET. These files contain the debug symbols that will be required during the debug process. whenever a code change is made in the application these .pdb files are updated with the new symbols. The runtime will check for the debug attribute in the web.config file and creates the .pdb files in the bin folder.

Reference from MSDN 

 

A program database (PDB) file holds debugging and project state information that allows incremental linking of a debug configuration of your program. A PDB file is created when you build with /debug (Visual Basic/C#/J#/JScript). You can build Visual Basic, C#, and J# applications with /debug:full or /debug:pdbonly. Building with /debug:full generates debuggable code. Building with /debug:pdbonly generates PDBs but does not generate the DebuggableAttribute that tells the JIT compiler that debug information is available. Use /debug:pdbonly if you want to generate PDBs for a release build that you do not want to be debuggable.

The Visual Studio debugger uses the path to the PDB in the EXE or DLL file to find the project.pdb file. If the debugger cannot find the PDB file at that location, or if the path is invalid, for example, if the project was moved to another computer, the debugger searches the path containing the EXE followed by the symbol paths specified in the Options dialog box. This path is generally the Debugging folder in the Symbols node. The debugger will not load a PDB that does not match the binary being debugged.

I am starting this blog for my future reference. Let me call this as a experience of writing and sharing the knowledge. i started to blog after seeing my manager’s blog. He is one of the finest man i’ve come accross. you can visit his blog here –> www.vadivel.blogspot.com don’t miss out this blog, you might get all you wanted there.