Yellow Pepper development

About the TabStrip WebControl

2004-07-23T00:05:00.000-07:00

About the TabStrip WebControl

MSDN TreeView ASP.NET: search results

2004-07-21T00:05:00.000-07:00

Search Results

Using the TreeView IE Web Control

2004-07-20T17:52:00.000-07:00

Using the TreeView IE Web Control

SQL Server Forums at SQLTeam.com - Article: Dynamic ORDER BY

2004-07-18T23:50:00.000-07:00

SQL Server Forums at SQLTeam.com - Article: Dynamic ORDER BY

Syntax error converting datetime from character string.
ORDER BY CASE WHEN ... THEN ...

To get around the datatype problem, use seperate group CASE statements for each datatype.
ORDER BY
CASE WHEN @SORTBY = 1 THEN Numeric1
WHEN @SORTBY = 2 THEN Numeric2
END,
CASE WHEN @SORTBY = 3 THEN VarChar1
WHEN @SORTBY = 4 THEN VarChar2
END DESC,
CASE WHEN @SORTBY = 5 THEN DateTime1
END

Note that each case block is seperated by a comma (after END) except the last block. Also note that you can use ASC or DESC for each CASE statement group.

Microsoft ASP.NET QuickStarts Tutorial

2004-07-18T11:49:00.000-07:00

Microsoft ASP.NET QuickStarts Tutorial

Example: Regular Expression Matching a Valid Date

2004-07-16T21:31:00.000-07:00

Example: Regular Expression Matching a Valid Date
"To match a date in mm/dd/yyyy format, rearrange the regular expression to (0[1-9]|1[012])[- /.](0[1-9]|[12][0-9]|3[01])[- /.](19|20)\d\d. "

jscript

2004-07-15T16:39:00.000-07:00

jscript
"The function isNumber looks like this:
function isNumber(theElement, theElementName)
{
s = theElement.value;
if ( (s == '') || (isNaN(Math.abs(s)) && (s.charAt(0) != '#')))
{
if ( isNumber.arguments.length == 1 )
alert( ' Value must be a number.' );
else
alert( theElementName + ' Value must be a number.' );
theElement.focus();
return false;
}
return true;
}"

ASP.NET: Selectively Enable Form Validation When Using ASP.NET Web Controls -- MSDN Magazine, April 2002

2004-07-15T14:08:00.000-07:00

ASP.NET: Selectively Enable Form Validation When Using ASP.NET Web Controls -- MSDN Magazine, April 2002
The ASP.NET form validation controls, while powerful and easy to use, require that the entire page be valid before it's submitted back to the server. Through the use of the new object-oriented features of Visual Basic .NET, it is possible to extend their functionality to overcome this limitation.
This article tells you how and helps you decide when it's a good idea to keep validation on the client and when you'd be better off disabling it.

DARTZ SMS SCHEDULER

2004-07-07T16:16:00.000-07:00

DARTZ SMS SCHEDULER

Getting the current path of my application

2004-06-30T22:18:00.000-07:00

Re: Getting the current path of my application :

System.Environment.CurrentDirectory
AppDomain.CurrentDomain.BaseDirectory

317421 - HOW TO: Create a Setup Project for a Windows Service in Visual Basic .NET

2004-06-30T20:31:00.000-07:00

317421 - HOW TO: Create a Setup Project for a Windows Service in Visual Basic .NET
To tell the deployment project what it should package, follow these steps:
In Solution Explorer, right-click ServiceSetup, point to Add, and then click Project Output.
In the Add Project Output Group dialog box, in the Project box, click LogWriterService.
Click Primary Output, and then click OK.
For proper installation, you are only required to add primary output. To add the custom actions, follow these steps:
In Solution Explorer, right-click ServiceSetup, point to View, and then click Custom Actions.
Right-click Custom Actions, and then click Add Custom Action.
Click Application Folder, and then click OK.
Click Primary output from LogWriterService (Active), and then click OK. Notice that Primary output appears under Install, Commit, Rollback and Uninstall.
Setup projects are not included in the build configuration by default. To build the solution, follow these steps:
Right-click LogWriterService, and then click Build. Subsequently, right-click ServiceSetup, and then click Build.

Chapter 14 - Improving SQL Server Performance

2004-06-23T16:04:00.000-07:00

Chapter 14 - Improving SQL Server Performance

.NET 247 : Command Builder vs. Loop. - on ASPFriends.com 'aspngdata' list

2004-06-23T12:19:00.000-07:00

.NET 247 : Command Builder vs. Loop. - on ASPFriends.com 'aspngdata' list

Array sorting example

2004-06-17T11:08:00.000-07:00

private class Game
{
internal GameEnum GameEnum;
internal int Position;
internal Game(GameEnum gameEnum, int position)
{
GameEnum = gameEnum;
Position = position;
}
}

private class GameComparer : System.Collections.IComparer
{
public int Compare(object x, object y)
{
// We are going to sort array of positions.
// We want to have the smallest position at the begining of sorted array
// We want "i1" value at the end of the array
Selector.Game gameX = (Game)x;
Selector.Game gameY = (Game)y;
int xPosition = gameX.Position;
int yPosition = gameY.Position;

if (xPosition == yPosition)
return 0;
if (xPosition == -1)
return 1; //Moves x to the end of the sorted array
if (yPosition == -1)
return -1; //Moves x toward beginning of the sorted array
if (xPosition < yPosition)
return -1; //Moves x toward beginning of the sorted array
else
return 1; //Moves x toward the end of the sorted array
}
}

The Code Project - Handle multiple configuration files - C# Programming

2004-06-16T17:31:00.000-07:00

The Code Project - Handle multiple configuration files - C# Programming
Here is another recipe for cooking up and serving your own configuration files. And I mean any configuration file, not just your ready-to-serve app.config and web.config files. Readers who need a refresher on the configuration file layout or mechanics can see prior articles published here or other references.

Convert Image into MMS (cell phone) format

2004-06-11T00:13:00.000-07:00

using MMSEngineLib;

MMSSimpleMessage objSimpleMessage = new MMSSimpleMessageClass();
MMSEngineLib.MMSImageMediaElement objImage=
objSimpleMessage.MediaElements.AddImage(@"D:\Dennis\projects\MMS\xmasmicro.jpg");
objSimpleMessage.GenerateMMSMessage(@"D:\Dennis\projects\MMS\xmasmicro.mms");

HOW TO: Send and Receive Binary Documents by Using an ASP.NET Web Service and Visual C# .NET

2004-06-07T14:33:00.000-07:00

Send and Receive Binary Documents by Using an ASP.NET Web Service and Visual C# .NET