Monthly Archives: July 2009

Visual Studio Designer Support for Stored Procedures

Posted on July 21, 2009 by amissico

ALTER PROCEDURE [dbo].[DeleteComponent]       @cmpID INT –parameter name must match key column’s name, for vs.designer support AS T-SQL parameter name must match key column’s name, for Visual Studio designer support.

Posted in Development | Leave a comment

Recursive FindControl; FindControlRecursive

Posted on July 21, 2009 by amissico

After reviewing the most “popular” recursive FindControl methods in “blogs”, I find that all the implementations perform recursion first then compare control identifiers. All the “bloggers” complain of performance issues when performing the recursion, but not one programmer notices they … Continue reading →

Posted in Code Library | 1 Comment

ASP.NET’s Literal vs. LiteralControl

Posted on July 21, 2009 by amissico

I have seen lots of code like the following when adding text programmatically to a web page. Dim oLiteral As New Literal oLiteral.Text = "<table>" container.Controls.Add(oLiteral) It seems silly to have to create the control then make the Text property … Continue reading →

Posted in Development | Leave a comment

Abbreviated Syntax of VB for Array Definition

Posted on July 21, 2009 by amissico

The C# way to define an array of list items in Visual Basic: Dim listItems As ListItem() = New ListItem(items.Length – 1) {} The abbreviated syntax of VB to do the same thing: Dim listItems(items.Length – 1) As ListItem

Posted in Development | Leave a comment

Check Box Padding

Posted on July 21, 2009 by amissico

http://msdn.microsoft.com/en-us/library/ms535262(VS.85).aspx Remarks When an INPUT type=checkbox element is selected, a name/value pair is submitted with the FORM. The default value of INPUT type=checkbox is on. The height and width styles are exposed to the INPUT type=checkbox element as of Microsoft … Continue reading →

Posted in Development | Leave a comment

Using Single Line Object Creation with Call Method in Visual Basic

Posted on July 9, 2009 by amissico

Many times you have to create a temporary object variable in order to perform/call some method. Dim oPlaceHolder As New System.Web.UI.AttributeCollection(bag) oPlaceHolder.Render(writer) In C#, you can do… New System.Web.UI.AttributeCollection(bag).Render(writer); There has to be an easier way in VB and there … Continue reading →

Posted in Uncategorized | Leave a comment

Download Cache

Posted on July 9, 2009 by amissico

Question: With VSTO 2005/Excel 2003, we were able to use System.Reflection.GetExecutingAssembly.Location to obtain the path to the add-in assembly. With VSTO 2005/Excel 2007 the return value has changed to “C:\Documents and Settings\<username>\Local Settings\Application Data\assembly\dl3\Q0G97ZAE.ZN2\D7ZDXCJ1.7DR\63345ad5\54a51f05_b4fbc601\", which is not expected. I’ve changed … Continue reading →

Posted in Development | Leave a comment