.NET (Core and Framework)

Jon Rista wrote:

Value types are allocated on the stack by default,

ferronrsmith wrote:

it's giving me hell

/// Used to determine whether we can connect to a db-instance as provided
/// By a connectionstring.
internal bool TryConnectToSqlInstance(string connectionString)
{
    using (SqlConnection con = new SqlConnection(connectionString))
        try
        {
            con.Open();
        }
        catch (SqlException ex)
        {
            MessageBox.Show(String.Format("{0}\n\nConnection string: '{1}'", Message, connectionString} 
                Application.ProductName,
                MessageBoxButtons.OK, 
                MessageBoxIcon.Error);
        }
        finally
        {
            while (con.State == ConnectionState.Connecting)
                Application.DoEvents();
            if (con.State == ConnectionState.Open)
                MessageBox.Show("Connection Succeeded!", 
                    Application.ProductName, 
                    MessageBoxButtons.OK,
                    MessageBoxIcon.Information);
        }
}

I are troll

string[] datasource = File.ReadAllLines("D:\\king.txt");
string connection = "Provider=SQLOLEDB; Data Source=" 
                    + datasource[0] 
                    + ";Catalog=STU_ATTENDANCE;User ID=sa;Password=sa; Network Library=dbmssocn";