Monthly Archives: September 2010
Xml to DropDownList
Sample of xml file.
<?xml version=”1.0″ encoding=”utf-8″ ?>
<unitedstates>
<state id=”AL” name=”AL – Alabama” />
</unitedstates>
ASP code
<asp:DropDownList ID=”ddlState” runat=”server” />
Code behind
XmlDataSource xml = new XmlDataSource();
xml.DataFile = Server.MapPath(“States.xml”);
ddlState.DataSource = xml;
ddlState.DataValueField = “id”;
ddlState.DataTextField = “name”;
ddlState.AppendDataBoundItems = true;
ddlState.DataBind();
SMTP Setup
<system.net>
<mailSettings>
<smtp from=”noreply@domain.com“>
<network host=”<hostname>” userName=”” password=”” />
</smtp>
<!– Save Email on your local machine
<smtp from=”noreply@domain.com” deliveryMethod=”SpecifiedPickupDirectory”>
<specifiedPickupDirectory pickupDirectoryLocation=”C:\emails\”/>
</smtp>
–>
</mailSettings>
<defaultProxy useDefaultCredentials=”true” />
</system.net>
Grant EXECUTE Permissions on all Stored Procedures to a Single User
DECLARE @SQL AS NVARCHAR(MAX);
DECLARE @newline AS NVARCHAR(2);
DECLARE @USER_NAME AS NVARCHAR(100);
DECLARE @sproc_name_pattern AS NVARCHAR(10);
SET @SQL = N”
SET @newline = NCHAR(13) + NCHAR(10);
SET @USER_NAME = N”;
SET @sproc_name_pattern = N’test[_]%’; — Pattern name: select stored procedure which starts with test_
SELECT @SQL = @SQL
+ N’GRANT EXECUTE ON ‘
+ QUOTENAME(OBJECT_SCHEMA_NAME([OBJECT_ID])) + ‘.’
+ QUOTENAME([name])
+ N’ TO ‘
+ QUOTENAME(@USER_NAME)
+ N’;’
+ @newline + @newline
FROM sys.procedures
WHERE [name] LIKE @sproc_name_pattern;
EXEC SP_EXECUTESQL @SQL;
If you have an error says “OBJECT_SCHEMA_NAME …”, you will need to upgrade your SQL Server to 2005 SP2 at least.