Friday, May 04, 2007

Allow html tags in textbox fileds asp.net

HTML tags can be allowed in asp.net pages by having the following attributes in the page level for a particular page.

validateRequest="false"

eg. <%@ Page Language="C#" validateRequest="false" at the top of the aspx page.

Or

add the
<system.web>
    <pages validateRequest="false">

on your web.config for all the pages.

Happy programming,
Anton

Labels:

Wednesday, May 02, 2007

Registering an Extended Stored Procedure in SQL Server

This is to supplement the sp_addextendedproc documentation in Books Online.

USE master
EXEC sp_addextendedproc 'xp_yourExtendedFunction', 'xp_ExtendedDLL.dll'

For this to work you need to copy the xp_ExtendedDLL.dll to the BINN directory of the SQL Server.

for default installation of
SQL Server 2000
C:\Program Files\Microsoft SQL Server\MSSQL\Binn

SQL Server 2005
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn

Happy programming

Labels: