_pasteConInfo = new pasteConnectionInfo(); using (SqlConnection conn = new SqlConnection(_pasteConInfo.PasteConnectionString)) { SqlCommand cmd = new SqlCommand("EXECUTE sp_getCode 1", conn); cmd.Connection.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { testCase.Text = reader["code"].ToString(); } }