Friday, July 23, 2004
About the TabStrip WebControl
Wednesday, July 21, 2004
MSDN TreeView ASP.NET: search results
Tuesday, July 20, 2004
Using the TreeView IE Web Control
Sunday, July 18, 2004
SQL Server Forums at SQLTeam.com - Article: Dynamic ORDER BY
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.
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
Friday, July 16, 2004
Example: Regular Expression Matching a Valid Date
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. "
"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. "
Thursday, July 15, 2004
jscript
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;
}"
"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
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.
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.