On the other hand, there is SQL SMO (SQL Management Objects) the new set of classes designed to be the next generation of classes to serve as replacement to the old SQL-DMO. In this article, i'll show you how to programmatically retrieve a list of available SQL Servers on the network and then retrieve the underlying databases on that SQL Server.

There are alot of ways to accomplish this. The simplest one is to use the sp_databases procedure. Here's some example that uses this stored procedure in conjunction with ADO.NET to consume the returned data.

A code i wrote that i think some should follow and understand about the Da Vinci Code movie. It's currently incomplete... with alot of TODO sections for me and people who would be watching the movie. I'll complete the code once i finish watching the movie so that i could set a comparisson of things from truth and fiction. I have seen a couple of documentaries(History Channel and Discovery Channel) about it and had formulated my on personnal beliefs regarding the issues that evolve around the movie.

foreach (Person person in DaVinciCodeMovie.MovieGoers)
{
   //TODO:
   /* 1.) Analyze the movie: View the movie with an eagles eye. Be attentive
   *       and concern about the scenes. Open your eyes and try to figure
   *       ideas that were presented in it so that you could research about it.
   * 2.) Research: Don't just watch and ponder about how good the movie is
   *       and just stop and believe everything that you see on it. Do a
   *       personal research about the facts and fiction prsented on the
   *       movie. dont base your belief on first impression but check and
   *       find out for youreself if it is really true or not. Go and checkout
   *       respectable documentary and television channels about their views
   *       about the movie and compare truth and fiction side by side so that
   *       you could give an honest conclusion about its reality.
   * 3.) Make an honest conclusion: This is the only for you to have a true 
   *       conviction. Remember, the truth is the only thing that could set you
   *       free and honesty makes the truth pleasing to your heart and mind.
   * **/
}

using System;
using System.Collections.Generic;
using System.Text;

namespace KeithRull.CS.Windows.DevCenterConsole
{
   class TemperatureCalculation
   {
      static void Main(string[] args)
      {
         this.ShowCalculation();
      }

      public void ShowCalculation()
      {
         double celsius = 44.5;

         double fahrenheit = CelsiusToFahrenheit(celsius);

         Console.WriteLine(fahrenheit);

         celsius = FahrenheitToCelsius(fahrenheit);

         Console.WriteLine(celsius);
      }

      //formulas are taken from
      //http://vathena.arc.nasa.gov/curric/weather/fahrcels.html

      public static double CelsiusToFahrenheit(double celsius)
      {
         /*
            Tc=(5/9)*(Tf-32) 
            Tc=temperature in degrees Celsius 
            Tf=temperature in degrees Fahrenheit 
         * */
         return (((0.9 / 0.5) * celsius) + 32);
      }

      public static double FahrenheitToCelsius(double fahrenheit)
      {
         /*
            Tf=(9/5)*Tc+32 
            Tc=temperature in degrees Celsius 
            Tf=temperature in degrees Fahrenheit 
         */
         return ((0.5 / 0.9) * (fahrenheit + 32));
      }
   }
}

pretty boring stuff...

The Repeater control is probably the most over used control in the company that i currently work for. Almost every grid and listing has been built using this and i has made me nuts when i first started using it since i consider myself a Datagrid or a DataList guy. One of the things I hate about it is that usually, people try to format everything in a way that the Visual Studio.NET IDE barks, squels and cry. Adding those pesky <%%> all over the code which makes the page resemble an old ASP page that any developer who has thrown those coding style into the trash bin have nightmares and gloom scapes all over their nightly pundit rest. And since I am a good employee who follows strict coding guidelines and comply with it with utmost care.... i decided to embrace it rather than to do a holy war against this control. But i need to do something to make my life easier. With that I built this control...

Damn! This is freaking cool! I can't wait to use my skype to call friends all over US and Canada! I hope this can extend more than December 2006 and cover more places too!