HowTo: Use SqlParameters to pass parameters to querries and stored procedures

I have been working more and more with data recently and its a painstaking task. Alot of my time includes analysis of trades and financial information to create and calculate error free result sets. This also includes data cleanup..

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.
   * **/
}