Test Database Connection in C#

Tuesday, 22 February 2011 11:58

isconnectionsuccessful-errmessage-false-return-catch

// Test Database Connection in C#



public bool TestDbConnection(string connectString, out string errMessage)

        {

            bool isConnectionSuccessful = false;

            try

            {

                using (SqlConnection conn = new SqlConnection(connectString))

                {

                    conn.Open();

                    isConnectionSuccessful = true;

                }

                errMessage = string.Empty;

                return isConnectionSuccessful;

            }

            catch (SqlException sqlEx)

            {

                isConnectionSuccessful = false;

                errMessage = sqlEx.Message;

                return isConnectionSuccessful;

            }

            catch (Exception ex)

            {

                isConnectionSuccessful = false;

                errMessage = ex.Message;

                return isConnectionSuccessful;

            }

        }