Skip to main content

Posts

Showing posts from August, 2007

SQL SERVER : Selecting data from temporary tables & table variables using FOR XML

We can
convert the relational data stored in the table into XML by using the FOR XML
syntax, I am not going to the explain all the features of FOR XML.



Physical table


SELECT* FROM ASPNET_Roles FORXMLAUTO,ROOT ('A'),ELEMENTS

this select statement will give the following output
<A><URR_ASPNET_Roles>
<ApplicationId>AFFE3DDD-ABAD-49DF-A144-DA87BE69B90E</ApplicationId>
<RoleId>89C306A6-2D21-42AB-A42F-5029091CB4E8</RoleId>
<RoleName>SBU
User</RoleName>
<LoweredRoleName>sbu
user</LoweredRoleName>
<USER_TYPE>2</USER_TYPE>
</URR_ASPNET_Roles>
<URR_ASPNET_Roles>
<ApplicationId>AFFE3DDD-ABAD-49DF-A144-DA87BE69B90E</ApplicationId>
<RoleId>180BA05D-D2A5-49CA-BED3-3C6F080F6543</RoleId>
<RoleName>Super
User</RoleName>
<LoweredRoleName>super
user</LoweredRoleName>
<USER_TYPE>1</USER_TYPE>
</URR_ASPNET_Roles>
</A>


its is a perfect xml with all the node…

ApplicationName" property & its importance while configuring ASP.NET 2.0 role & membership features

Why applicationName ?
applicationName is provided so as to enable us to map different applications to same database

this is a sample configuration for the ASP.net 2.0 Roles



<roleManager>

<providers>

<add name="AspNetSqlRoleProvider"
connectionStringName="LocalSqlServer" applicationName="/"
type="System.Web.Security.SqlRoleProvider, System.Web, Version=2.0.0.0, Culture=neutral,
PublicKeyToken=b03f5f7f11d50a3a" />

<add name="AspNetWindowsTokenRoleProvider"
applicationName="/"
type="System.Web.Security.WindowsTokenRoleProvider, System.Web, Version=2.0.0.0, Culture=neutral,
PublicKeyToken=b03f5f7f11d50a3a" />

</providers>

you develop the site using all the advanced features its works perfectly but when the site is exported / published on another server, these features wont work !!!!

The problem
when we are using the 2.0 features asp.net automatically uses the virtual root folder name of the application …

Use vb & C# classes in same application (web app)

Use vb & C# classes in same application (web app)

In our application we mainly use only one type of class files say Vb or C#. what if we want to use two or more different language files in one web app ?

in app_code create two folders , let say vb & cs, and place the corresponding class files into it

add this piece of code to your web.config

<compilation debug="true" strict="false" explicit="true">
<codeSubDirectories> <add directoryName="vb"/>
<add directoryName="cs"/>
</codeSubDirectories>
</compilation>


you can use any folder name instead of VB or CS, the .Net compiler will look into each folder and try to compile all the class files found. But if it finds more than one different language files it throws an exception. the above piece of code will direct the compiler to check additional folders in App_code for class files for compilation.