devxlogo

Tip Bank

Get Date by Totaling All Seconds

Question: How do I get the total number of seconds between two dates? Answer: You can use the DATEDIFF function to calculate the difference between two dates. The value can

Sqlhosts

Question: Why when I try to run sqlexecd to set up ODBC do I get an error: -25553 unable to load locale categories. Answer: Check your environmental variables. If you

Multiple Entries That Meet Criteria

Question: How can I pull just the first match to a query? We have a database of jobs in process: jobno 12345op# 10 shear %complete 100op# 20 punch % complete

Designing Tiers and Placing Business Rules in Them

Sometimes in a multi-tier system, designers tend to follow rigid object-oriented design rules to perform heavy data-centric manipulations in the middle tier. Remember, a thin line separates the operations that

Changing Link Color with Mouseovers

Question: How can I change the color of a link when the mouse is over the link? And how can I remove the line that underlines the links? I am

Using XSLT to Comma Delimit Node Values

Question: I have the following code in an XML file: Fredonia AFB Russia Luka Russia 140N4506 64E3507 Sevastopl Bosie 140N4506 64E3507 Ukraine How can I set up an XSL sheet

Creating Frames

Question: I want to make a simple frame for my Web site, but I don’t know how. I’ve looked through your tutorial but I still don’t fully understand. Can you

Display an animated GIF using the WebBrowser control

The standard PictureBox control doesn’t support the Animated GIF graphic format. However, you can display these images by using a WebBrowser control: WebBrowser1.Navigate “c:ImagesAnimated.Gif” The only problem of this technique