I have this method that gets the connection string. I first have a method that builds the connection string. Then I open the connection and finally I try to execute a SQL stored procedure against this connection. As soon as I try to execute the sp I get the message "Connection property has not been initialized" What am I missing and how do I correct this?
public static SqlConnection GetConnection(string ConnectionString)
/* Create and open a connection to the SQL Server */
/* Return open connection object */
SqlConnection SQLConn = new SqlConnection();