USE PubS– Sort Each of PubName in Natural Alphabetic Order but push A’s to thelastselect * from publishersOrder by (CASE left(Pub_name,1) WHEN ‘A’ THEN 1000 ELSE ASCII(pub_name)END)–Sort Publishers By City

Server.MapPath() actually generates an additional requests to the Web server. A cheaper way to get the physical path for virtual root path of your website on the server is: Request.ServerVariables(“APPL_PHYSICAL_PATH”)

Windows has the solution: the IsCharAlphaNumeric function, defined in User32.dll. This function uses the currently defined locale when performing comparisons, thereby allowing full use of accented characters. This sample demonstrates

This code highlights the cell of a JTable when the cell is moused over. It includes its own Table cell renderer and a Mouse motion listener, for getting the mouse

A constructor that takes a single argument is, by default, an implicit conversion operator, which converts its argument to an object of its class, the keyword “explicit” can be placed

‘ Insert an image into a RichTextBox, in the current position” This version takes in input the target RichTextBox and the path of the image ‘ to insert’ Example: InsertImageIntoRtb(RichTextBox1,

‘ Return a reference to the control with the specified name,’ searched into the specified container and its sub-controls’ Note: it requires the GetAllControls function” Example: get a reference to

‘ Create an InputBox like the one of VB6. You can define the dialog’s title,’ question and default value.’ Example: MessageBox.Show(InputDialog.InputBox(“Type your name:”, “Test”,’ “Marco”))Public Class InputDialog Inherits System.Windows.Forms.Form#Region “

Have you ever tried to change the BorderStyle, HideSelection, MultiLine, ScrollBars, WordWrap and TextAlign properties of a TextBox, or the ComboBox

It happens quite often that you have a DataGrid with hidden columns (with width = 0), because you need their values but don’t want to show them to the user.

In ASP.NET 1.0 you have the option to maintain the session state on an external process, in SQL Server, by setting the mode attribute of the sessionState tag in web.config

When you create a custom Windows or Web control, compile it and add it to the Visual Studio .NET’s Toolbox, the control is added to the toolbox with a default

Anybody programming with ASP.NET knows that you can store custom application’s settings in the web.config file, under the section, and programmatically read the values through the ConfigurationSettings class. When the

When you create a DataGrid, it would be often good to specify its height, and have the DataGrid show a scrollbar if the content is longer than the given height.

ASP.NET 1.1 automatically validates input posted to the server against a list of potentially dangerous strings (the values are hard-coded, unfortunately, it would have been nice to be able to

This algorithm prints the bits from low to high order: #include using namespace std;int main() { int n; // number to convert to binary while (cin >> n) { if

This a very secure and unique way to override equal() and clone() a method of an object. class MyClass { public boolean equals(MyClass o) { boolean retVal = false; if(o

‘ Add a member to a COM+ application’s role, and return True if the operation ‘ is successfull’ Note: requires a reference to the COM+ Admin Type Library” Example: AddComPlusAppRoleMember(“MyComPlusApp”,