A better way to create a dynamic SQL stored procedure(xerratus.com)

submitted by xerratus(415) 4 years, 4 months ago

This one has been plaguing me for years: What is the best way to create a dynamic stored procedure that allows null inputs to filter results? Today, while working on another request to come up with a dynamic stored procedure for a specific report a client wants, I had an epiphany. If I use isnull() in conjunction to with the actual value, I can get the desired results, no matter what input(s) are null -if any or all. read more...

add a comment |category: Database |Views: 5

tags: storedproc StoredProcedures Database SQL another

Community Server: Create custom image button control from CSLinkButton(xerratus.com)

submitted by xerratus(415) 4 years, 9 months ago

Describes how to create a custom composite control within Community Server that can be used to replace the ResourceLinkButton used in the WeblogPostCommentForm to display an image button. read more...

add a comment |category: ASP.NET |Views: 11

tags: another

Get baseUrl from Request object, not web.config(xerratus.com)

submitted by xerratus(415) 4 years, 9 months ago

Better programming by getting the baseUrl programmatically rather than depend on a web.config key. read more...

add a comment |category: C# |Views: 50

tags: another

IE7 Vista Flash Player Fix(xerratus.com)

submitted by xerratus(415) 5 years, 3 months ago

After installing Vista I found that IE7 would not show Flash content. This article explains how to fix it. read more...

1 comment |category: IE |Views: 251

tags: Flash IE Vista IE7 another

VS 2005 on Vista; Error "Unable to start debugging on the web server"(xerratus.com)

submitted by xerratus(415) 5 years, 5 months ago

How to solve. read more...

add a comment |category: Vista |Views: 8

tags: VisualStudio Vista another

How to get ASP.NET 2.0 Button WebControl to render as type="button"(xerratus.com)

submitted by xerratus(415) 5 years, 6 months ago

The default .NET Button WebControl renders as an input type="submit" control. This quick article describes how to get it to render as an input type="button" and the difference between the two. read more...

add a comment |category: ASP.NET |Views: 34

tags: Button ASP.NET another

.NET 2.0 FormsAuthentication Remember Me Challenge(xerratus.com)

submitted by xerratus(415) 5 years, 6 months ago

A few weeks ago, I posted a solution I came up with a way to utilize a remember me checkbox in .NET 2.0 that, when selected, pre-populated just the username in the username textbox during subsequent visits. The problem I found was that signing out of FormsAuthentication wiped out any and all cookies I had set during or prior to logging a user in. So, the simple act of looking at the cookie to see if the user wanted to be remembered became quite an ordeal. My solution was to set/get the cookie using JavaScript. There are some skeptics out there though. So, for them, I've created a very simple website solution that tries to set and get the remember me cookie as explained above. The challenge is to modify the solution so that it DOES work. read more...

1 comment |category: ASP.NET |Views: 13

tags: Authentication another

ASP.NET Encoding QueryString Data to Limit Tampering(xerratus.com)

submitted by xerratus(415) 5 years, 7 months ago

We've all been there. We develop a web application that uses the querystring to pass data from a master list page to a detail page. Usually just the ID is passed (just a good programming technique) and you even check and double check the value and type of data so that only the user who is supposed to see it, sees it. But the temptation to change the id for the user is too great and nobody ever likes seeing any type of identifier in the querystring. The solution I've developed simply encodes the querystring name/value pairs so that it is unreadable but can be retrieved and created with relative ease. read more...

add a comment |category: ASP.NET |Views: 254

tags: QueryString Encoding Security ASP.NET another

.NET 2.0 Global.asax code in separate file(xerratus.com)

submitted by xerratus(415) 5 years, 7 months ago

One of the subtle differences I've found while working with web projects in Visual Studio 2005 is the Global.asax code is placed in script tags within the actual .asax page, not a codebehind file, as it was with .NET 1.1. This article describes how to set up the Global.asax file to utilize the Global.asax.cs codebehind file. read more...

add a comment |category: ASP.NET |Views: 96

tags: Global.asax ASP.NET another

ConfigController class for normalizing web.config appSettings values(xerratus.com)

submitted by xerratus(415) 5 years, 7 months ago

Encapsulate appSettings from the web.config file in a static class that returns the variables as properties of the correct type. read more...

add a comment |category: ASP.NET |Views: 10

tags: appSettings web.config another

ASP.NET SmtpClient.Send() failure(xerratus.com)

submitted by xerratus(415) 5 years, 7 months ago

One solution to the following error: System.Net.Mail.SmtpException: Failure sending mail. read more...

add a comment |category: ASP.NET |Views: 18

tags: ASP.NET another

IE7's new ClearType font and how to disable it(xerratus.com)

submitted by xerratus(415) 5 years, 7 months ago

How to disable ClearType for IE7. read more...

1 comment |category: IE |Views: 8

tags: IE7 another

Annoying Invalid access to memory location exception solution(xerratus.com)

submitted by xerratus(415) 5 years, 7 months ago

The error in Visual Studio 2005 "Invalid access to memory location. (Exception from HRESULT: 0x800703E6). File: web.config." finally has a work around. I'm sure there are a lot of frustrated developers out there who will appreciate this article. read more...

add a comment |category: ASP.NET |Views: 868

tags: another

Find any control on the calling page from within a custom user control(xerratus.com)

submitted by xerratus(415) 5 years, 7 months ago

For when you need to access a control from within a user control where the ID of said control is passed in as a parameter. That was a mouthful. Basically, if you create a custom user control that takes in the ID of another control (let's say a TextBox) the user control cannot find a handle to that control using the standard Page.FindControl("TextBox1"). If TextBox1 exists on the main page (whether or not it's on a master page) and your custom control needs to access TextBox1, it cannot be accessed thru the Page.FindControl method directly. Luckily, there is recursion. read more...

add a comment |category: ASP.NET |Views: 4

tags: .Net another