Announcements, January Strongest Coders, and February Prizes

Announcements


Continuation of the 1st MVP Live Chat


Join the Strong Coders Community, Scott Guthrie, General Manager, Microsoft Developer Division, and Microsoft MVPs for the continuation of the 1st MVP Live Chat on Friday, February 16, 2007 from 8:00pm-9:00pm EST. Get your tough questions answered by experts. No question is too hard.


The chat will take place on MSDN Chats. See details below. Also, don’t forget to add the date to your calendar. See you there.


Calendars:
http://msdn.microsoft.com/chats/
http://www.microsoft.com/communities/chats/default.mspx


ICS: http://msdn.microsoft.com/chats/outlook_reminders/07_0216_MSDN_ASPNET.ics


Post Of The Month


There is something new at the Strong Coders Community in February. Beginning this month, you can win a prize for posting a question! The best original question, as voted by the moderators, will win a fabulous prize. The winning poster this month will receive a copy of Infragistics NetAdvantage for .NET 2006 with priority support.


January Strongest Coders


Congratulations to the January Strongest Coders. Thanks to those members for answering questions day and night.


1st Place – Dean Fiala (dfiala)
2nd Place – James Curran (JamesCurran)
3rd Place – Doug Nelson (doug.nelson)


For a recap of what they won, see http://community.strongcoders.com/forums/thread/1497.aspx.


February Prizes


The February Strongest Coders will receive a copy of ComponentArt Web.UI Developer License for ASP.NET version 2006.2, which is compatible with ASP.NET 1.0, 2.0, and ASP.NET AJAX.


Answer questions, win prizes.
ASK questions, win prizes.


Thanks for visiting!


http://community.strongcoders.com/


Generic ExecuteScalar method

Just wanted to share with everyone the generic helper method I use for ExecuteScalar. A helper method for ExecuteScalar is the perfect candidate for generics due to the different types that could be returned. Of course, you could always return an object, but this is more fun. :)


        public static T ExecuteScalar<T>(string commandText, string connectionString)

        {

            return ExecuteScalar<T>(commandText, connectionString, null);

        }

 

        public static T ExecuteScalar<T>(string commandText, string connectionString, params SqlParameter[] parameters)

        {

            T result = default(T);

            if (!string.IsNullOrEmpty(commandText))

            {

                using (SqlConnection connection = new SqlConnection(connectionString))

                {

                    using (SqlCommand command = new SqlCommand(commandText, connection))

                    {

                        if (parameters != null && parameters.Length > 0)

                        {

                            foreach (SqlParameter parameter in parameters)

                            {

                                command.Parameters.Add(parameter);

                            }

                        }

                        connection.Open();

                        result = (T)command.ExecuteScalar();

                        connection.Close();

                    }

                }

            }

            return result;

        }


Snap and Community Server

Up until an hour ago, this site was using Snap to render web page previews of images and links that linked to external sites. However, this caused the following JavaScript error when using the roles modal in Control Panel > Administration > Membership > Browse People / Find People.

Line: 63
Char: 7
Error: ‘document.forms.0.AssignedValues’ is null or not an object
Code: 0

The only workaround was to remove Snap.


Don’t miss the continuation of the 1st MVP Live Chat!

Join the Strong Coders Community, Scott Guthrie, General Manager, Microsoft Developer Division, and Microsoft MVPs for the continuation of the 1st MVP Live Chat on Friday, February 16, 2007 from 8:00pm-9:00pm EST. Get your tough questions answered by experts. No question is too hard.


The chat will take place on MSDN Chats. See details below. Also, don’t forget to add the date to your calendar. See you there.


Calendars:
http://msdn.microsoft.com/chats/
http://www.microsoft.com/communities/chats/default.mspx


ICS: http://msdn.microsoft.com/chats/outlook_reminders/07_0216_MSDN_ASPNET.ics


Charles Carroll talks about me behind my back

I suspected Charles Carroll would talk about me behind my back, but also discovered that he was talking about Dana Coffey and Bill Ryan behind their backs. It’s a good idea when you do that to make sure it doesn’t come back to me. I have all of the emails that trashed me and others, and have published them as a page on this site instead of part of this blog entry as some of Charles emails contain explicit language, and I didn’t want to offend any of my readers. For those interested in reading his ramblings and my responses to all of his accusations, see Charles Carroll Non-Sense Ramblings. As you’ll see, he can’t send emails to his followers without making a fool of himself. I can’t begin to understand how the followers he has left, many of them bright and very smart, can continue to be his friend after these emails. Not one of them found those emails as being questionable. The few the responded believed him and bought into it.