Timeout expired. The timeout period elapses prior to completion after "cmd.ExecuteNonQuery" is run.

--- Table (Called "Nodes" on "DMS" DB) Design ---
1. 1stColumn = NodeID, PK, bigint, not null, 
2. 2ndColumn = Name, varchar(75), not nulll, 
3. 3rdColumn = PingStatus, varchar(50), not null, 
4. 4thColumn = IPAddress, char(15), null)
------- C# CONSOLE APP CODE ----------------------
namespace RmEndpiontStatus
{
    class PingEndpoints
    {
        
        static void Main()
        {
            // retrieves endpoint list from db
            SqlConnection conn = new SqlConnection(SettingsManager.ConnectionString);
            SqlDataReader rdr = null;
 
            try
            {
                conn.Open();
                Console.WriteLine("DB Connection has been opened\n");
                
                // create sql command
                SqlCommand cmd = new SqlCommand("usp_GetNodes", conn);
                SqlCommand rcdCount = new SqlCommand("SELECT Count(*) FROM Nodes", conn);
                UInt32 totalRows = Convert.ToUInt32(rcdCount.ExecuteScalar());
                cmd.CommandType = System.Data.CommandType.StoredProcedure;
 
                // configure input parameters
                SqlParameter param = new SqlParameter();
                param = cmd.Parameters.Add("@Endpoints", System.Data.SqlDbType.VarChar, 75);
                param.Direction = System.Data.ParameterDirection.Input;
 
                //Console.WriteLine(String.Format("There are {0} records in the database.", totalRows));
                //Console.WriteLine("\n");
                //Console.WriteLine("Press any key to continue...");
                //Console.ReadLine();
 
 
                rdr = cmd.ExecuteReader();
 
                if (rdr.HasRows)
                {
                    //int currentRow = 0;
                    while (rdr.Read())
                    {
 
                        // Check and make sure Host is still in DNS
                        try
                        {
                            string hostname = rdr[0].ToString();
                            IPHostEntry IPHost = Dns.GetHostEntry(hostname);
                            foreach (IPAddress address in IPHost.AddressList)
                            {
                                if (address != null)
                                {
                                    Console.WriteLine(String.Format("Host IP Address for {0} is {1}", hostname, address));
                                    PingHosts(address);
                                }
                            }
                        }
                        catch (Exception ex)
                        {
                            Console.WriteLine("Error occurred: " + ex.Message);
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine("Error occurred: " + ex.Message);
            }
            finally
            {
                if (rdr != null)
                {
                    rdr.Close();
                }
 
                if (conn != null)
                {
                    conn.Close();
                }
            }
        }
 
        public static void PingHosts(IPAddress address)
        {
            Ping pSend = new Ping();
            PingReply pReply = pSend.Send(address);
 
            //pSend.Send(address);
 
            if (pReply.Status == IPStatus.Success)
            {
                // setting up connection object
                SqlConnection conn = new SqlConnection(SettingsManager.ConnectionString);
                conn.Open();
 
                // setting up command objects
                SqlCommand cmd = new SqlCommand("usp_PingStatus", conn);
                cmd.CommandType = System.Data.CommandType.StoredProcedure;
 
                // creating output parameter (as objects)
                // & adding to parameter collection
                string successVal = "";
                SqlParameter param = new SqlParameter();
                param = cmd.Parameters.Add("@Status", System.Data.SqlDbType.VarChar, 50, "PingStatus");
                param.Direction = System.Data.ParameterDirection.InputOutput;
                param.Value = "Reachable";
 
                // execute the query
                cmd.ExecuteNonQuery();
 
                Console.WriteLine(param.Value);
                Console.ReadLine();
                conn.Close();
            }
        }
 
    }
}
--------------- STORED PROCEDURE Code -------------------------------------------------------
USE DMS
GO
 
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
 
ALTER PROCEDURE usp_PingStatus 
	-- variable(s)
	@Status varchar(50) OUTPUT 
 
AS
IF @Status is not null
BEGIN
	UPDATE nodes SET PingStatus = @Status;
END
ELSE
BEGIN
	RETURN;
END
GO

Select allOpen in new window